Subscribe to this blog
Briefcase
Print
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
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/
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