Package element: CWM - Remove Upload Snapshots Older Than CacheWindow
Properties
| Name | Value |
| ApartmentThreaded | True |
| CacheFileNamePrefixVarName | User::InterestingQueriesSnapshotFileNamePrefixPattern |
| CacheWindow | 0 |
| CollectionSetUID | |
| CollectorTempDir | |
| CollectorTypeUID | |
| ConfigConnectionString | |
| CreationName | Microsoft.SqlServer.Management.Collector.Tasks.CacheWindowMaintainanceTask, Microsoft.SqlServer.Management.CollectorTasks, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 |
| DebugMode | False |
| DelayValidation | False |
| Description | Cache Window Maintainance Task |
| Disable | False |
| DisableEventHandlers | False |
| ExecutionDuration | 0 |
| ExecutionResult | Success |
| ExecutionStatus | None |
| ExitEventName | |
| FailPackageOnFailure | False |
| FailParentOnFailure | True |
| ForcedExecutionValue | 0 |
| ForceExecutionResult | None |
| ForceExecutionValue | False |
| HasExpressions | True |
| HostType | Task |
| ID | {C8B1E699-7A73-4ECD-A317-B9E91002738D} |
| InstanceName | |
| IsDefaultLocaleID | True |
| IsolationLevel | Serializable |
| ItemID | 0 |
| LocaleID | English (United States) |
| LoggingLevel | 0 |
| LoggingMode | Disabled |
| LoopEventName | |
| MaximumErrorCount | 0 |
| MdwConnectionString | |
| Name | CWM - Remove Upload Snapshots Older Than CacheWindow |
| SuspendRequired | False |
| TargetConnectionString | |
| TargetServerVersion | 130 |
| TaskDisplayName | Cache Window Maintainance Task |
| TransactionOption | Supported |
| Version | 0 |
Elements
| Name | Description | Type |
| CacheFileNamePrefixVarName | Expressions | |
| CacheDirectory | Variables | |
| CacheWindow | Variables | |
| CollectionCacheFileName | Stores snapshots of dm_exec_requests | Variables |
| CollectionCacheFileNameOutput | Stores snpashots of dm_exec_requests. This variable is used as temporary cached file name during the upload. | Variables |
| CollectionCacheFilePrefixPattern | Prefix for files related to dm_exec_requets collection | Variables |
| CollectionSetUID | Variables | |
| CollectorTypeUID | Variables | |
| ConfigConnectionString | Variables | |
| DaysUntilExpiration | Variables | |
| ExitEventName | Variables | |
| InputParameters | Variables | |
| InstanceID | Variables | |
| InstanceName | Variables | |
| InterestingQueries_HighCpuUsage | Variables | |
| InterestingQueries_HighIoCount | Variables | |
| InterestingQueries_HighMemoryUsage | Variables | |
| InterestingQueries_HighTransactionCount | Variables | |
| InterestingQueries_LargeResultset | Variables | |
| InterestingQueries_LongRunningRequest | Variables | |
| InterestingQueries_LongWaitingRequest | Variables | |
| InterestingQueriesCount | Variables | |
| InterestingQueriesLastSnapshotFileName | Stores the most recent copy of snapshot of dm_exec_query_stats saved from the previous execution of this package. | Variables |
| InterestingQueriesLastSnapshotFileNameOutput | Stores temporary copy of the most recent snapshot of dm_exec_query_stats | Variables |
| InterestingQueriesSnapshotFileNamePrefixPattern | Prefix for files related to dm_exec_query_stats collection. | Variables |
| ItemID | Variables | |
| LoggingLevel | Variables | |
| LogID | Variables | |
| LoopDuration | Variables | |
| LoopEventName | Variables | |
| MDWConnectionString | Variables | |
| ParentLogID | Variables | |
| SnapshotId | Variables | |
| SnapshotQueryStatsQuery | Variables | |
| SourceId | Variables | |
| TargetConnectionString | Variables | |
| TopThreshold | Variables |
See also