View or Change Collection Set Schedules (SQL Server Management Studio)

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 Datacollection sets is as follows:

  • Disk Usage uses non-cached collection mode.

  • Query Statistics uses cached collection mode.

  • Server Activity uses cached collection mode.

To 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 click Properties to open the Data Collection Set Properties dialog box.

To 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 click 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. Click the Uploads page.

    2. In the details pane, click Pick.

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

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

      Note

      You can view and edit the properties for the selected schedule by clicking 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 clicking 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 are finished configuring the schedule, click OK.

      The changes that you made appear on the Uploads page.

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

To 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 click 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, click Pick.

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

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

    Note

    You can view and edit the properties for the selected schedule by clicking 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 clicking New on the General page. This action opens the New Job Schedule dialog box.

  5. When you are finished configuring the schedule, click OK.

  6. Click 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, as well as 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.

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

Schedule. Data is collected and uploaded according to a schedule. Click Pick to select from a predefined list of schedules, or click 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.

Retain data for This option is selected by default, and the default retention period is 14 days.
Retain data indefinitely There is 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, Click Pick to select from a predefined list of schedules, or click 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.

See Also

Manage Data Collection
Data Collection