This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a SQL Script to find CPU Pressure using SignalwaitTime wait type in SQL Server.
Sometimes, Running queries are waiting for resources and SQL Server records related wait type.
We can analyze wait stats and take decision accordingly.
In this script, I am showing one Signalwait stats for measuring the pressure of the CPU.
The Higher Signalwait stats are not good for the system performance.
1 2 3 4 5 6 7 8 9 |
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 SignalWaitsOfTotalTimeInPercentage FROM sys.dm_os_wait_stats GO |