Post reply

Query/Performance Tuning using wait types

  • March 1, 2010 at 4:17 am

    #139136

    I have a question on using wait types to analyse performance issues, my query stems from the fact that within an OLTP

    system that runs so many queries/transactions. I need to identify the specific wait type for a particular stored proc/transaction.

    Is there a way to do this, I'm concerned that the scope of the wait type covers the entire DB server.

  • March 1, 2010 at 7:06 am

    #1126443

    there is the waittype column in sysprocesses or the dmv sys.dm_os_wait_stats

    ---------------------------------------------------------------------

  • March 1, 2010 at 7:41 am

    #1126456

    Try this one

    http://support.microsoft.com/kb/822101

  • March 1, 2010 at 8:15 am

    #1126473

    Have a look at Andrew Kelly's stuff. His blog is here: http://sqlblog.com/blogs/andrew_kelly/, I think he's written stuff for SQL Mag and other places.

    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

  • March 2, 2010 at 7:55 am

    #1127114

    Search web for this word doc: SQL Server 2005 Waits and Queues SQL Server Best Practices Article. It is the Bible for this topic. Also search for track_waitstats_2005

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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