The Instance identification indicators on the SQL Server real-time dashboard allow you to identify the currently monitored instance, its type and its operation period.
These indicators are as follows:
• Instance name — identifies the currently monitored instance.
• Specified time range — indicates the period of time for which data is being displayed (by default: last 60 minutes).
• Instance pane — contains the following indicators:
- DB Type — identifies whether the monitored database’s type is SQL Server, Sybase, DB2, or Oracle.
- DB Version — identifies the SQL Server version number, along with the most recently installed service packs.
- Up Since — identifies the date and time when the instance was last started.
* NOTE: The pane’s initial view only shows the date; to display the time as well, hover the mouse on the instance status icon ().
- OS Version — identifies the operating system’s version number, along with the most recently installed builds and service packs.
* NOTE: The pane’s initial view only shows the OS name; to display the build and service packs as well, hover the mouse or click the OS name’s txt.
- Response Time — the time (in milliseconds) that elapses from the moment a query, which is supposed to represent the general workload, is submitted, until the application indicates that the query was executed.
Because the response time is usually the starting point for investigation, the Response parameter leads to the SQL Instance Summary panel in the SQL Activity drilldown.
• CPU (%) and Memory (%) — the average CPU load and memory consumption (percentage), during the specified time range, of all CPU units that host the SQL Server instance. This indicator displays the share of SQL Server-incurred CPU load and memory consumption within the total figure.
Clicking the number on both icons displays a popup that shows the total CPU usage or memory consumption on the currently monitored host, plotted over time.
• No. of CPUs — the number of CPU units on the instance’s host.
• Total RAM — the total amount (in megabytes) of the host’s physical memory.
• V. Overhead — the percentage of CPU that is unavailable to this virtual machine because it is being utilized either by other virtual machines or by VMware itself..
* NOTE - The virtualization overhead metric holds value only for virtual hosts running on VMware ESX servers.
Clicking the virtualization overhead indicator displays the Virtualization Resource Utilization popup.
• Free RAM — the total amount (in megabytes) of physical memory available to the applications.