Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

How to detect dead lock from SQL Server side Expand / Collapse
Author
Message
Posted Monday, June 16, 2008 10:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 6:37 AM
Points: 5, Visits: 663
Cheers for the reply and i'll monitor that more closely aswell. Is sys.dm_exec_sessions available on SQL Server 2000?
Post #517698
Posted Monday, June 16, 2008 10:53 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:05 AM
Points: 42,829, Visits: 35,961
No. Use sysprocesses on SQL 2000.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #517715
Posted Wednesday, January 22, 2014 2:48 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 1:26 PM
Points: 302, Visits: 813
I'm viewing this thread to educate myself on how to identify and resolve deadlocking. The links provided are great but for older (2005 and 2008) versions of SQL Server.

(1) Can you recommend a more modern link (for SQL Server 2008 / 2012) that you've found to be the current 'Bible on deadlock troubleshooting'?
(2) Is this still true:"They can generally be resolved by changing application or stored procedure code to access tables in the same logic order, or by changing the actual database schema or indexing structures. The first step in Deadlock elimination is to identify what two statements are actually causing the deadlocks to occur."

Thanks in advance.
Post #1533845
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse