Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server 2008 Activity Monitor

For those people who like to use the Activity Monitor in the SQL Server Management Studio GUI instead of, or along with,  sp_who, sp_who2 and DMVs in SQL Server, it is not where you left it in SQL Server 2005.

To view the activity monitor interface in SQL Server 2008 Management studio you need to:

1. Connect to the instance in Object Explorer

2. Right-Click the <Server Name>

3. Select <Activity Monitor>

It should the open as a pane on the right-hand window

ActivityMonitor

Brad McGehee has a good article over on Simple Talk where he explains the new improvements and features that can be found in Activity Monitor in SQL Server 2008 http://www.simple-talk.com/sql/learn-sql-server/management-studio-improvements-in-sql-server-2008/

Comments

Posted by Anonymous on 26 March 2010

Pingback from  Twitter Trackbacks for                 SQL Server Central, SQL Server 2008 Activity Monitor - The SQL DBA in the UK         [sqlservercentral.com]        on Topsy.com

Posted by Anonymous on 22 May 2010

Pingback from  Biscayne Watch, 1966 Biscayne Parts Impala Bel Air

Posted by Anonymous on 22 May 2010

Pingback from  Buy V3500 Warm Vicks Natural Mist Humidifier, Find Gmc V3500 Click Here

Posted by Anonymous on 23 May 2010

Pingback from  280se Part Book, 280sel Breeders Mercedes Parts - 346.1fh.org

Posted by Anonymous on 24 May 2010

Pingback from  Citation Xls Sale Hawker Aircraft, Chevrolet Citation Replacement A1 Cardone - 67.codebluehacks.org

Posted by Anonymous on 24 May 2010

Pingback from  350d Aftermarket Engine Guards, Acura Mdx Aftermarket Navigation Rims - 73.ja3ra.com

Posted by Anonymous on 24 May 2010

Pingback from  Heavy Duty Designs Ltd, E 650 Super Duty Pt New Ford - 480.luna-atra.net

Posted by Anonymous on 24 May 2010

Pingback from  1998 Nissan Maxima Parts Catalytic Converter 409 Stainless Steel, Headlight 2003 Nissan Maxima Direct Fit - 52.zapstreaming.com

Posted by Anonymous on 25 May 2010

Pingback from  Starfire Druid, Starfire Video They - 69.1fh.org

Posted by Anonymous on 25 May 2010

Pingback from  Elmo P10s Visualiser, P10 Bus S10 Blazer Silverado 2500 - 199.mfbattle.com

Posted by Anonymous on 25 May 2010

Pingback from  Used Saturn Relay 3 Minivan, Relay 2 Part 2007 Saturn Front Wheel Drive Trim - 288.dlmreza.net

Posted by Anonymous on 25 May 2010

Pingback from  Auction Saturn L100, 150 Wholesale Ford E Econoline - 70.mfbattle.com

Posted by Anonymous on 25 May 2010

Pingback from  B2500 Discount Car Parts Headlight Assembly Replacement Bumper, Buy B2500 Mx 5 Mazda Protege5 - 83.myipgirl.com

Posted by Anonymous on 25 May 2010

Pingback from  Discount Rebates Chevrolet Silverado 2500 Hd, 2002 Chevy Silverado Tire Size - 210.defutbolazo.com

Posted by Anonymous on 25 May 2010

Pingback from  R500 Model Discount Brake, Cheap G25 G2500 Truck - 214.1fh.org

Posted by Anonymous on 25 May 2010

Pingback from  260e Boiler Assy, 260e Central Heating Mls Listings Garage Parking - 108.mfbattle.com

Posted by Anonymous on 25 May 2010

Pingback from  280c Hardtop, 280c Fog Light - 143.rkwrh.com

Leave a Comment

Please register or log in to leave a comment.