Data Collection
SQL Server provides a data collector that you can use to obtain and save data that is gathered from several sources. The data collector enables you to use data collection containers, which enable you to determine the scope and frequency of data collection on a computer that is running SQL Server.
The following table describes the topics in this section.
In This Section
Topic |
Description |
---|---|
Describes the data collector in general. |
|
Describes the installation requirements for this release of the data collector. |
|
Describes the terminology used for data collection and the data collector. |
|
Describes the data collector architecture and processing during data collection. |
|
Describes the predefined system data collection sets that are provided with the data collector. |
|
Describes the data collection set that is installed on each instance of SQL Server 2008 R2 that is managed by a utility control point. |
|
Describes the generic collector types that are provided with the data collector. |
|
Describes security for the various data collector components, as well as the data retained in the management data warehouse. |
|
Describes the data collector run-time logging mechanism and the information that is provided by the logs that it creates. |
|
Describes data collector error handling and error recovery. |
|
Describes the management data warehouse that the data collector uses for storing collected data. |
|
Describes using SQL Server Management Studio and Transact-SQL to configure and manage data collection. |