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.