15.1. Component overview
The data collection platform comprises three key components: the Data Collector, collection sets, and the management data warehouse. These components work together to enable information to be automatically collected and stored for later analysis and reporting. Before we focus on the setup, administration, and benefits of this platform, let's walk through an overview of the key components.
15.1.1. Data Collector
The Data Collector component controls the collection and upload of information from a SQL Server instance to the management data warehouse using a combination of SQL Server Agent jobs and SQL Server Integration Services (SSIS) packages. The information collected is defined in the data collection sets.
15.1.2. ...
Get SQL Server 2008 Administration in Action 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.
