Skip to content

Latest commit

 

History

History
90 lines (57 loc) · 3.66 KB

start-or-stop-a-collection-set.md

File metadata and controls

90 lines (57 loc) · 3.66 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Start or stop a collection set
Start or stop a collection set with SQL Server Management Studio or Transact-SQL.
MashaMSFT
mathoma
randolphwest
12/28/2023
sql
supportability
conceptual
collection sets [SQL Server], stopping
collection sets [SQL Server], starting

Start or stop a collection set

[!INCLUDE SQL Server]

This article describes how to start or stop a collection set in [!INCLUDE ssnoversion] by using [!INCLUDE ssManStudioFull] or [!INCLUDE tsql].

Limitations

Data collector stored procedures and catalog views are stored in the msdb database.

Unlike regular stored procedures, the parameters for data collector stored procedures are strictly typed and don't support automatic data type conversion. If these parameters aren't called with the correct input parameter data types, as specified in the argument description, the stored procedure returns an error.

Prerequisites

[!INCLUDE ssnoversion-md] Agent must be started.

Recommendations

To obtain information about collection sets, query the syscollector_collection_sets catalog view.

Permissions

Requires membership in the dc_operator fixed database role. If the collection set doesn't have a proxy account, membership in the sysadmin fixed server role is required.

Use SQL Server Management Studio

Start a collection set

  1. In Object Explorer, expand the Management node, expand Data Collection, and then expand System Data Collection Sets.

  2. Right-click the collection set that you want to start, and then select Start Data Collection Set.

    A message box displays the results of this action, and a green arrow on the icon for the collection set indicates that the collection set has started.

Stop a collection set

  1. In Object Explorer, expand the Management node, expand Data Collection, and then expand System Data Collection Sets.

  2. Right-click the collection set that you want to stop, and then select Stop Data Collection Set.

    A message box displays the results of this action, and a red circle on the icon for the collection set indicates that the collection set has stopped.

Use Transact-SQL

Start a collection set

  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_start_collection_set to start the collection set that has the ID of 1.

USE msdb;
GO
EXEC sp_syscollector_start_collection_set @collection_set_id = 1;

Stop a collection set

  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_stop_collection_set to stop the collection set that has the ID of 1.

USE msdb;
GO
EXEC sp_syscollector_stop_collection_set @collection_set_id = 1;

Related content