Export (0) Print
Expand All

syscollector_config_store (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

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.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

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

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.

The following example queries the syscollector_config_store view.

SELECT parameter_name, parameter_value
FROM msdb.dbo.syscollector_config_store;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft