Activity monitor is unable to execute queries against server
- by mika
SQL Server Activity Monitor fails with an error dialog:
TITLE: Microsoft SQL Server Management
Studio The Activity Monitor is
unable to execute queries against
server [SERVER]. 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.
ADDITIONAL INFORMATION: Unable to
find SQL Server process ID [PID] on
server [SERVER]
(Microsoft.SqlServer.Management.ResourceMonitoring)
I have this problem on SQL Server 2008 R2 x64 Developer Edition, but I think it is found in all 64bit systems using SQL Server 2008, under some yet unidentified conditions.
There is a bug report on this in Microsoft Connect.
It seems that the problem is not solved yet.