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
 Express Edition and Compact Edition (2005)
 Deadlocks in SQL server

Author  Topic 

AparajitaDutta
Starting Member

1 Post

Posted - 2012-09-14 : 06:52:53
How to write query to get all data that are being collected as deadlocks in SQL server, i am not allowed to use SQLtrace.

Anyone help is highly appreciated.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-09-14 : 07:06:25
As far as I know, in SQL 2005 there isn't a way to do this without SQL Trace permissions. If you are fortunate enough to be on SQL 2008, see this article by Jonathan Kehayias that describes how to use extended events to get deadlock graphs: http://www.sqlservercentral.com/articles/deadlock/65658/
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-09-14 : 11:48:17
Default Trace (different to sql trace) won't give you all the data - but it will give you some good hints at deadlock occurences.
http://www.sqlserver-dba.com/2012/04/sql-server-default-trace-faq.html

One of the events available is Lock:Deadlock

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -