Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2005 - Get Deadlock information Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 9:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 9:34 AM
Points: 389, Visits: 959
IN sql 2005, I use DMV to get the number of deadlocks per sec. How can i get those deadlock's details? I havnt enabled the Traces or run profiler. These deadlocks already happend and i suspect if we could get the necessray details
Post #1434996
Posted Monday, March 25, 2013 10:36 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:17 PM
Points: 42,450, Visits: 35,505
There's no way to get historical deadlocks in SQL 2005 unless you already had some traceflag or trace on at the time.

To catch future deadlocks, turn traceflag 1222 on, the deadlock graph will then be written to the error log.



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 #1435033
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse