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 - 2003-02-28 : 07:42:30
|
| Henri writes "We have just upgraded our production databases from SQL65 running on NT4 to SQL2000 running on Windows2000 (running Server Pack 2 - our DBA is a bit suspect of SP3).We have a historic problem on the database in that some of the architecture and procedures tend to cause runaway blocking lock problems. In SQL65 we monitored the situation very easily using the SQL 'Total Blocking Locks' counter in System Monitor (Performance Monitor). It appears that this counter is not available in SQL2000. Am I correct to come to this conclusion, and if so, is there another way in which we can display 'Total Blocking Locks' on a system monitor graph?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-28 : 12:37:59
|
| Have a look at the SQL Server:Memory Manager counters. One of those might be what you want, it's just that they renamed it. I couldn't find one that was similar in SQL Server:Locks. |
 |
|
|
|
|
|
Blocking locks counter in System Monitor