Deadlock

Last Post 24 Jul 2013 07:20 AM by sql-tips. 10 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sql-tips
New Member
New Member

--
17 May 2013 07:31 AM
What are the steps to trace back when deadlock happened. I don't have trace setup and would like to know what caused the deadlock in my replication environment.
gunneyk
New Member
New Member

--
17 May 2013 10:45 AM
rm
New Member
New Member

--
18 May 2013 01:18 PM
Unable to get deadlock details without trace.
wayne
New Member
New Member

--
19 May 2013 07:32 PM
If it’s a once off your out of luck, if your experiencing it more regularly,
I suggest install these reports to help identify the culprits,
http://www.microsoft.com/en-au/down...x?id=29063
then look at your historical information in the right hand corner.
wayne
New Member
New Member

--
19 May 2013 07:39 PM
russellb
New Member
New Member

--
19 May 2013 08:18 PM
What do you mean by in your "replication environment?"

Where are you seeing deadlocks? How frequently are they occurring?

Are you writing to your subscribers?
sql-tips
New Member
New Member

--
16 Jul 2013 02:13 PM
I setup a trace with dead lock graph and chain and also setup startup parameter 1222 and restarted server. Users reports deadlocks and sends us screenshot. But, deadlocks are not capturing in either SQL server error logs or profiler.
rm
New Member
New Member

--
17 Jul 2013 05:18 AM
Did you start trace with -1 option? Which tells trace all sessions.
sql-tips
New Member
New Member

--
17 Jul 2013 06:22 AM
I setup -T
rm
New Member
New Member

--
18 Jul 2013 05:05 AM
And restarted sql?
sql-tips
New Member
New Member

--
24 Jul 2013 07:20 AM
Yes.
You are not authorized to post a reply.

Acceptable Use Policy