September 23, 2004 at 12:03 am
Howzit Guys .
I was wondering if there is a way to check deadlock information after the process that was blocking was killed , meaning does SQL store the info some where in a system table although the block doesn't exist anymore ? ...like a history type thing .
Thank you
September 24, 2004 at 3:27 am
Hi Grasshopper,
I'd use a combination of profiler, sp_lock and trace flags 1204, 1205. The last two will write you some history to the sql log. Remember to turn them off again after you find the problem as they can hurt performance.
BOL has lots of stuff about this under 'deadlocks' and 'trace flag 1204'. Hope this is what you're after.
September 24, 2004 at 10:17 am
There is no way to determine this after the fact. If you are getting deadlocks, use the hints above to setup a trace and look for them.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 26, 2004 at 11:15 pm
Thanks , I know how to use the options given , just thought there was a way to view deadlocks I didn't catch , because some nana killed the process before I got to work ....one of these cowboy DBA's ...
Thanks
Wynand
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply