February 27, 2012 at 7:30 am
Hi,
In our environment we have configured partol that, if a process is blocked for more than 120 seconds, incidents will be generated. In the morning I found incidents for blocked process. Now I want the details of the blocked process like query text, time it was blocked etc.
Is there any DMVs where we can get the bolcked process details which already happend earlier
but nothing is there right now? Can I see it in default trace?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
February 27, 2012 at 9:25 am
I'm pretty certain there's no historical information like that pertaining to DMV's (however the experts around here may know of one). I can tell you that this information wouldn't be in the default trace file (only things like DROP's, CREATE's, ALTER, etc get logged by default to that trace file)
I'd recommend creating a trace that runs as a service when SQL starts that captures the information you need with a duration filter of 120 seconds (so it omits all other activity)...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2012 at 9:58 am
Thanks..
Ryan
//All our dreams can come true, if we have the courage to pursue them//
February 27, 2012 at 1:42 pm
You can find out from error log(sp_readerrorlog) if the TRACE FLAG 1204 or 1222 was on.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply