This topic has not yet been rated - Rate this topic

Data Collector Views (Transact-SQL)

SQL Server 2012

The data collector offers the following views for displaying information about the data collector configuration, such as collector type properties, collection sets, and collection set items, as well as execution statistics that are obtained when a collection set runs. These views, which are in the msdb database, also provide an abstraction layer for the underlying tables. This abstraction enhances security by preventing direct access to the tables, while permitting changes to the tables without affecting any associated applications.

syscollector_collection_items (Transact-SQL)	syscollector_collection_sets (Transact-SQL)
syscollector_collector_types (Transact-SQL)	syscollector_config_store (Transact-SQL)
syscollector_execution_log (Transact-SQL)	syscollector_execution_log_full (Transact-SQL)
syscollector_execution_stats (Transact-SQL)

Reference

Data Collector Stored Procedures (Transact-SQL)

Concepts

Data Collection

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD