Track your database environment health
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.
Monitor real-time and historical database performance
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.
Identify SQL Server query tuning opportunities
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.
Analyze SQL Server blocking
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
Find and diagnose SQL Server deadlocks
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
Gain insight into tempdb activity and utilization
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.
Ready to see SQL Server performance details at a glance?
