Good stuff courtesy of Microsoft!
Buck Woody, a program manager at Microsoft, had a blog over on the MSDN about the activity monitor, and a cool little feature that it has. Check it out here:
http://blogs.msdn.com/buckwoody/archive/2010/01/21/hovering-over-the-titles-in-activity-monitor.aspx
My problem was...I didn't know where the hell the activity monitor was and how to open it. So if you go to SSMS in 2008 and go to the end of the standard toolbar, you'll see a little icon right under help. Kind of looks like an EKG screen:
Click on it and then follow his instructions - you'll see that the info he's talking about comes up in a popup. Very nice. Thanks, Buck!!!
Lee Everest
--------------------------------
Someone should write a book on DMVs and DMFs. Maybe Management Studio, too.
5804bbf8-f5d3-4803-9777-5df1c506a7eb|0|.0