Applies To: SQL Server 2014, SQL Server 2016 Preview
Sets the number of times to attempt a data upload in case of failure. Retrying an upload in the event of a failure mitigates the risk of losing collected data.
Applies to: SQL Server (SQL Server 2008 through current version).
- [ @cache_window = ] cache_window
Is the number of times a failed data upload to the management data warehouse is retried without losing data. cache_window is int with a default value of 1. cache_window can have one of the following values:
Cache all the upload data from the previous upload failures.
Do not cache any data from an upload failure.
Cache data from n previous upload failures, where n >= 1.
0 (success) or 1 (failure)
Requires membership in the dc_admin (with EXECUTE permission) fixed database role to execute this procedure.
The following example disables the data collector, configures the cache window to retain data for up to three failed uploads, and then enables to data collector.