| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
Configure properties of a data collector |
Configure properties of a data collector in SQL Server Management Studio. |
MashaMSFT |
mathoma |
randolphwest |
12/28/2023 |
sql |
supportability |
conceptual |
|
[!INCLUDE SQL Server]
This article discusses how you can configure the properties of a data collector.
Use this page to configure settings for the management data warehouse, and specify where collected data should be stored before it uploads to the data warehouse.
Select this checkbox to enable data collection. This has the same effect as running the sp_syscollector_enable_collector stored procedure. Clearing this checkbox disables data collection and has the same effect as running the sp_syscollector_disable_collector stored procedure.
Displays the name of the server that will host the management data warehouse
Displays the name of the relational database that is used for the management data warehouse.
Test the connection to the specified Server using information provided when data collection is configured.
Specifies the directory where collected data is stored on the system collecting the data before it's uploaded to the management data warehouse. If Cache directory isn't specified, the data collector attempts to locate the %TEMP% and %TMP% environment variables, and uses one these locations as the default location for temporary storage. If these environment variables aren't configured, an error occurs and you're prompted to create a cache directory.
Use this page to configure the retry settings for the connection to the management data warehouse.
Specifies the number of times to retry an upload to the management data warehouse if an upload fails. The default is 1.