September 14, 2004 at 11:24 am
Hi, I have been monitoring one of our SQL servers because the tables lock up intermittently. I have found the table where the lock first occurs and the update statement that is locking the table. For some reason the update statement will not release the lock on the table. What do I need to do the resolve this problem. It is bringing our system to a crawl.
Thanks in advance.
Gary
September 14, 2004 at 2:29 pm
Locks on tables are not released until the transaction doing the locking commits. The proper way to handle this is to restructure the transaction to either not last so long, or to break up the update to effect a smaller subset of the data, thereby locking fewer rows within the table.
September 14, 2004 at 3:28 pm
If you post the sample update statement and table/database schema on T-SQL section of the forum, you might get good feed back about how to tune the query from SQL level if there exists any part to improve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply