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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2004-07-29 : 00:12:54
|
| Hi,I just noticed that one of our SQL 2000 box does not have SQL counters enabled , I mean I cant' see the counters when I execute Windows perfmon utility . I checked few websites on this which explained that it could be due to some third party application which could disable it by adding a key in the registry as "Disable Performance Counters" valued "1" . But I checked which is not there either. Could this happen due to incorrect SQL server installation ?Is there any way I can turn on the counters or load it again . I think SQL server requires a restart .Thanks |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-29 : 08:18:54
|
| Search microsoft.com for missing performance counters and missing SQL Server performance counters. There are a couple articles dealing with this very issue in detail. Also, you do have the latest Windows and SQL Server service packs, correct?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Cannot see SQL performance counters.