Share via


syscollector_config_store (Transact-SQL)

Returns properties that apply to the entire data collector, as opposed to a collection set instance. Each row in this view describes a specific data collector property, such as the name of the management data warehouse, and the instance name where the management data warehouse is located.

Column name

Data type

Description

parameter_name

nvarchar(128)

The name of the property. Is not nullable.

parameter_value

sql_variant

The actual value of the property. Is nullable.

Permissions

Requires SELECT permission on the view or membership in the dc_operator, dc_proxy, or dc_admin fixed database roles.

Remarks

The list of properties available is fixed and their values can only be changed using the appropriate stored procedure. The following table describes the properties that are exposed through this view.

Property name

Description

CacheDirectory

The name of the directory in the file system where the collector type packages store temporary information.

NULL = the default temporary SQL Server directory is used.

CacheWindow

Indicates the data retention policy of the cache directory for failed data uploads.

-1 = Retain the data from all upload failures.

0 = Do not retain any data from upload failures.

n = Retain data from n previous upload failures, where n >= 1.

Use the sp_syscollector_set_cache_window stored procedure to change this value.

CollectorEnabled

Indicates the state of the data collector.

0 = disabled

1 = enabled

Use either the sp_syscollector_enable_collector or sp_syscollector_disable_collector stored procedure to change this value.

MDWDatabase

The name of the management data warehouse. Use the sp_syscollector_set_warehouse_database_name stored procedure to change this value.

MDWInstance

The name of the SQL Server instance for the management data warehouse. Use the sp_syscollector_set_warehouse_instance_name stored procedure to change this value.

Examples

The following example queries the syscollector_config_store view.

SELECT parameter_name, parameter_value
FROM msdb.dbo.syscollector_config_store;