Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

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


Group: General Forum Members
Last Login: Monday, October 10, 2016 5:25 AM
Points: 451, Visits: 1,079
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



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
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, MVP, M.Sc (Comp Sci)
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