The SQL Server CPU Usage (Percent) metric calculates the percentage of CPU time used by the SQL Server instance. This value is calculated by the percentage of time in a query spent by the I/O, idle, and CPU times on the computer that hosts the SQL Server instance.
To track this metric, use the CPU Usage chart in the CPU dashboard of the Server Overview tab.
If this value regularly exceeds 75%, consider taking the following actions:
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 identifies and resolves SQL Server performance problems before they happen. Learn more > >
|