Export (0) Print
Expand All

Enable or Disable Data Collection

This topic describes how to enable or disable data collection in SQL Server 2014 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.

Arrow icon used with Back to Top link [Top]

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.

Arrow icon used with Back to Top link [Top]

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;

Arrow icon used with Back to Top link[Top]

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft