syscollector_collection_items (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns information about an item in a collection set.

Column nameData typeDescription
collection_set_idintIdentifies the collection set. Is not nullable.
collection_item_idintIdentifies an item in the collection set. Is not nullable.
collector_type_uiduniqueidentifierThe GUID used to identify the collector type. Is not nullable.
namenvarchar(4000)The name of the collection set. Is nullable.
frequencyintThe frequency that data is collected by a collection item. Is not nullable.
parametersxmlDescribes the parameterization for the collector type associated with the collection item. The XML schema for this collection item is validated with the XML Schema (XSD) stored in the parameter_schema for a particular collector type. Is nullable. For more information, see syscollector_collector_types (Transact-SQL).

Requires SELECT for dc_operator, dc_proxy.

Data Collector Stored Procedures (Transact-SQL)
Data Collector Views (Transact-SQL)
Data Collection

Community Additions

ADD
Show: