Package element: LOOP - Query the query statitics DMV at collection frequency

CollapseAll image

Collapse image 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

Collapse image 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

Collapse image See also


Package index