Enables DBCC Traceon (1222) to Capture Deadlocks.
Run below trace to capture deadlock process. Link here
I also learnt I need to do a good learning on locking concepts, I found below links useful
Range locks
Geek City: What do you intend with that lock?
SQL Server DBA Concurrency and Locking Interview Questions
Presentation Links: SQL Server Performance Tuning (Quest)
Happy Learning!!!
September 14, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment