System Data Collection Reports


Server Activity Report
The Server Activity report, like the rest is rendered by selecting the report from the series of menus that are displayed by right clicking on the Object Explorer menu.  Below are two screen shots that show what data is available on the Server Activity report: 


 


As you can see there are lots of different graphs to help you identify the resource usage trends for my machine. You can click on each one of these graphs to drill down and get more detailed information.  Below are two screenshots that show the information available when I drill down by clicking on the “Memory Usage” graph above.  





Data Collection Reports
Microsoft has done a great job of building some out of the three data collections and associated reports into SQL Server 2008.  All it takes to use these reports is to configure the Management Data Warehouse, and enable the system data collections.  Once configured and enabled a DBA can get a wealth of performance and capacity information to better manage their environment.

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |