????????

???????DBA?????????????????????????????????????????????????????á??????????????????????????????

????????????????????????????????????????????????????????????????????????????????????????????????????????

????????????SQLServer Profiler????????????

?????????????

?????????????????????????????????????????????????????????????????

???????裺

????1????SQLServer Profiler

????2????????????????????????

????3??????????????棺

4?????????????У????Locks???????????????????

????1??Deadlock graph

????2??Lock:Deadlock

????3??Lock:Deadlock Chain

????5??????TSQL???????????????????

????1??SQL:StmtCompleted

????2??SQL:StmtStarting