Blocking Problem

Question

Post reply

Blocking Problem

charipg

SSCrazy Eights

Points: 9888
More actions
August 24, 2009 at 4:56 pm

#133132

how to understand Blocking Problem in SQL Server 2005 and how to find solutions?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 1

Have a luk at this.

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

ankur_libra Hall of Fame Points: 3999 More actions · Answer 2

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

ps. One Orange Chip Points: 29422 More actions · Answer 3

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