MS SQL 2008 Activity Monitor does not work

Posted on 2011-05-06
Last Modified: 2012-05-11
When I tried to start Activity Monitor in SQL 2008 SSMS, I got the error below.

    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.

    Unable to find SQL Server process ID [PID] on server [SERVER] (Microsoft.SqlServer.Management.ResourceMonitoring)

Then I saw nothing show up in my activity monitor.
I googled and tried to the solution on a different site but none worked. please help.
The solution I tried included below.
1. To rebuild execute the following command

cd c:\windows\system32
lodctr /R

2. To restart SQL service.

Question by:atlasdev
    LVL 9

    Accepted Solution


    Have you tried these two options

    1. 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.

    2. If you enable the service Performance Counter DLL Host in the Services control panel, the Activity Monitor should now work.

    3. Restarting the SSMS

    LVL 24

    Expert Comment

    by:DBAduck - Ben Miller
    Do you have VIEW SERVER STATE permission on the SQL Server?

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now