27. January 2012
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: