Configuring a Management Data Warehouse
SQL Server 2008 has a built-in feature called the management data warehouse. This feature uses several special-purpose data collector sets to automatically collect disk usage, query statistics, and server activity information. To use this feature, you must configure a data collection host and then set up data collection for SQL Server instances you want to track.
Understanding Management Data Warehouses
When you configure a management data warehouse, you can enable data collection whenever you want to monitor SQL Server performance and then generate reports to review the collected information. When you are finished evaluating SQL Server performance, you should free server resources used for collection by disabling ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
