data-collector-views-transact-sql.md

title	Data Collector Views (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql
ms.prod_service	database-engine
ms.service
ms.component	system-catalog-views
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	data collector view data collector [SQL Server], views
ms.assetid	a005e885-7813-4c7e-b332-b01d9e9d4054
caps.latest.revision	14
author	stevestein
ms.author	sstein
manager	craigg
ms.workload	Inactive

Data Collector Views (Transact-SQL)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

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)

See Also

Data Collection
Data Collector Stored Procedures (Transact-SQL)