The Host CPU Usage (Percent) alert indicates an unusually high amount of CPU usage by the VMWare or Hyper-V host server hosting the virtual machine on which the monitored SQL Server instance resides. The percentage of host server processor usage is listed under the control. A high host server percentage could indicate a large number of active client sessions. This alert is enabled by default and is available only on instances hosted on virtual machines enabled for VM monitoring.

Reduce your host CPU usage

Consistently high host server processor usage could indicate the need to:

For example: SELECT * FROM Northwind.dbo Employees is a fully-qualified object reference whereas SELECT * FROM Employees is a poorly-qualified object. You can reuse the execution plans of fully-qualified objects "as is," whereas plans where you either cannot reuse the not fully-qualified objects or, if they are reused, then they are subject to a highly restrictive COMPILE lock while SQL Server determines if all of the objects referenced in the T-SQL code have the same owners as the execution plan currently in cache. Both of these situations consume a significant amount of CPU time.



SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
| | | | |