January 9, 2013 at 6:47 am
Hi All
Without using Trace we need last week dead lock list
for this any script please suggest us.
Thanks in advance.
January 9, 2013 at 6:49 am
Do you log when a deadlock occurs?
January 9, 2013 at 7:19 am
You might be able to pull some from the system health extended events session. Whether it goes back a full week though is doubtful. There's no permanent store of deadlocks that have occurred unless you have created one.
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
January 9, 2013 at 7:52 am
Yes Gail
Using Extended Events only we get the complete list of the last week dead lock
My team lead was asking the list of deadlocks still dead lock are available in the server
How can we get the complete list of dead locks any script for this please suggest me.
Tx
January 9, 2013 at 8:06 am
GilaMonster (1/9/2013)
There's no permanent store of deadlocks that have occurred unless you have created one.
You can't get the ' list of deadlocks available in the server' because there's no such thing. SQL does not store deadlock information for long periods. Prior to SQL 2008, it didn't store it at all. If you want to track deadlocks, you need either a custom trace or a custom extended events session or a traceflag and archiving of the error logs.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply