December 8, 2014 at 11:54 pm
I need to find the information about the dead lock which occurred in the last week , is it possible to gather the info .
I don't have any 3rd party tools .
December 9, 2014 at 1:16 am
Unless you had something running when the deadlock occured (traceflags, extended events), no. There's a slim chance that it'll still be in the system health extended events session, but after 3 weeks that's a very slim chance.
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
December 9, 2014 at 1:52 am
Thanks for the response I know in system health the info is stored , can you provide the query to retrieve the information in system health
December 9, 2014 at 1:55 am
Is google down?
I don't have a saved query handy, so either you search for it, or I have to search for it and post.
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
December 9, 2014 at 2:50 am
I will search ....
December 9, 2014 at 5:43 am
You can simply open the system_health output file in the Extended Event explorer window, or just browse to the file from the Open File menu and double-click, SSMS will figure out what to do from there. Inside that, you can use search and sort to find the deadlocks, if they're there.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply