With the SQL Sentry Portal, you can view detailed, actionable information on the performance of your monitored SQL Server, Azure SQL Database, and Windows targets from your web browser.
The SQL Sentry Portal connects to your SQL Sentry database and displays important performance information in an easy-to-use web interface.
Reference the health score for your database environment
View alerts and important performance metrics
Create custom dashboards
Analyze SQL Server queries
Easily share monitoring dashboards and alerts with others in your organization
See the health status for all your monitored targets and the most recent alerts in the Health view. You can view alerts by severity and tag to quickly identify conditions that are slowing database performance, and drill down into individual alerts for more details.
View important performance metrics for your monitored targets, including:
SQL Server activity, waits, I/O, and memory
Windows OS network utilization, CPU usage, I/O, and system memory
You can see real-time data or data for a specific time period using the default Dashboard view or by creating custom charts and dashboards to display the metrics that are most important to you.
Quickly spot queries that are affecting SQL Server performance with the Top SQL view. Analyze high-impact SQL Server queries, view query plan diagrams, and drill down into the query history for details about the execution plan, such as query duration, CPU consumption, and number of reads and writes performed.
Quickly identify the root cause of SQL Server blocking in the Blocking view. With an intuitive graphical representation of a blocking chain, you can easily analyze blocking details and view the relationships between blocking and blocked sessions.
View blocking by application, wait resource, or wait type
Expand a blocking chain to view blocked sessions to understand the full impact of a block
Switch between versions of a blocking chain to see if blocked SPIDs were added or removed
View query text with syntax highlighting for any session within a blocking chain
Efficiently troubleshoot deadlocks that have occurred on your monitored targets in the Deadlocks view. The simple, intuitive deadlocks diagram makes it easy to analyze the events that led to the SQL Server deadlock.
Select a node in the deadlock diagram to view detailed information about the process or resource
View the raw XML file for a selected deadlock
Drag and drop saved deadlock files into the Deadlock Diagram pane to see a diagram and additional information about that deadlock
With the TempDB view, you get enhanced visibility into the health and performance of tempdb. Easily analyze file space usage across your tempdb data files, and tempdb objects, activity, and session usage for SQL Server and Azure SQL Database.