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
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


Leave a Reply

Your email address will not be published. Required fields are marked *