Activity Monitor not starting, always being paused

  • mkuechler

    Mr or Mrs. 500

    Points: 548

    I am running SQL2008 Server Standard edition on Server 2008 x64. When I try to run the Activity Monitor in Management Studio I get the following error:

    The Activity Monitor is unable to execute queries against server [my instance 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 1328 on server [server name]

    (Microsoft.SQLServer.Management.ResourceMonitoring)

    When I used the context menu to resume, I get the same message. Does anyone have any idea's?

    THANKS in advance.

  • VastSQL

    SSC-Dedicated

    Points: 35702

    Just try close the SSMS and reconnect to server

  • mkuechler

    Mr or Mrs. 500

    Points: 548

    Done that several times. Same result.

    MK

  • Shawn Melton

    SSC-Insane

    Points: 24675

    http://connect.microsoft.com/SQLServer/feedback/details/414108/ssms-2008-activity-monitor-fails-to-monitor-sql-2005-cluster-instance

    Not that his has the fix but it does mention to ensure the user account running Activity Monitor has permission in the "Performance Monitor Users" Windows group.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • mkuechler

    Mr or Mrs. 500

    Points: 548

    I have logged into the box as a domain admin and into the SQL instance with the sa account. Still same issue.

    MK

  • VastSQL

    SSC-Dedicated

    Points: 35702

    Can you please let me know the default database of the user you used to connect?

    Is your CPU 100% saturated??

  • mkuechler

    Mr or Mrs. 500

    Points: 548

    The user sa defaults to the 'master' database. And no the CPU is not saturated at all. There is only one database actively running on this server.

  • Shawn Melton

    SSC-Insane

    Points: 24675

    mkuechler (3/26/2010)


    I have logged into the box as a domain admin and into the SQL instance with the sa account. Still same issue.

    MK

    If you have Windows Authentication allowed...can you try adding your Windows login account into SQL and then logon to SSMS with windows authentication to see if that works? I would believe the SA account should work, but I don't use that account in my environment.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • mkuechler

    Mr or Mrs. 500

    Points: 548

    Same deal.

    It doesn't matter which account I use it still comes up with that error.

    Anyone know what the "SQL Server Process ID 1328" is?

  • Shawn Melton

    SSC-Insane

    Points: 24675

    mkuechler (3/29/2010)


    Anyone know what the "SQL Server Process ID 1328" is?

    sp_who

    --OR

    sp_who2

    Executing one of these commands in query should give you pretty much what is shown in Activity Monitor

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • mkuechler

    Mr or Mrs. 500

    Points: 548

    Thanks! That is good to know.

    Is there one to show the db locks?

  • Shawn Melton

    SSC-Insane

    Points: 24675

    This is the MSDN (aka Books Online) that show the DMVs used in SQL Server 2005:

    http://msdn.microsoft.com/en-us/library/ms188754.aspx

    Then sys.dm_tran_locks will shows you the locks currently active (http://msdn.microsoft.com/en-us/library/ms190345.aspx)

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • jrflood

    Valued Member

    Points: 56

    Using SSMS 17.9.1, I right-clicked the tab and clicked resume several times, and eventually got the expected information.

  • Summer90

    SSC-Dedicated

    Points: 32820

    I have this same issue come up from time to time.  The only thing I see is that the CPUs may not be near 100% but there is a LOT of activity going on within SQL Server.

  • mig28mx

    SSC Eights!

    Points: 933

    Hi

    "If SQL is running on a Windows 2008 R2 server or cluster, go to the Performance Monitor application, expand the Data Collection Sets, then select the System Performance, if the arrow is green on the line below the menu just click on it. This will restart the counters, you may wish to do same for System Diagnosis collection set.

    Then just refresh or open new connection to the SQL instance you wish to open SSMS Activity Monitor for, this should have solved your problem."

    Original:https://serverfault.com/questions/141849/activity-monitor-is-unable-to-execute-queries-against-server

    Hope this helps.

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply