August 23, 2011 at 1:32 am
Hi Folks,
am facing a critical problem in my production servers, like same process is blocking by itself, and there are resulting records(SPIDs) more than one time if i run sp_who2.
for Ex: 70 is a spid it results more that 10 times if i run sp_who2 and it is blocking by 70(spid) itself.
this is causing performance problem.
what might be the problem and kindly help me please...
August 23, 2011 at 5:56 am
Parallel execution probably. Hard to know what to do without seeing the code though.
"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
August 23, 2011 at 8:56 am
I don't think there's anything necessarily wrong with self blocking.
August 24, 2011 at 6:24 am
My guess is that this is actually a symptom of something else, likely a poor IO subsystem. Have you done a waitstats and file IO stall analysis? Also, what is the code and query plan of the offending query?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply