Post reply

How to record durations of all blocks?

  • November 8, 2006 at 8:36 pm

    #115048

    Any input will be greatly appreciated.

  • November 9, 2006 at 5:21 am

    #670802

    You really won't want to do this!! ( collect all )  Most methods to capture this type of info set a lower threshold, e.g. anything that blocks for over 2 seconds ( there will always be some blocking )

    I use a scan every 5 secs which picks up anything that's blocking at that time ( with the blocked time ) I write this to a table and analyse it after.

    There's a wealth of such routines on the ms web sites ( msdn/technet ) and I suspect elsewhere on this site as so many people have written routines.

    You can also use profiler.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • November 9, 2006 at 8:07 am

    #670853

    Colin:

    Could you kindly describe it in more detail?

    Many thanks in advance.

  • November 9, 2006 at 8:44 am

    #670866

    Hmm I see ms have been re-organising their web sites ( again ) try this link as a start

    http://support.microsoft.com/kb/271509/EN-US/

    I have an adapted ms proc I use which writes to a table.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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