November 8, 2006 at 8:36 pm
Any input will be greatly appreciated.
November 9, 2006 at 5:21 am
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
Colin:
Could you kindly describe it in more detail?
Many thanks in advance.
November 9, 2006 at 8:44 am
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy