Package element: LOOP - Query the query statitics DMV at collection frequency
Properties
| Name | Value |
| CreationName | STOCK:FOREACHLOOP |
| DebugMode | False |
| DelayValidation | False |
| Description | Foreach Loop Container |
| Disable | False |
| DisableEventHandlers | False |
| ExecutionDuration | 0 |
| ExecutionResult | Success |
| ExecutionStatus | None |
| FailPackageOnFailure | False |
| FailParentOnFailure | True |
| ForcedExecutionValue | 0 |
| ForceExecutionResult | None |
| ForceExecutionValue | False |
| HasExpressions | True |
| ID | {3728E9CD-A948-47F5-B2A9-26BC486A8CD8} |
| IsDefaultLocaleID | True |
| IsolationLevel | Serializable |
| LocaleID | English (United States) |
| LoggingMode | Disabled |
| MaximumErrorCount | 0 |
| Name | LOOP - Query the query statitics DMV at collection frequency |
| SuspendRequired | False |
| TransactionOption | Supported |
Elements
| Name | Description | Type |
| SEQ - Synchronize Access to Cache File | Sequence Container | Executables |
| SQL - Log Package Iteration | Execute SQL Task | Executables |
| SQL - Log Package Stats | Execute SQL Task | Executables |
| {7283E196-D60C-438F-A58A-0EA1F41BBCF4} | ForEachEnumerator | |
| Constraint | PrecedenceConstraints | |
| Constraint 1 | PrecedenceConstraints | |
| DMVErrorRowCount | Variables | |
| DMVInOutRowCount | Variables | |
| CacheDirectory | Variables | |
| CacheFilePrefixPattern | Variables | |
| CacheWindow | Variables | |
| CollectionSetUID | Variables | |
| CollectorTypeUID | Variables | |
| ConfigConnectionString | Variables | |
| DaysUntilExpiration | Variables | |
| ExitEventName | Variables | |
| InputParameters | Variables | |
| InstanceID | Variables | |
| InstanceName | Variables | |
| ItemID | Variables | |
| LoggingLevel | Variables | |
| LogID | Variables | |
| LoopDuration | Variables | |
| LoopEventName | Variables | |
| MDWConnectionString | Variables | |
| ParentLogID | Variables | |
| SnapshotExecRequestQuery | Variables | |
| TargetConnectionString | Variables |
See also