Showing posts with label reboot. Show all posts
Showing posts with label reboot. Show all posts
Friday, March 23, 2012
Performance Counters not available after restart Take offline-Online
After stopping and starting the MSSQLSERVER service the Performance Counters are not available. After a reboot of the server they are there again. What is the proper way to shutdown the MSSQLSERVER process, starting it again and regaining access to the performance counters? The Unlodctr and lodctr sqlstr.ini trick seems not to work. A complete reboot of the server is needed.I've found that stopping and starting the MSSQL Service using the services mmc renders the performance log for SQLServer in accesible. However, stop and starting a SQLserver from the Enterprise Manger does not have that effect.
Performance Counters not available after restart Take offline-Online
After stopping and starting the MSSQLSERVER service the Performance Counters are not available. After a reboot of the server they are there again. What is the proper way to shutdown the MSSQLSERVER process, starting it again and regaining access to the performance counters? The Unlodctr and lodctr sqlstr.ini trick seems not to work. A complete reboot of the server is needed.I've found that stopping and starting the MSSQL Service using the services mmc renders the performance log for SQLServer in accesible. However, stop and starting a SQLserver from the Enterprise Manger does not have that effect.
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?
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?
Subscribe to:
Posts (Atom)