March 20, 2013 at 11:06 am
Hi Experts,
How to reduce resource waits on sql server without upgrading CPU??
Thanks,
Nihar
March 20, 2013 at 11:17 am
It depends! Which exact waits types you are having problem with?
Are you sure that they are CPU dependent ones?
March 20, 2013 at 12:07 pm
Select signal_wait_time_ms=sum(signal_wait_time_ms)
,'%signal (cpu) waits' = cast(100.0 * sum(signal_wait_time_ms) / sum (wait_time_ms) as numeric(20,2))
,resource_wait_time_ms=sum(wait_time_ms - signal_wait_time_ms)
,'%resource waits'= cast(100.0 * sum(wait_time_ms - signal_wait_time_ms) / sum (wait_time_ms) as numeric(20,2))
From sys.dm_os_wait_stats
-----------
output:
signal_wait_time_ms----2003819
%signal (cpu) waits----- 0.05
resource_wait_time_ms---- 3897150915
%resource waits ----- 99.95
March 20, 2013 at 12:32 pm
March 20, 2013 at 12:42 pm
And chapter 3 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy