cancel
Showing results for 
Search instead for 
Did you mean: 

Blocking Transactions

Ricardo_Cuevas
Champ in-the-making
Champ in-the-making

Greetings.  Was doing some maint on the a SQL 2005 db for one of our customers.  I noticed (and they have reported) a LOT of blocking transactions.

How can you minimize this?  Prevent it?  LOL!

2 REPLIES 2

Jonathan_Radwan
Champ in-the-making
Champ in-the-making

Hi Ricardo-

You should contact your first line of support to open a support issue so that assistance can be provided in tracking down additional information regarding the blocks the customer is reporting.  There is not much we can recommend at this point until further information is gathered regarding the nature of the blocking transactions.

Thank you,

Jonathan

Ricardo_Cuevas
Champ in-the-making
Champ in-the-making

Thanks for the reply.  I'm currently gathering data to do a deeper dive into the issue.  Getting the log by querying the sysprocesses table and also trying to find the head of the blocking chain.