Skip to content

data-collector-views-transact-sql.md

Latest commit

 

History

History
46 lines (36 loc) · 2.59 KB

data-collector-views-transact-sql.md

File metadata and controls

46 lines (36 loc) · 2.59 KB
title Data Collector Views (Transact-SQL)
description Data Collector Views (Transact-SQL)
author rwestMSFT
ms.author randolphwest
ms.date 03/06/2017
ms.prod sql
ms.prod_service database-engine
ms.technology system-objects
ms.topic reference
helpviewer_keywords
data collector view
data collector [SQL Server], views
dev_langs
TSQL
ms.assetid a005e885-7813-4c7e-b332-b01d9e9d4054

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.

:::row::: :::column::: syscollector_collection_items (Transact-SQL)

    [syscollector_collector_types (Transact-SQL)](../../relational-databases/system-catalog-views/syscollector-collector-types-transact-sql.md)
    
    [syscollector_execution_log (Transact-SQL)](../../relational-databases/system-catalog-views/syscollector-execution-log-transact-sql.md)
    
    [syscollector_execution_stats (Transact-SQL)](../../relational-databases/system-catalog-views/syscollector-execution-stats-transact-sql.md)
:::column-end:::
:::column:::
    [syscollector_collection_sets (Transact-SQL)](../../relational-databases/system-catalog-views/syscollector-collection-sets-transact-sql.md)
    
    [syscollector_config_store (Transact-SQL)](../../relational-databases/system-catalog-views/syscollector-config-store-transact-sql.md)
    
    [syscollector_execution_log_full (Transact-SQL)](../../relational-databases/system-catalog-views/syscollector-execution-log-full-transact-sql.md)
:::column-end:::

:::row-end:::

See Also

Data Collection
Data Collector Stored Procedures (Transact-SQL)