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