My SQL Server Perfmom counters are missing….

just had MS Premier Support restore some missing SQL Counters for us. Actually, the counters weren’t missing but rather had missing data..

Here is the fix:

–        We followed the steps below to reload the SQL Server counters.

1. Open a CMD window and change the path to the Binn directory of the SQL Server instance.

2. Run command unlodctr MSSQLSERVER.

3. Run command lodctr perf-MSSQLSERVERsqlctr.ini.

4. Run command lodctr /T:perf-MSSQLSERVERsqlctr.ini.

5. Run command net stop “Remote Registry”.

6. Run command net start “Remote Registry”.

–        We checked the registry hive “KHEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib09” and found the database mirroring counters there.

–        After rebooting the server, we found the missing instance values back under performance counter objects of “SQLServer:Database Mirroring”.

Advertisements
This entry was posted in SQL Server. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s