Event ID: 8314
Log: Application
Type: Error
Source: MSSQL$SQLEXPRESS
Category: Server
Username: N/A
Computer:
Description: SQL Server performance object 'MSSQL$SQLEXPRESS:Buffer Manager' not found in registry. SQL Server performance counters are disabled.
This inidcates that some of the required registry keys for Performance monitoring objects are not properly loaded. These objects need to be reloaded.
Resolution:
Using an elevated administrator command prompt perform the following steps:
Change the path to the BINN directory of the SQL Server instance you desire to correct.
(Ex: C:\Program Files\Microsoft SQL Server\MSSQL$SQLEXPRESS\MSSQL\Binn)
Execute unlodctr <<REGISTERED SERVER NAME>>
For example: unlodctr MSSQL$SQL2008 or unlodctr SQLAgent$SQL2008 or
unlodctr MSSQL$SQLEXPRESS
Execute lodctr /T:<<perf-sql* matching the counters you desire to load>>
For example:
lodctr /t:perf-SQLEXPRESSsqlctr.ini
lodctr /t:sqlctr.ini
NOTE: The /T is important to load the SQL Server performance counter provider as a trusted provider.
Cycle the remote registry service
net stop "Remote Registry"
net start "Remote Registry"
Force a WMI synchronization using:
winmgmt /resyncperfctr "<<PID>>"
where PID is the process id of the WinPriv.exe (you can get this from Task Manager)