Skip to content

enable-or-disable-data-collection.md

Latest commit

 

History

History
72 lines (48 loc) · 2.36 KB

enable-or-disable-data-collection.md

File metadata and controls

72 lines (48 loc) · 2.36 KB
title Enable or disable data collection
description Enable or disable data collection with SQL Server Management Studio or Transact-SQL.
author MashaMSFT
ms.author mathoma
ms.reviewer randolphwest
ms.date 12/28/2023
ms.service sql
ms.subservice supportability
ms.topic how-to
helpviewer_keywords
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