????14????????????????????????????

????15???л???SQLServer Profiler??????????????????

????16???????Deadlock graph???????????????????

????17?????????????????????????????????????????xdl?????

????????????XML?????

??????????

??????????У???????????Profiler?????棬?????????????????м???

????1??Deadlock graph

????2??Lock:Deadlock

????3??Lock:Deadlock Chain

????4??SQL:StmtCompleted

????5??SQL:StmtStarting

????????????????????????????????Χ??

?????????ú???????и????????ssms?????н????SQLServer???????????????????????????????????????????????1205?????

??????SQLServer Profiler?У?????????????????????????????п???????????????????????й????????????????????????????????????????????????????

?????????????С????????????????Щ???????ο???

????1?????????????????С?????????Χ??

????2????y????????????

????3?????????????????NOLOCK????????

????4???淶???????????

????5??????????????????????????????????????裬????????????????

????6???????????????????????????????