Performance Counter Disappear

During normal processing SQLServer Performance Counters Disappear. A reboot
normally restores the Performance Counters but this is not feasible. How do I
restore the Performance counters without having to reboot the server?What exactly do you mean by "counters disappear"? You can't see the counters in Perfmon or the counters are visible but their values are 0 or not being updated? Do you see any rows when you select from sysperfinfo? Do you see any errors in SQL Server error log (failed to initialize shared memory, performance counters are disabled)? What is the version and service pack of SQL Server? 32-bit or 64-bit? Is this a cluster? Have you changed the SQL Server service account? What is the Windows version? Do you see "Disable Performance Counters = 1" value under HKLM\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance (instead of MSSQLServer, you should use the name of the SQL Server instance service for named instances).
Thanks,
-Ivan
--Original Message--
From: theking2
Posted At: Thursday, April 13, 2006 1:45 AM
Posted To: microsoft.public.sqlserver.server
Conversation: Performance Counter Disappear
Subject: Performance Counter Disappear
During normal processing SQLServer Performance Counters Disappear. A reboot normally restores the Performance Counters but this is not feasible. How do I restore the Performance counters without having to reboot the server?|||This bug has been fixed and re-fixed and re-fixed for the past 10 years!
DESPITE what MS has told us, this bug keeps coming back and keeps coming
back again.
And guess what, it's not fixed in SQL 9 either! Arrrggg....
"theking2" <theking2@.discussions.microsoft.com> wrote in message
news:3A184AA6-ED51-48AC-A908-7F6605CD31F1@.microsoft.com...
> During normal processing SQLServer Performance Counters Disappear. A
> reboot
> normally restores the Performance Counters but this is not feasible. How
> do I
> restore the Performance counters without having to reboot the server?