May 8, 2012 at 1:05 am
I found that 100 blocking had occured.
What are the steps required to resolve this issue.
May 8, 2012 at 1:10 am
mssql.dba (5/8/2012)
I found that 100 blocking had occured.What are the steps required to resolve this issue.
I have no idea what you are talking about. What do you mean by 100 blocking had occurred?
May 8, 2012 at 2:31 am
mssql.dba (5/8/2012)
I found that 100 blocking had occured.What are the steps required to resolve this issue.
How did you find that 100 blocking had occurred?
May 8, 2012 at 2:52 am
Blockings come and go. They are no problem as long as they are not held for long time. You can not remove them completely but your aim should be to keep them to minimum and for a shorter time. There are lot of things that can be done to avoid/minimize blocking. You may start by a google search...
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
May 8, 2012 at 4:10 am
Keep monitoring the system, thousands and thousands of blocking occurrences will flit by. All that matters is when blocking is excessive, meaning, too much time is spent waiting for resources to be freed up.
In general, if you identify a process as blocking other processes, you need to determine what that process is doing. Depending on what it's doing, why it's taking so long, you have choices and decisions to make regarding what to do. I can't even make suggestions at this point on possibilities because they could be just about anything.
"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
May 8, 2012 at 4:46 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 8, 2012 at 11:22 pm
Thank You All For The Valuable Suggestions
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply