Where The Heck is Activity Monitor?

a-foton » Where The Heck is Activity Monitor?

a-foton » Where The Heck is Activity Monitor? — Fri, 11 Jul 2008 07:01:31 GMT

PingBack from http://blog.a-foton.ru/2008/07/where-the-heck-is-activity-monitor/

re: Where The Heck is Activity Monitor?

Tony S. — Sun, 20 Jul 2008 16:24:59 GMT

Neat. Don't mean to nitpick of course but there's a bit of effort in formatting that sql query for viewing though each and every time though.

Tony S.

re: Where The Heck is Activity Monitor?

ken@elm — Fri, 07 Nov 2008 17:35:02 GMT

Why oh why can't I resize the panels? I'm forced to scroll through about 8-1/2 (I counted) processes at a time. That is so incredibly cumbersome. 1 step forward, 2 steps back.

re: Where The Heck is Activity Monitor?

ESedmak — Fri, 07 Nov 2008 18:11:07 GMT

The new monitor auto-updates which makes it difficult to read since the list will reposition itself. Furthermore it does not list the current database the connection is made against; less information fits on the screen making it more difficult to read.

re: Where The Heck is Activity Monitor?

dtjones — Fri, 07 Nov 2008 19:04:03 GMT

You can change the refresh interval if you'd like. There are pros and cons to that. Just right-click in the Activity Monitor and you'll get a context menu for setting the refresh interval.

Remember to use Connect (http://connect.microsoft.com/SQLServer/Feedback) to submit suggestions on making the features better. Items submitted through Connect flow right into our work tracking database.

re: Where The Heck is Activity Monitor?

Tim — Wed, 11 Feb 2009 00:39:31 GMT

Why can't I see open databases anymore?

re: Where The Heck is Activity Monitor?

KMB — Thu, 27 Aug 2009 19:42:02 GMT

Still no DBCC INPUTBUFFER unless you right-click / Details each SPID. I have a thousand connections and want to see what sprocs they're all executing at a glance. I wrote code to do this - simple loop on SPIDs pumping DBCC into a table var. Would be a nice enhancement for activity monitor. Drilling straight into the execution plan is nice. Changing the launchpoint seems odd though.

re: Where The Heck is Activity Monitor?

Brad Currens — Thu, 22 Oct 2009 02:26:57 GMT

yes, why can you resize the process panel already. i want it FULL SCREEN.

re: Where The Heck is Activity Monitor?

dtjones — Thu, 22 Oct 2009 16:14:54 GMT

Good suggestion Brad. You should submit it through http://connect.microsoft.com/sqlserver.