Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Towards the innovative SQL ideas
Browse by Tags · View All
ms sql server 119
ms sql 118
sql server 116
sql 115
database 102
tsql 81
#SQL Server 78
t-sql 75
#sql 71
sql server general 67

Archive · View All
April 2011 14
July 2011 12
May 2011 12
August 2011 11
June 2011 10
September 2011 8
December 2011 6
November 2011 6
June 2013 5
April 2013 5

SQLIdeas

SQL Server 2008 - Monitor SQL Server's Activity with Activity Monitor

Sep 13 2011 9:13AM by Paresh Prajapati   

With SQL server 2008 and the feature provided by it, This is very best feature for DBA people to get easily information for the SQL server details and process running inside it. You can read all features provided by SQL Server 2008

This feature is "Activity Monitor". With Activity Monitor we can monitor database server health, performance issues, CPU and memory monitor and we can easily troubleshoot after figuring the issues.

Below are some snaps of Activity Monitor.

1.Overview: have summery   with graphs and details.



2. Processes:


3. Resource Waits:

4. Database File I/O:



5. Recent Expensive Queries:



Keep it up to monitor SQL Server's activity!

Tags: sql, sql server 2008, sql server 2005, sql server, ms sql, ms sql server, sql server denali, #SQL Server, #sql, sql server 2011, database, sql server general, SQL new features, Performance,

Paresh Prajapati
6 · 22% · 7054
3
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect


Submit

1  Comments  

  • The Activity Monitor is much more than just a simple monitor.

    Paresh: Do go through the series on "Underappreciated Features of Microsoft SQL Server" - you will find more details on the Activity Monitor and a lot of other interesting, underappreciated features there.

    commented on Sep 27 2011 12:13PM
    Nakul Vachhrajani
    4 · 33% · 10575

Your Comment
Sign Up or Login to post a comment.
"SQL Server 2008 - Monitor SQL Server's Activity with Activity Monitor" rated 5 out of 5 by 3 readers
SQL Server 2008 - Monitor SQL Server's Activity with Activity Monitor , 5.0 out of 5 based on 3 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]