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]

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  December 11, 2008 at 12:19 am

  #910852

  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

  December 11, 2008 at 12:34 am

  #910864

  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

  December 12, 2008 at 5:41 am

  #911582

  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'