Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Deadlock trace in SQL profiler

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2011-05-02 : 00:14:16
Hi All,

I have traced the deadlock in SQL profiler and saved in .xsd file as per details here.
http://www.sqlconsulting.com/news0907.htm

But the issue was happened on saturday and on sunday sql service has been restarted.

I want to analyze the which process makes the deadlock victim,please help me some sort of steps to identify this.



Thanks,
Gangadhara MS
SQL Developer and DBA
   

- Advertisement -