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
asp.net,c#.net, MVC, WPF, WCF, JavaScript, JQuery, SQL Server, Interview Q&A
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