"Classic" activity monitor in SQL Server Management Studio 2008?
- by BradC
Right now I'm using SQL Server Management Studio 2005 to manage all my SQL servers (2000, 2005, 2008). I'd love to be able to take advantage of all the cool new features in SSMS 2008, the only thing holding me back is the new DMV-based activity monitor:
We are still 40% SQL 2000, which doesn't have the required DMVs for the new monitors
I don't like it as much as the old one :)
So has anyone made a plugin for SSMS 2008 that emulates the old activity monitor? If not, what about a slick set of scripts that accomplish the same thing or better, and work across 2000-2008 (more than just sp_who2)?