SQl Server 2008 Function Error

Question

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Suresh B. SSC-Insane Points: 22986 More actions · Answer 1

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

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 2

It works thanks, but can you explain why?

[font="Tahoma"]
--SQLFRNDZ[/url]
[/font]

Suresh B. SSC-Insane Points: 22986 More actions · Answer 3

I added a SUM in the second line and corrected the wrongly placed brackets.

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 4

SSCrazy Eights

Points: 9095

December 6, 2010 at 3:24 pm

Thanks,

[font="Tahoma"]
--SQLFRNDZ[/url]
[/font]