摘要： 参考文章：http://blogs.msdn.com/b/sqlserverfaq/archive/2013/04/27/an-in-depth-look-at-sql-server-memory-part-2.aspx简单的说：1.死锁发生前，打开开关：DBCC Traceon (1204,-1)DBCC Traceon (1222,-1)2.等待死锁发生3.查询死锁信息：Use MasterSELECT xed.value('@timestamp', 'datetime') as Creation_Date, xed.query('.') A 阅读全文