Identify CPU Pressure In SQL Server

---

Through below Query we can find out CPU Pressure in SQL Server
If Signal wait shows 15-18 % then it’s ok beyound that Server CPU is in pressure

---

---

SELECT CAST(100.0 * SUM(signal_wait_time_ms) / SUM(wait_time_ms) 
AS NUMERIC(20,2)) AS [%signal (cpu) waits] ,
CAST(100.0 * SUM(wait_time_ms - signal_wait_time_ms)/ SUM(wait_time_ms) AS NUMERIC(20, 2)) 
AS [%resource waits]FROM sys.dm_os_wait_stats ;

Output:-

---