SQL Server 2008 – Data Collector

Leave a comment (0) Go to comments

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.

How TO

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.

EOF - SQL Server 2008 – Data Collector, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.