none
sql 2008: the activity monitor is unable to execute queries against server

    Question

  • Installed sql server 2008 entrprise edition on VM server windows 2008 (64bit). When launch Activity Monitor, get:

    The Acityvity Monitor is unable to execute queries against server <server name>.
    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 xxxx on server <server name>
       (Microsoft.SqlServer.Management.ResourceMonitoring)



    Tried to "use he context menu in the overview pane to resume the Activity Monitor" and got the same error again.

    Installed sql 2008 in my XP machine, I can use Activity Monitor (AM) for local instance but cannot launch it for the instance on the server (same error).

    Used windows authentication with sysadmin role for connection from my machine. On the server used domain\administrator that the account created the instance.

    Please help.
    Friday, April 03, 2009 6:48 PM

Answers

  • I found in another forum/blog the following

     

    cd c:\windows\system32

    lodctr 
    /
    R

    This resolved my occurrence of this same issue

    D-B-S
    Tuesday, September 21, 2010 10:10 PM
  • c:\windows\system32

    LODCTR /R

    Con esto se restaura el Monitor de Rendimiento del sqlserver 2008.

    Tuesday, February 21, 2012 9:58 PM
  • If your running SQL on a Windows 2008 R2 server or cluster, then open Windows Performance Monitor application, expand the Data Collection Sets, Click on the System Performance if the arrow on the line under the menu is green you can restart the counters by clicking on it. You may wish to do same for System Diagnosis collection set.

    Then open or refresh your SSMS connection to your SQL server instance. This should allow you to open the Activity Monitor successfully.

    I stumbled into this today. Wish the error message gave you this instruction instead of Use the context menu in the overview pane to resume the Activity Monitor.

    Friday, May 20, 2011 1:34 PM

All replies

  • I'm going to move this over to the "Tools" forum for you - it's not a Database Engine question.
    Aaron Alton | thehobt.blogspot.com
    Saturday, April 04, 2009 4:56 PM
  • Could you turn off User Access Control and try again?
    Monday, April 06, 2009 10:44 PM
  • Thanks Justin.

    Disabled UAC and reboot server. No help. Same error.
    Tuesday, April 07, 2009 8:50 PM
  • Is there any movement on this issue. I'm getting this error now too. It's rather frustrating because it is only on the 2005 SP3 clustered instance that this issue occurrs. I have two clustered instances that are not sp3 and I can get activity monitor working fine.
    Here's the architecture
    3 2005 instances in separate resource groups on a cluster.
    2 instances are sp2, 1 instance is sp3.
    2008 client tools on my xp laptop.
    I have SA rights in SQL and am local Administrator on the server.

    I can connect, see processes, resource waits, io and recent expensive queries, but when I try to see the Overview I get the error listed below.

    ---------------------------------------------------------
    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    The Activity Monitor is unable to execute queries against server servername\instancename.
    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:

    Category does not exist. (System)

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Tuesday, July 14, 2009 12:10 PM
  • I also have this problem with two servers, Windows 2008 64 bit, virtulised (ESX) running SQL 2008 standard

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    The Activity Monitor is unable to execute queries against server XXLONSQL02.
    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 1616 on server XXLONSQL02 (Microsoft.SqlServer.Management.ResourceMonitoring)

    ------------------------------
    BUTTONS:

    OK



    ------------------------------

    Wednesday, November 11, 2009 5:02 PM
  • I'm seeing the same behavior.

    Virtualized (Hyper-V) Server 2008 x64; SQL Server 2005 SP3 with CU3.
    SQL Version info - 9.00.4229.00 SP3 Standard Edition (64-bit)

    I'm using Windows 7 Ultimate with SSMS 2008 SP1.

    Whenever I try to connect through Activity Monitor (NTLM), I see the same 'unable to find SQL Server process ID xxxx...' error. I'm SA on SQL Server, and I've got the 'VIEW SERVER STATE' permission. Any ideas?
    Thursday, December 10, 2009 3:32 PM
  • There is a Connect bug report on this issue:

    https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351176

    You can add your own bug description to this connect. The more detail the better.

    Thanks.

    Kalman Toth SQL SERVER 2012 & BI TRAINING
    New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012


    Sunday, December 20, 2009 1:45 PM
  • The same problem:

    ===================================

     

    The Activity Monitor is unable to execute queries against server KSERVER.

    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 2332 on server KSERVER (Microsoft.SqlServer.Management.ResourceMonitoring)

     

    ------------------------------

    Program Location:

     

       at Microsoft.SqlServer.Management.ResourceMonitoring.SqlPerfmonProcessReader.GetSqlProcessCpuUtilization()

       at Microsoft.SqlServer.Management.ResourceMonitoring.BackgroundSqlCpuTask.Execute()

       at Microsoft.SqlServer.Management.ResourceMonitoring.BackgroundWorkRequest.Execute()

       at Microsoft.SqlServer.Management.ResourceMonitoring.BackgroundWorkRequestQueue.BackgroundWorker_DoWork(Object sender, DoWorkEventArgs e)

       at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)

       at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

     

     

    Microsoft SQL Server Management Studio 10.0.2531.0

    Microsoft Analysis Services Client Tools 10.0.1600.22

    Microsoft Data Access Components (MDAC) 6.0.6002.18005

    Microsoft MSXML 3.0 6.0 

    Microsoft Internet Explorer 8.0.6001.18865

    Microsoft .NET Framework 2.0.50727.4200

    Operating System 6.0.6002

     

    The AM has stopped working after:

    1. moving WSUS DB from local to sql server

    2. Installing Rolling Exchange 2 and 5 update

    3. Cleaning WSUS updates

    4. Installing ESET Remote Administrator Console and Server.

     

    Friday, January 08, 2010 4:21 PM
  • I found in another forum/blog the following

     

    cd c:\windows\system32

    lodctr 
    /
    R

    This resolved my occurrence of this same issue

    D-B-S
    Tuesday, September 21, 2010 10:10 PM
  • If your running SQL on a Windows 2008 R2 server or cluster, then open Windows Performance Monitor application, expand the Data Collection Sets, Click on the System Performance if the arrow on the line under the menu is green you can restart the counters by clicking on it. You may wish to do same for System Diagnosis collection set.

    Then open or refresh your SSMS connection to your SQL server instance. This should allow you to open the Activity Monitor successfully.

    I stumbled into this today. Wish the error message gave you this instruction instead of Use the context menu in the overview pane to resume the Activity Monitor.

    Friday, May 20, 2011 1:34 PM
  • c:\windows\system32

    LODCTR /R

    Con esto se restaura el Monitor de Rendimiento del sqlserver 2008.

    Tuesday, February 21, 2012 9:58 PM
  • found this on another site.  Seems to resolve the issue.

    How to fix it:
    Use regedit to find HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\PerfProc\Performance
    there is a key in there called Disable Performance Counters , delete it or set it to 0 You may need a restart after you change the key.


    • Edited by Paul Muharsky Friday, September 28, 2012 5:29 PM invalid footer
    • Proposed as answer by Cowski Friday, March 15, 2013 2:04 PM
    • Unproposed as answer by Cowski Friday, March 15, 2013 2:06 PM
    • Proposed as answer by DiscoveryX Tuesday, November 05, 2013 11:53 AM
    Friday, September 28, 2012 5:28 PM
  • jajajajaja Not much complicated... Just run SQL Server Management Studio as administrator.


    Easy :)

    (https://connect.microsoft.com/SQLServer/feedback/details/351176/activity-monitor-error-leads-to-infinite-loop at the second alternative solution)


    MC. Omar Chávez

    • Proposed as answer by brgn Tuesday, May 07, 2013 7:29 PM
    • Unproposed as answer by brgn Tuesday, May 07, 2013 7:29 PM
    Tuesday, October 23, 2012 9:22 PM
  • Could not find this key in my SQL Server 2008 R2 registry.
    Friday, March 15, 2013 2:07 PM
  • Turn on virtual memory, at least 1024mb
    Thursday, October 17, 2013 11:21 PM
  • Turn on virtual memory, at least 1024mb
    Thursday, October 17, 2013 11:21 PM

  • Paul, thank you. It has helped me to solve the problem.
    • Edited by DiscoveryX Tuesday, November 05, 2013 11:56 AM
    Tuesday, November 05, 2013 11:55 AM