Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Activity Monitor in SQL Server 2008 Expand / Collapse
Author
Message
Posted Thursday, July 17, 2008 10:31 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, April 4, 2014 4:40 PM
Points: 751, Visits: 917
I recently started evaluating the CTP for SQL Server 2008, and I noticed that the Activity Monitor Gui under Management is not listed. It is clearly not needed since all of its functionality can be achieved from T-SQL, but I was curious about if it was deliberately removed and why? Or is this something with my particular installation?

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
Post #536147
Posted Thursday, July 17, 2008 11:35 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 8:44 AM
Points: 1,073, Visits: 6,334
I believe you'll find that in RC0 but not the CTP's. And if you have RC0, Activity Monitor can be found as an icon on the toolbar in SSMS or a right click on the server name in object explorer.
Post #536187
Posted Thursday, July 17, 2008 12:16 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:38 AM
Points: 13,755, Visits: 28,147
And the functionality has improved a ton. I love being able to pull execution plans right off the screen.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #536224
Posted Thursday, July 17, 2008 5:49 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, April 4, 2014 4:40 PM
Points: 751, Visits: 917
Thank you both, I found it immediately by right clicking, and the functionality is definitely greatly improved.

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
Post #536399
Posted Friday, June 24, 2011 2:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 26, 2013 2:45 PM
Points: 1, Visits: 74
I totally disagree. The added functionality is far outweighed by what was stripped out.

- The task manager like graphs at the top of summary values for the whole instance. This isn't very useful for me.
- Expanding out one column causes the other columns to be 'resized' so they all fit within the screen, whereas before I had a scroll bar. Trying to expand out several columns makes others unreadable.
- The Processes list does not give me details on the cpu and physical io that each SPID is consuming.
- You can't filter on multiple column values, you can only select single values from the column drop-down lists.
- The Recent Expensive Queries section looked promising, but is nearly useless because it there isn't an easy way to tie it back to the SPID (now called Session ID).
- The Data File I/O, and Resource Waits sections only provide you with summary information on a per instance, or per database.

I have to manage a multi-database environment, and previously used the SQL 2005 activity monitor for an at-a-glance view of what was going on. The lack of flexibility and granularity in the new SQL 2008 Activity manager is going to make my job a lot more difficult.

Does anyone know if there is another dashboard type tool that Microsoft provides to get this information?
Post #1131447
Posted Saturday, June 25, 2011 4:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:38 AM
Points: 13,755, Visits: 28,147
pcarroll-626929 (6/24/2011)
I totally disagree. The added functionality is far outweighed by what was stripped out.

- The task manager like graphs at the top of summary values for the whole instance. This isn't very useful for me.
- Expanding out one column causes the other columns to be 'resized' so they all fit within the screen, whereas before I had a scroll bar. Trying to expand out several columns makes others unreadable.
- The Processes list does not give me details on the cpu and physical io that each SPID is consuming.
- You can't filter on multiple column values, you can only select single values from the column drop-down lists.
- The Recent Expensive Queries section looked promising, but is nearly useless because it there isn't an easy way to tie it back to the SPID (now called Session ID).
- The Data File I/O, and Resource Waits sections only provide you with summary information on a per instance, or per database.

I have to manage a multi-database environment, and previously used the SQL 2005 activity monitor for an at-a-glance view of what was going on. The lack of flexibility and granularity in the new SQL 2008 Activity manager is going to make my job a lot more difficult.

Does anyone know if there is another dashboard type tool that Microsoft provides to get this information?


Note, this is a three year old thread:


None that are provided from Microsoft, no.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1131609
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse