Post reply

get_waitstats_2005 confused

  • June 16, 2011 at 2:46 am

    #389747

    I have ran this over a 10 minute period and I get a total weight of

    11675816 ms

    11675.816 seconds

    194 minutes

    Is my understand of a SQL ms wrong is a ms not 1000’th of a second?

  • June 16, 2011 at 3:45 am

    #1339526

    1000 milliseonds = 1 second.

    As for the total....

    If you and I both stand in a queue for 2 minutes, then our cumulative wait time is 4 minutes (2 minutes * 2 people). If 10 people stand in a queue for 2 minutes then their cumulative wait time is 20 minutes. Those wait stats are cumulative for all connections.

    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

  • June 16, 2011 at 6:42 am

    #1339620

    thanks I thought it must be cumulative, just seemed a lot, thanks for putting my mind at rest

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

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