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 |
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
 Posted - 2003-11-11 : 09:54:06
|
| I installed W2000 on a couple of my servers, including SP3. When I installed SQL Server 2000 Enterprise Edition, the performance counters were showing up fine. After installing SP3a, they are missing. Other than that, there are no problems. It is the same problem on both machines. Last night, I reinstalled SQL Server on one of the machines and duplicated the exact same error in the same order. I need to get the counters working obviously and am thinking of just dropping down to SP3, which I have installed on another server with no problems. Has anyone encountered this here? If so, does anyone have a solution? I have searched quite a few forums for this without much success.Thank a bunch.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-11-11 : 11:21:37
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;227662&Product=sql-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2003-11-11 : 15:25:03
|
| :) I looked at this article already. There's a little part at the bottom that really bothers me though:The information in this article applies to:Microsoft SQL Server 6.5I'm not touching the registry on my production SQL Server or messing with dlls if I'm not sure it applies to SQL 2000. If anyone has used this article with SQL2K, could you let me know? Also, if anyone has any ideas, that would be great. Looks like I might open up a case with MS, or just roll back to SP3.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2003-11-12 : 17:13:04
|
| I didn't read the MS article but does this applyunlodctr.exe MSSQLServerlodctr.exe <SQL Server path>\binn\sqlctr.inigot it from sql-performance article on monitoring performance |
|
|
|
|
|
|
|
|
Performance counters missing