Enable or Disable Data Collection

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

In This Topic

• Before you begin:

  Security

• To enable or disable data collection, using:

  SQL Server Management Studio

  Transact-SQL

Before You Begin

Security

Permissions

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

[Top]

Using SQL Server Management Studio

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.

[Top]

Using Transact-SQL

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;

[Top]

See Also

Reference

System Stored Procedures (Transact-SQL)

Concepts

Data Collection