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.
    vendredi 3 avril 2009 18:48

Réponses

  • 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
    mardi 21 septembre 2010 22:10
  • c:\windows\system32

    LODCTR /R

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

    mardi 21 février 2012 21:58
  • 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.

    vendredi 20 mai 2011 13:34

Toutes les réponses

  • 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
    samedi 4 avril 2009 16:56
    Modérateur
  • Could you turn off User Access Control and try again?
    lundi 6 avril 2009 22:44
  • Thanks Justin.

    Disabled UAC and reboot server. No help. Same error.
    mardi 7 avril 2009 20:50
  • 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
    ------------------------------

    mardi 14 juillet 2009 12:10
  • 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



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

    mercredi 11 novembre 2009 17:02
  • 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?
    jeudi 10 décembre 2009 15:32
  • 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


    dimanche 20 décembre 2009 13:45
    Auteur de réponse
  • 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.

     

    vendredi 8 janvier 2010 16:21
  • 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
    mardi 21 septembre 2010 22:10
  • 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.

    vendredi 20 mai 2011 13:34
  • c:\windows\system32

    LODCTR /R

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

    mardi 21 février 2012 21:58
  • 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.


    • Modifié Paul Muharsky vendredi 28 septembre 2012 17:29 invalid footer
    • Proposé comme réponse Cowski vendredi 15 mars 2013 14:04
    • Non proposé comme réponse Cowski vendredi 15 mars 2013 14:06
    • Proposé comme réponse DiscoveryX mardi 5 novembre 2013 11:53
    vendredi 28 septembre 2012 17:28
  • 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

    • Proposé comme réponse brgn mardi 7 mai 2013 19:29
    • Non proposé comme réponse brgn mardi 7 mai 2013 19:29
    mardi 23 octobre 2012 21:22
  • Could not find this key in my SQL Server 2008 R2 registry.
    vendredi 15 mars 2013 14:07
  • Turn on virtual memory, at least 1024mb
    jeudi 17 octobre 2013 23:21
  • Turn on virtual memory, at least 1024mb
    jeudi 17 octobre 2013 23:21

  • Paul, thank you. It has helped me to solve the problem.
    mardi 5 novembre 2013 11:55