SQL server 2005 wait types

Question

Post reply

SQL server 2005 wait types

Ahmad Osama

SSCertifiable

Points: 7676
More actions
December 11, 2008 at 12:12 am

#126406

Please provide me with detailed information on sql server 2005 wait types
Regards,
[font="Verdana"]Sqlfrenzy[/font]

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

I believe this doc has most listed

http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ahmad Osama SSCertifiable Points: 7676 More actions · Answer 2

thanks Gila... SOS_SCHEDULER_YIELD is taking too much CPU...how to solve this issue

Regards,
[font="Verdana"]Sqlfrenzy[/font]

CoetzeeW Default port Points: 1411 More actions · Answer 3

Hi

Please send your results of select * from sys.dm_os_wait_stats

or

select * from sys.dm_os_wait_stats

where wait_type = 'SOS_SCHEDULER_YIELD'