SQL Server Performance Engineering Team Blog

I would like to announce the blog from my team – SQL Server Performance Engineering. Feel free to visit our blog at http://blogs.msdn.com/sqlperf for your performance related questions and needs. Use the email link in the home page to share your feedback on performance and topics of interest. — Umachandar Jayachandran

1

New trace flag for deadlock output and profiler deadlock event enhancement

Did you know that SQL Server 2005 adds a new trace flag (-T1222) for deadlock trace output? This deadlock output has numerous improvements over older versions of SQL Server. For example, some of the enhancements of the new grace flag are:   1. XML like output for the deadlock 2. Execution stack at the time of…

1