Hello,

Recently I failed one of our production sql server clusters over and
back. When the sql server service started, I got this message in the
sql log- " Performance monitor shared memory setup failed: -1". None
of the sql performance counters are available. I have seen this
before on one of our stand alone servers and a simple reboot solved
the issue. Unfortunately at the time I didn't have the time for
another reboot or to try to troubleshoot the issue since this isn't a
critical issue, so the server is back online. What are my options for
correcting this issue? Reboot, stop and restart of the service,
other? We are running Windows 2000 advanced server(service pack 4),
sql (service pack 3) in a active/passive cluster. Any advice would be
greatly appreciated.

Thanks,
Greg

Look at:

How to troubleshoot missing SQL Server Performance Monitor counters for an
instance of SQL Server
http://support.microsoft.com/default...&Product=sql2k



--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Greg" <gjackson (AT) thq (DOT) com> wrote