Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Blocking Problem Expand / Collapse
Author
Message
Posted Monday, August 24, 2009 4:56 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:20 AM
Points: 432, Visits: 1,073
how to understand Blocking Problem in SQL Server 2005 and how to find solutions?
Post #776367
Posted Monday, August 24, 2009 11:34 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:49 AM
Points: 1,567, Visits: 2,626

Have a luk at this.

http://support.microsoft.com/kb/271509

Post #776450
Posted Tuesday, August 25, 2009 5:39 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 8:17 AM
Points: 667, Visits: 1,125
Hi,

You can find useful info at following links:

http://www.mssqltips.com/tip.asp?tip=1359

http://blogs.technet.com/rob/archive/2008/05/26/detecting-sql-server-2005-blocking.aspx

Ankur
Post #776569
Posted Tuesday, August 25, 2009 6:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:21 AM
Points: 2,223, Visits: 3,652
charipg (8/24/2009)
how to understand Blocking Problem in SQL Server 2005 and how to find solutions?


Go through the articles that others have suggested.
Blocking can happen due to multiple reasons.
For example, if you've run a update statement on a table which is taking long time and other user is trying to perform a DML query, this scenario will cause blocking.
Blocking may also happen due to I/O.
There are some DMVs in SQL Server 2005 which will tell you whether there are blocking present or not
sys.dm_os_waiting_tasks is one of them...





Pradeep Singh
Post #776578
Posted Tuesday, August 25, 2009 7:50 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:20 AM
Points: 432, Visits: 1,073
thanks..........
Post #776694
Posted Tuesday, August 25, 2009 12:23 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 12:00 PM
Points: 293, Visits: 820
http://support.microsoft.com/kb/224453
Post #776962
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse