Enable or Disable Data Collection

 

Applies To: SQL Server 2016

This topic describes how to enable or disable data collection in SQL Server 2016 by using SQL Server Management Studio or Transact-SQL.

In This Topic

Security

Permissions

Requires membership in the dc_admin or dc_operator (with EXECUTE permission) fixed database role to execute this procedure.

To enable the data collector

  1. In Object Explorer, expand the Management node.

  2. Right-click Data Collection, and then click Enable Data Collection.

To disable the data collector

  1. In Object Explorer, expand the Management node.

  2. Right-click Data Collection, and then click Disable Data Collection.

To enable the data collector

  1. Connect to the Database Engine.

  2. From the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute. This example uses sp_syscollector_enable_collector to enable the data collector.

USE msdb;  
GO  
EXEC dbo.sp_syscollector_enable_collector ;  

To disable the data collector

  1. Connect to the Database Engine.

  2. From the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute. This example uses sp_syscollector_disable_collector to disable the data collector.

USE msdb;  
GO  
EXEC dbo.sp_syscollector_disable_collector;  

Data Collection
System Stored Procedures (Transact-SQL)

Community Additions

ADD
Show: