Performance counter missing

Sometimes the SQL Performance counters dissappear.
I have this problem when I change "Reserve physical memory" from Enterprise
Managers (I'm using dynamically memory allocation), its ask me about restart
the service, if I answer Yes the service is restarted but the sql counters
disappear. When I restart (shutdown) the server, the counter appear again...
The same occurs if I use sp_configure 'set working set size', after I
restart the service, the counters are missing; when I restart the server,
it's OK...
It isn't a big problema cause I can restart the server for a while, but I
think it's not a normal condition.
Ésio NunesIt's a bug that usually happens if you restart SQL Server and have something
running that is polling the counters at the time you shut down the service.
The trick is to ensure nothing is accessing any of the counters (perfmon,
custom traces etc) before you restart.
These may help:
SQL Perf Counters Missing After MDAC Install on Cluster [Q246328]
"Event ID (1001) in Source (SQLCTR70) Could Not Be Found" [Q196657]
Missing Objects and Counters in Performance Monitor [Q127207]
SQL Performance Monitor Counters Missing [Q227662]
--
Andrew J. Kelly SQL MVP
"Esio Nunes" <esio_nunes@.hotmail.com> wrote in message
news:%23EgzFlC5EHA.828@.TK2MSFTNGP14.phx.gbl...
> Sometimes the SQL Performance counters dissappear.
> I have this problem when I change "Reserve physical memory" from
> Enterprise
> Managers (I'm using dynamically memory allocation), its ask me about
> restart
> the service, if I answer Yes the service is restarted but the sql counters
> disappear. When I restart (shutdown) the server, the counter appear
> again...
> The same occurs if I use sp_configure 'set working set size', after I
> restart the service, the counters are missing; when I restart the server,
> it's OK...
> It isn't a big problema cause I can restart the server for a while, but I
> think it's not a normal condition.
> Ésio Nunes
>
>