The OS Disk Time Per Disk (Percent) alert provides the percentage of elapsed time that an individual disk is busy servicing read and write requests on the SQL Server computer. This alert triggers separately for each disk on a server.
If this value regularly exceeds 75%, you should take action such as:
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.Create an alert response bundle with the OS Disk Time Per Disk (Percent) alert and related alerts. For additional information, see Create alert response bundles. |
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
|