Activity Monitor SQL Server 2008 RTM



    Working with SQL Server 2008 RTM and I cannot find Activity Monitor. It appears to have gone missing.


    expected it to be here


    In SQL Server Management Studio, connect to the server with Object Explorer, expand Management, and then double-click Activity Monitor.

    Monday, August 11, 2008 9:55 PM


All replies


    I believe it has been moved...Right-CLick Server and then select Activity Monitor.





    Tuesday, August 12, 2008 3:56 AM
  • That works, thanks. But the RTM Books Online is flat out wrong in describing how to open it.


    Wednesday, August 13, 2008 6:00 PM

    Agreed, I needs to be updated as the conent in the Activty Monitor is pertaining to SQL Server 2005 and not 2008.  In 2008 the utility has been completely overhauled. 


    Ross Mistry


    My new book SQL Server 2008 Management and Administration will be out shortly!!!!

    Wednesday, August 13, 2008 6:02 PM
  • I think this blog will help you to locate activity monitor



    Thursday, August 14, 2008 1:52 AM
  • At the moment, when I try to use the Activity Monitor (SQL 2008) on my SQL 2000 database, it says that "This operation does not support connections to Microsoft SQL Server Standard Edition version 8.00.760".

    Which begs the question: What versions of SQL Server are supported by the SQL 2008 Activity Monitor? I'd really like one tool to use to monitor my SQL 2000 and SQL 2008 installations.

    Steve G.
    Monday, December 08, 2008 6:22 PM
  • The RTM version of the How To start Activity Monitor topic was corrected in the Books Online updates. The version on the Web and in the BOL download is correct. The topic also lists the permissions you required to run the Activity Monitor against instances of SQL Server 2000 and SQL Server 2005:





    Tuesday, December 09, 2008 6:03 PM
  • Sorry, but the info at that link is, at best, incomplete. Activity Monitor collects the version number of the server (along with a bunch of other configuration info) and then bails long before any table permissions could come into play. The question is, then, what versions are supported? Nobody seems to know.

    Steve G.
    Tuesday, December 09, 2008 8:05 PM
  • Has anyone found the answer to what versions of SQL Server are supported by SSMS 2008 and specifically Activity Monitor?
    Wednesday, February 11, 2009 3:38 PM