The Data Collector is a straightforward system that you can use to continually monitor performance and store this information in a management data warehouse database for historical monitoring and trend analysis. Previously, there was no single integrated tool to collect, store, and view performance data for SQL Server
The Data Collector is essentially a set of SQL Server Agent jobs and SQL Server Integration Services (SSIS) packages that upload data to the management data warehouse database. SQL Server Agent must be running for the Data Collector to function. The Data Collector also provides an application programming interface (API) for third-party applications to access the performance data.
The Data Collector makes extensive use of SQL Server Agent and SSIS. SQL Server Agent schedules the Data Collector run-time component, which then executes the Data Collector SQL Server Integration Services packages. These packages collect the data from the data providers and upload it to the management data warehouse. The various components of the Data Collector reside in four categories: storage, execution, API, and client.
• The storage category consists of databases that contain configuration information and store performance data:
• The msdb database contains configuration information.
• A user-defined database stores the performance data.
• The execution category consists of SQL Server Agent jobs and SSIS packages for data collection and storage:
• SQL Server Agent is responsible for scheduling.
• SSIS is responsible for data collection and uploading.
• The API category consists of API components that provide the connection between user interfaces and the Data Collector.
• The client category consists of the user interfaces.
Before you can begin to collect and analyze data, you must perform a series of task to configure the data collection:
1. Configure a database to store the collected data.
2. Set up data collection sets.
3. Enable data collection.
After you have completed these tasks, you can begin to collect data into your specified database and run reports on the collected data.
Soon I will be posting a Video tutorial on this.