Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-25 : 09:16:41
|
| Regan writes "Hi all,I've written a few stored procedure's to help track down users who are locking resources , how long they have had them locked , the object name etc. However, I have been unable to find any resources that enable me to determine when SQL server has decided to escalate it's locks. I calculate the duration of a lock being held (per SPID), based on: getdate()-sysprocesses.last_batch The problem is, I am thus reporting that the SPID has had a table lock (for example) for the entire duraction of time since the last action of the SPID, whereas it is was likely a RID lock, escalated to page, then to extent and then to table. I would like to "track" the lock escalation events per SPID, so I can determine the duration of each of the lock types , per SPID.Any ideas ?TIA" |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
|
|
|
Determining when lock escalation occurs ... 