12-19-2011 06:43 AM
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!
12-19-2011 06:50 AM
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
12-19-2011 07:17 AM
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.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.