The Resources tab of the single instance dashboard allows you to monitor the system resources on the computer hosting the SQL Server instance as well as what is used by SQL Server. Use the Queries tab of the single instance dashboard to quickly view the results of queries running on your SQL Server instance. The Queries The Resources tab contains the following tabs:
Image Removed
Image Added
...
...
...
Summary
The Signature Mode tab includes all active query information, automatically reduced to the signatures and grouped accordingly. For Summary tab displays real-time charts that allow you to quickly view key diagnostic statistics for monitoring the resources for the selected SQL Server instance and computer on which it resides. For more information about using this view and fields, see the help topic for the desktop version at: View the query monitor signature mode Get the resource performance summary.
Image Removed
Image Added
...
...
...
CPU
The Statement Mode tab includes queries that are presented exactly as they are collected by the Query Monitor Trace CPU tab displays key CPU statistics that are updated according to your refresh interval. For more information about using this view and fields, see the help topic for the desktop version at: Get CPU performance details.
Image Added
Memory
The Memory tab displays the dynamic memory currently in use by SQL Server as well as how that memory satisfies the requirements of SQL Server components. For more information about using this view and fields, see the help topic for the desktop version at: View the query monitor statement mode Get memory performance details.
Image Removed
Image Added
...
...
...
Disk
The Query History Disk tab gives allows you a view of the performance of a query over timeto view key statistics on the way your disks are used on the computer hosting your SQL Server instance. For more information about using this view and fields, see the help topic for the desktop version at: View the query history Get disk performance details.
Image Removed
Image Added
...
...
...
The Query Waits tab
...
Disk Size
The Disk Size tab allows you to view key statistics on the way your disks are used on the computer hosting your SQL Server instance
...
. For more information about this view and fields, see the help topic for the desktop version at: Get disk size details.
Image AddedView query waits.