Error: sql activity monitor unable to find sql server process id…

Hahh, my favourite infrastructure team built a development box and handed over to me. The first shocking error message I got:

===================================
The Activity Monitor is unable to execute queries against server %s
Activity Monitor for this instance will be placed into a paused state.
Use the context menu in the overview pane to resume the Activity Monitor.
===================================
Unable to find SQL Server process ID %i on server %s (Microsoft.SqlServer.Management.ResourceMonitoring)
-----------------------------

Lovely, isn't it? ;) The solution in our case was pretty simple (I remembered this error message since SQL 2005): SQL Server performance counters were corrupted and needed to rebuild them. You can use the following command to rebuild all performance counters on your server:

cd %systemdrive%\windows\system32
lodctr /R

Add comment