Edit

View or change collection set schedules (SQL Server Management Studio)

  • Article

Applies to: SQL Server

You can view or change collection set schedules by using SQL Server Management Studio.

The collection mode, cached or non-cached, determines how you can make changes to a schedule. Cached mode uses separate schedules for collection and upload. Non-cached mode uses the same schedule for collection and upload. The type of collection mode for each of the system data collection sets is as follows:

  • Disk Usage uses non-cached collection mode
  • Query Statistics uses cached collection mode
  • Server Activity uses cached collection mode

View collection set schedules

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

  2. Right-click a collection set name, and then select Properties to open the Data Collection Set Properties dialog box.

Change the schedules for a cached mode collection set

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

  2. Right-click a collection set that uses cached mode, such as Query Statistics, and then select Properties to open the Data Collection Set Properties dialog box.

  3. You can change the collection frequency on the General page. To do this, follow these steps:

    1. In the details pane, double-click the number that is displayed for the Collection Frequency (sec) column in the Collection items table.

    2. To increase or decrease the collection frequency, type a lower or higher number, and then press ENTER to store the new value.

  4. To change the existing upload schedule for the collection set, follow these steps:

    1. Select the Uploads page.

    2. In the details pane, select Pick.

      The Pick Schedule for Job dialog box opens. The available schedules appear as a table.

    3. Select the row with the schedule that you want. For example, to change the schedule to every 5 minutes, select the row where the schedule name is CollectorSchedule_Every_5min.

      Note

      You can view and edit the properties for the selected schedule by selecting Properties to open the Job Schedule Properties dialog box for the schedule. You can use this dialog box to change schedule information, such as the frequency.

      As an alternative to modifying an existing schedule, you can create a new upload schedule by selecting New on the Uploads page. This action opens the New Job Schedule dialog box, which you can use to create a custom schedule.

    4. When you're finished configuring the schedule, select OK.

      The changes that you made appear on the Uploads page.

  5. Select OK to save the changes to the collection frequency and the upload schedule, and to close the Data Collection Set Properties dialog box.

Change the schedule for a non-cached mode collection set

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

  2. Right-click a collection set that uses non-cached mode, such as Disk Usage, and then select Properties to open the Data Collection Set Properties dialog box.

    The Data Collection Set Properties dialog box displays a paged view of the collection set properties.

  3. To change the schedule for the collection set, select Pick.

    The Pick Schedule for Job dialog box opens. The available schedules are displayed as a table.

  4. Select the row with the schedule that you want. For example, to change the schedule to every 5 minutes, select the row where the schedule name is CollectorSchedule_Every_5min.

    Note

    You can view and edit the properties for the selected schedule by selecting Properties to open the Job Schedule Properties dialog box for the schedule. You can use this dialog box to change schedule information, such as the frequency.

    As an alternative to modifying an existing schedule, you can create a new collect and upload schedule by selecting New on the General page. This action opens the New Job Schedule dialog box.

  5. When you're finished configuring the schedule, select OK.

  6. Select OK to save the changes and to close the Data Collection Set Properties dialog box.

Data Collection Set properties dialog box

General page

Use this page to configure how data is collected and uploaded, configure schedules, and configure data retention periods in the management data warehouse. This page also provides information about collection sets, such as collector types and collection frequencies, and the input parameters that are used for a collection set.

Name

Displays the name of the collection set that this page refers to.

Data collection and upload

Specifies how data is collected and uploaded to the management data warehouse. Pick one of the following options.

Option Description
Non-cached. Collection and data upload on the same schedule. When selected, specify one of the following options:

Schedule. Data is collected and uploaded according to a schedule. Select Pick to select from a predefined list of schedules, or select New to create a new schedule.

On-demand. Data is collected and uploaded on demand.
Cached. Collect and cache data at a set of collection frequencies. Upload cached data on a separate schedule. Collect and cache data for a specified collection frequency. Upload the collected data on a separate schedule.

Collection items

Displays the collection items in the collection set. The following information is provided for each collection item:

  • Name
  • Collector Type
  • Collection Frequency (secs). This field is editable if Data collection and upload is configured as cached. Double-click this cell to set the collection frequency.

Input parameters

Displays the input parameters used for the collection set.

Run as

Specifies the account used to run the collection set. By default this is the SQL Server Agent Service Account. If proxy accounts are defined, this list includes the names of the available proxy accounts.

Set how long collected data will be retained in the management data warehouse.

Specifies how long collected data is retained. Pick one of the following options.

Option Description
Retain data for This option is selected by default, and the default retention period is 14 days.
Retain data indefinitely There's no time limit on the length of time that data is retained.

Uploads page

Use this page to configure the upload schedule for data that is collected by this collection set.

Note

This tab is only enabled if the Cached option is configured for Data collection and upload.

Server

Displays the name of the server that hosts the management data warehouse. For more information, see Configure the management data warehouse (SQL Server Management Studio).

Management data warehouse

Displays the name of the management data warehouse. For more information, see Configure the management data warehouse (SQL Server Management Studio).

Last upload

Displays date and time information for the last upload done for the collection set.

Upload schedule

Specifies the upload schedule for the collection set. If enabled, Select Pick to select from a predefined list of schedules, or select New to create a new schedule.

Description page

Use this page to view a description of the collection set that this properties page refers to.

Related content