Package element: SEQ - Capture and analyze query statistics and query plan and text

CollapseAll image

Collapse image Properties


 Name   Value 
CreationName STOCK:SEQUENCE
DebugMode False
DelayValidation False
Description Sequence Container
Disable False
DisableEventHandlers False
ExecutionDuration 0
ExecutionResult Success
ExecutionStatus None
FailPackageOnFailure False
FailParentOnFailure True
ForcedExecutionValue 0
ForceExecutionResult None
ForceExecutionValue False
HasExpressions False
ID {5D4817CD-0B0D-4F38-9BD7-6D5FEE0A1D6C}
IsDefaultLocaleID True
IsolationLevel Serializable
LocaleID English (United States)
LoggingMode Disabled
MaximumErrorCount 0
Name SEQ - Capture and analyze query statistics and query plan and text
SuspendRequired False
TransactionOption Supported

Collapse image Elements


 Name   Description   Type 
DFT - Create Interesting Queries Last Snapshot Data Flow Task Executables
DFT - Create Interesting Queries Upload Batch Data Flow Task Executables
DFT - Find and save plan text Data Flow Task Executables
DFT - Find and save sql text Data Flow Task Executables
FAT - Check Interesting Queries Last Snapshot exists File Access Task Executables
FST - Rename Current Snapshot File as Last Snapshot File File System Task Executables
SQL - Log stats for Interesting Queries Execute SQL Task Executables
SQL - Log stats for sql plan Execute SQL Task Executables
SQL - Log stats for sql text Execute SQL Task Executables
Constraint   PrecedenceConstraints
Constraint 1   PrecedenceConstraints
Constraint 2   PrecedenceConstraints
Constraint 3   PrecedenceConstraints
Constraint 5   PrecedenceConstraints
Constraint 6   PrecedenceConstraints
Constraint 7   PrecedenceConstraints
Constraint 8   PrecedenceConstraints
Last Snapshot Missing   PrecedenceConstraints
InterestingQueriesRowCountIn   Variables
InterestingQueriesRowCountOut   Variables
SqlPlanRowCountError   Variables
SqlPlanRowCountIn   Variables
SqlPlanRowCountOut   Variables
SqlPlanUpdateRowCountError   Variables
SqlPlanUpdateRowCountIn   Variables
SqlPlanUpdateRowCountOut   Variables
SqlTextRowCountError   Variables
SqlTextRowCountIn   Variables
SqlTextRowCountOut   Variables
SqlTextUpdateRowCountError   Variables
SqlTextUpdateRowCountIn   Variables
SqlTextUpdateRowCountOut   Variables
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

Collapse image See also


Package index