Skip to content

Latest commit

 

History

History
72 lines (48 loc) · 2.37 KB

enable-or-disable-data-collection.md

File metadata and controls

72 lines (48 loc) · 2.37 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Enable or disable data collection
Enable or disable data collection with SQL Server Management Studio or Transact-SQL.
MashaMSFT
mathoma
randolphwest
12/28/2023
sql
supportability
conceptual
data collector [SQL Server], disabling
data collector [SQL Server], enabling

Enable or disable data collection

[!INCLUDE SQL Server]

This article describes how to enable or disable data collection in [!INCLUDE ssnoversion] by using [!INCLUDE ssManStudioFull] or [!INCLUDE tsql].

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 [!INCLUDE ssDE].

  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 [!INCLUDE ssDE].

  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;

Related content