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 - 2005-02-14 : 08:05:52
|
| Zeeshan Amin writes "I added an Alert to monitor Lock Requests/Sec in Sql server 2000.Type: Sql Server Performance condition AlertObject: SQLServer:LocksCounter: Lock Requests/SecInstance: TableIt started to mail me that DESCRIPTION: The SQL Server performance counter 'Lock Requests/sec' (instance 'Table') of object 'SQLServer:Locks' is now below the threshold of 5.00 (the current value is -2142905600.00).In response to this i kill the procedure caused these requests to occur. But after 2 days it shows me that the current value is - 1942905600.00 My question is can you tell me how sql server Lock Manager, manages locks. As i killed the application why did not sql server releases all the pending locks? is there any way to release all pending locks?Thank you.Zeeshan Amin." |
|
|
|
|
|
Sql Server Performance condition Alert