Package element: LOOP - Query the query statitics DMV at collection frequency
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 |
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 |