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 a
ny errors in SQL Server err
or log (failed to initialize shared memory, performance counters are disable
d)? 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 th
e Windows version? Do you s
ee "Disable Performance Counters = 1" value under HKLM\SYSTEM\CurrentControl
Set\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?|||Hi Paul,
All known issues in this area have been fixed by SQL Server 2000 SP4. I'm no
t aware of any (postponed) outstanding issues. I'll be very happy to help in
investigations of problems in this area.
There are certain scenario in which the counters are expected to fail by des
ign:
- Restarting SQL Server under different service account while Perfmon is run
ning (remotely or locally)
- Running SQL Server in a cluster environment with individual instances runn
ing under different service accounts
- Trying to access counters of 32-bit SQL Server installed on 64-bit Windows
(WOW mode) from a 64-bit application
- Trying to access counters of 32-bit SQL Server installed on 64-bit Windows
(WOW mode) from a remote application
Unfortunately, there are also cases where the counters fail due to the fragi
le nature of PerfLib v1. Registry getting corrupted by interrupted installat
ions or by any other means is an example. We recognize this fact and have a
much higher expectation fro
m PerfLib v2 which ships with Windows Vista.
Thanks,
-Ivan
--Original Message--
From: Paul Wehland
Posted At: Thursday, April 13, 2006 4:01 PM
Posted To: microsoft.public.sqlserver.server
Conversation: Performance Counter Disappear
Subject: Re: Performance Counter Disappear
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 bac
k 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-A90
8-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?