Deadlock list

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Deadlock list

Deadlock list

Rate Topic

Display Mode

Topic Options

Author

Message

shiv-356842

Posted Wednesday, January 09, 2013 6:47 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:08 AM
Points: 239, Visits: 1,027

Hi All

Without using Trace we need last week dead lock list
for this any script please suggest us.

Thanks in advance.

Post #1404750

anthony.green

Posted Wednesday, January 09, 2013 6:49 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Do you log when a deadlock occurs?

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1404752

GilaMonster

Posted Wednesday, January 09, 2013 7:19 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 37,744, Visits: 30,025

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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1404771

shiv-356842

Posted Wednesday, January 09, 2013 7:52 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:08 AM
Points: 239, Visits: 1,027

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

Post #1404798

GilaMonster

Posted Wednesday, January 09, 2013 8:06 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 37,744, Visits: 30,025

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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1404812

« Prev Topic | Next Topic »

Permissions