April 8, 2014 at 1:16 pm
Hi,
I need some one advice. I need to analyze the deadlock. Below I am providing some details
In the Event class: Lock:Deadlock Chain
Login SId ID: Same to all
SPid: Same to all
Start time: Most of them are same. For some just 3 millisec difference
TextData: Parallel Query Worker Thread was Involved in a deadlock
Event Subclass: Resource type exchange
IntegerData: Same to all
Just, I have these information from the trace.
Please let me know how to start?
I check the execution plan. All the Indexes are there.
Thanks,
Ramana
April 8, 2014 at 3:24 pm
It sounds like you're getting a parallelism deadlock. Hard to say for certain without seeing the deadlock graph.
Just because you see indexes in the execution plan doesn't mean they're being well used. A scan of an index can be as painful for execution as the scan of a table.
Hard to say what to do for sure. If you're getting parallel execution on the query, do you need that? Is it moving large amounts of data? If not maybe increasing the cost threshold for parallelism to get a single-threaded plan would be a good solution. Again, hard to suggest more than that with no information.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 13, 2014 at 9:38 pm
Thanks Grant.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply