• select sum(signal_wait_time_ms) as signal_waits_time_ms

    ,CAST(100* (sum(signal_wait_time_ms)/sum(wait_time_ms)) as numeric(20,2)) as [%signal_cpu_waits]

    ,sum(wait_time_ms-signal_wait_time_ms) as [resource_wait_time_ms]

    ,cast(100*(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