Enable or disable data collection

Applies to: SQL Server

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

Permissions

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

Use SQL Server Management Studio

Enable the data collector

  1. In Object Explorer, expand the Management node.

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

Disable the data collector

  1. In Object Explorer, expand the Management node.

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

Use Transact-SQL

Enable the data collector

  1. Connect to the Database Engine.

  2. From the Standard bar, select New Query.

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

USE msdb;
GO
EXEC dbo.sp_syscollector_enable_collector;

Disable the data collector

  1. Connect to the Database Engine.

  2. From the Standard bar, select New Query.

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

USE msdb;
GO
EXEC dbo.sp_syscollector_disable_collector;