SQL Server 2008 Improvements Practicals – PowerShell – Activity Monitor

I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for 10:00am - "Panic Button":

All of us get called from our cubes to come take a look at a performance problem. You've probably got a box of scripts somewhere that you use to show the state of the system - but now you have something new. We've completely re-engineered the Activity Monitor - you know, the one that used to show the current connections and a little about what was happening with them? Now, it's a set of active graphical charts, rearrangable (is that a word?) columns and report bands, complete with sorting and filters. You get information on everything from CPU to Waits and I/O.

Not only can you see the activity graphically, you can right-click on a statement and evaluate it in the Query Window. Oh - and one final thing - you can now change the "General" options for startup to start right into the Activity Monitor.

Skip to main content