August 27, 2009 at 10:41 am
My company's application software appears to be creating a series of escalating locks when a rollup report runs at intervals of every 10 minutes after the hour. This is causing other applications to timeout.
I'd like to track the locks that occur at that time.
What would be the best way to do this?
LC
August 27, 2009 at 12:19 pm
I would suggest using the dynamic management view sys.dm_tran_locks. That will show what is locking, the type of locks, the session holding the lock... You get the idea.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 27, 2009 at 1:20 pm
That should do it.
Thanks,
LC
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply