Traceflag 1222 for deadlocks
Use traceflag 1222 for deadlocks when monitoring SQL 2005+, and keep 1204 just for SQL 2000 instances. 1222 gives so much more information and doesn't cut off the SQL text.
Show info for Trace Flag 1204 and Trace Flag 1222 and also the deadlock graph from profiler.
We are pleased to annouce that this feature is now implemented as part of v4.0 release. Please check release notes for more details.
Brett Estes commented
Thank you, Mark. I use this blog as a reference point every time I evaluate deadlocks:
His highlighted information is the information I always focus on.
Well, SQL server 2008 and 2012 provides even better option for tracing deadlocks - Extended event "xml_deadlock_report". Output should be quite same but with less system overload that traceflag.
H Reyes commented
This will help a lot. The current one is truncating the SQL statements and the deadlock graph doesn't show up.
Unfortunately not at the moment Aaron. But we are reviewing it. I will update the forum as soon as we have made any progress on this.
Aaron Foote commented
This would be very good to have.
Any ETA on when we can expect this feature?
Don Ferguson commented
This is one that would really help. Can it be implemented in the next SQL Monitor 3 release?
We have this in our backlog so we're hopeful we can soon add this improvement to forthcoming releases...
Thanks for your votes