This metric measures the percentage of time spent waiting for CPU resources to service a thread. A high signal wait time for all wait types may indicate that CPUs are being overused, forcing tasks to wait for SQL Server processes. The values are calculated\/accumulated as of the last restart of the server, or if they are reset using:
DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR);<\/pre><\/p>","tsql":"-- Total waits are wait_time_ms (high signal waits indicates CPU pressure)\r\nSELECT CAST(100.0 * SUM(signal_wait_time_ms) \/ SUM(wait_time_ms)\r\n AS NUMERIC(20,2)) AS signal_cpu_waits\r\nFROM sys.dm_os_wait_stats ;\r\n","instances":true,"frequency":3600,"databases":{"mode":1},"rateofchange":false,"metricenabled":true,"alertname":"CPU pressure (wait time)","alertdescription":"This alert is raised when the percentage of time spent waiting for CPU resources to service a thread goes above a specified threshold. A high signal wait time for all wait types may indicate that CPUs are being overused, forcing tasks to wait for SQL Server processes. The values are calculated\/accumulated as of the last restart of the server, or if they are reset using:
DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR);<\/pre><\/p>","aboveorbelow":"above","collections":3,"alertenabled":true,"_thresholds_high":{"selected":true,"value":20},"_thresholds_medium":{"selected":true,"value":15},"_thresholds_low":{"selected":true,"value":10},"thresholds_comment":"Note: These thresholds are intended as guideline values. If they seem too high or too low for your environment, replace them with values more suited to your server performance.","targetentitytype":0}