SQL Server Performance Forum – Threads Archive

dead locks

Can I see deadlocks(I will happen very rare scenario) after it occures can I seem them in any sql logs

You have to enable Trace Flag 1204 and Trace Flag 1222 to write the info to sql error log to see them later time and make sure you increase the no. of logs otherwise sql server keeps only 6 logs… And also you can use "Profiler Deadlock Graph Event" to detect the deadlock… Check BOL topic "Detecting and Ending Deadlocks"
http://msdn2.microsoft.com/en-us/library/ms178104.aspx MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Theoritically they happen and resolved on its own as SQL optimizer handles such quickly, so if you have enabled the trace flag as per Mohammed’s sugestion then make sure the SQL log disk space has required free space. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

I know it resolve it self based on deadlock priority or the thread that has done the least amount of work as the deadlock victim. …but I don’t see any exact duration which resolves itsefl… Any idea what it is the exact time the dead lock resolve itself?
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>