Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Data Collector Views (Transact-SQL)


Applies To: SQL Server 2014, SQL Server 2016 Preview

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)


Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft