Tag Archives: wait time

How to: Verifying CPU Pressure via Signal Wait Time

Use the following query to verify the CPU pressure via signal wait time through MS SQL Server Management Studio.

USE master
GO
SELECT SUM(signal_wait_time_ms) AS TotalSignalWaitTime ,
( SUM(CAST(signal_wait_time_ms AS NUMERIC(20, 2)))
/ SUM(CAST(wait_time_ms AS NUMERIC(20, 2))) * 100 )
AS PercentageSignalWaitsOfTotalTime
FROM sys.dm_os_wait_stats

References