InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:12:39 GMT20http://www.sqlservercentral.com/Forums/Topic1404750-392-1.aspx[quote][b]GilaMonster (1/9/2013)[/b][hr] There's no permanent store of deadlocks that have occurred unless you have created one.[/quote]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.Wed, 09 Jan 2013 08:06:31 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1404750-392-1.aspxYes GailUsing 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.TxWed, 09 Jan 2013 07:52:05 GMTshiv-356842http://www.sqlservercentral.com/Forums/Topic1404750-392-1.aspxYou 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.Wed, 09 Jan 2013 07:19:30 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1404750-392-1.aspxDo you log when a deadlock occurs?Wed, 09 Jan 2013 06:49:11 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1404750-392-1.aspxHi AllWithout using Trace we need last week dead lock list for this any script please suggest us.Thanks in advance.Wed, 09 Jan 2013 06:47:30 GMTshiv-356842