• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3857
  • Last Modified:

MS SQL 2008 Activity Monitor does not work

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.

1 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

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

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now