Package element: DFT - Create Interesting Queries Upload Batch

CollapseAll image

Collapse image Properties


 Name   Value 
[DRC - Add SnapshotId column to current snapshot].[Derived Column Output].[snapshot_id].[FriendlyExpression] @[User::SnapshotId]
[DRC - Calculate delta value between last snapshot and current snapshot for every metric].[Derived Column Output].[snapshot_clr_time].[FriendlyExpression] ISNULL(old_total_clr_time) ? total_clr_time : total_clr_time - old_total_clr_time
[DRC - Calculate delta value between last snapshot and current snapshot for every metric].[Derived Column Output].[snapshot_elapsed_time].[FriendlyExpression] ISNULL(old_total_elapsed_time) ? total_elapsed_time : total_elapsed_time - old_total_elapsed_time
[DRC - Calculate delta value between last snapshot and current snapshot for every metric].[Derived Column Output].[snapshot_execution_count].[FriendlyExpression] ISNULL(old_execution_count) ? execution_count : execution_count - old_execution_count
[DRC - Calculate delta value between last snapshot and current snapshot for every metric].[Derived Column Output].[snapshot_logical_reads].[FriendlyExpression] ISNULL(old_total_logical_reads) ? total_logical_reads : total_logical_reads - old_total_logical_reads
[DRC - Calculate delta value between last snapshot and current snapshot for every metric].[Derived Column Output].[snapshot_logical_writes].[FriendlyExpression] ISNULL(old_total_logical_writes) ? total_logical_writes : total_logical_writes - old_total_logical_writes
[DRC - Calculate delta value between last snapshot and current snapshot for every metric].[Derived Column Output].[snapshot_physical_reads].[FriendlyExpression] ISNULL(old_total_physical_reads) ? total_physical_reads : total_physical_reads - old_total_physical_reads
[DRC - Calculate delta value between last snapshot and current snapshot for every metric].[Derived Column Output].[snapshot_worker_time].[FriendlyExpression] ISNULL(old_total_worker_time) ? total_worker_time : total_worker_time - old_total_worker_time
[DRV - Add plan_generation_num column].[Derived Column Output].[creation_time].[FriendlyExpression] GETDATE()
[DRV - Add plan_generation_num column].[Derived Column Output].[plan_generation_num].[FriendlyExpression] (DT_I8)1
[DRV - Add source_id (1)].[Derived Column Output].[source_id].[FriendlyExpression] @[User::SourceId]
[DRV - Add source_id (2)].[Derived Column Output].[source_id].[FriendlyExpression] @[User::SourceId]
[SPLT - Identify interesting running requests].[Interesting Requests].[FriendlyExpression] (wait_duration_ms > @[User::InterestingQueries_LongWaitingRequest]) || (blocking_session_id == 0 && is_blocking == TRUE ) || (open_transaction_count > @[User::InterestingQueries_HighTransactionCount]) || (request_total_elapsed_time > @[User::InterestingQueries_LongRunningRequest]) || (request_cpu_time > @[User::InterestingQueries_HighCpuUsage]) || (pending_io_count > @[User::InterestingQueries_HighIoCount]) || (memory_usage > @[User::InterestingQueries_HighMemoryUsage]) || (session_row_count > @[User::InterestingQueries_LargeResultset])
[SRT - Add statement_start_offset, statement_end_offset and creation_time to the sort order].[MaximumThreads] -1
[SRT - Find unique sql_handle and plan_handle combinations].[MaximumThreads] -1
[SRT - Find unique sql_handle values].[MaximumThreads] -1
[SRT - Sort columns by sql_handle, plan_handle].[MaximumThreads] -1
ApartmentThreaded False
AutoAdjustBufferSize False
AutoGenerateIDForNewObjects True
BLOBTempStoragePath  
BufferTempStoragePath  
CreationName SSIS.Pipeline.5
DebugMode False
DefaultBufferMaxRows 10000
DefaultBufferSize 10485760
DelayValidation False
Description Data Flow Task
Disable False
DisableEventHandlers False
EnableCacheUpdate True
EnableDisconnectedColumns False
EngineThreads 10
ExecutionDuration 0
ExecutionResult Success
ExecutionStatus None
FailPackageOnFailure False
FailParentOnFailure True
ForcedExecutionValue 0
ForceExecutionResult None
ForceExecutionValue False
HasExpressions False
HostType Task
ID {7CC524DD-0334-41D0-8E7C-A6AA943F156C}
IsDefaultLocaleID True
IsolationLevel Serializable
IsSavingXml False
LocaleID English (United States)
LoggingMode UseParentSetting
MaximumErrorCount 0
Name DFT - Create Interesting Queries Upload Batch
RunInOptimizedMode True
SuspendRequired False
TransactionOption Supported

Collapse image Elements


 Name   Description   Type 
DRC - Add SnapshotId column to current snapshot Updates column values using expressions ComponentMetaDataCollection
DRC - Calculate delta value between last snapshot and current snapshot for every metric Updates column values using expressions ComponentMetaDataCollection
DRV - Add plan_generation_num column Updates column values using expressions ComponentMetaDataCollection
DRV - Add source_id (1) Updates column values using expressions ComponentMetaDataCollection
DRV - Add source_id (2) Updates column values using expressions ComponentMetaDataCollection
MLTCST - split current snapshot Creates copies of a dataset. ComponentMetaDataCollection
MLTCST - Split interesting queries Creates copies of a dataset. ComponentMetaDataCollection
MLTCST - split last snapshot Creates copies of a dataset. ComponentMetaDataCollection
MLTCST - Split to upload sql_handle and plan_handle Creates copies of a dataset. ComponentMetaDataCollection
MRG - Append current stats on interesting queries Merges data from two datasets by using a join. ComponentMetaDataCollection
MRG - Append last stats on interesting queries Merges data from two datasets by using a join. ComponentMetaDataCollection
ODD - Save statistics for interesting queries OLE DB Destination ComponentMetaDataCollection
ODD - Upload interesting plan handles OLE DB Destination ComponentMetaDataCollection
ODD - Upload interesting sql handles OLE DB Destination ComponentMetaDataCollection
ODS - Get current snapshot of dm_exec_query_stats OLE DB Source ComponentMetaDataCollection
RC - Number of interesting plan handles Counts the rows in a dataset. ComponentMetaDataCollection
RC - Number of interesting sql handles Counts the rows in a dataset. ComponentMetaDataCollection
RC - Number of not inserted plan handles Counts the rows in a dataset. ComponentMetaDataCollection
RC - Number of not inserted sql handles Counts the rows in a dataset. ComponentMetaDataCollection
RC - Row count after TopN queries Counts the rows in a dataset. ComponentMetaDataCollection
RC - Row count from dm_exec_query_stats Counts the rows in a dataset. ComponentMetaDataCollection
RFD - Save current snapshot in temp file Loads raw data into a file. ComponentMetaDataCollection
RFS - Read current cache with dm_exec_requests Extracts data from a raw file. ComponentMetaDataCollection
RFS - Read last snapshot of dm_exec_query_stats Extracts data from a raw file. ComponentMetaDataCollection
SPLT - Identify interesting running requests Evaluates and directs rows in a dataset. ComponentMetaDataCollection
SRT - Add statement_start_offset, statement_end_offset and creation_time to the sort order Sorts data. ComponentMetaDataCollection
SRT - Find unique sql_handle and plan_handle combinations Sorts data. ComponentMetaDataCollection
SRT - Find unique sql_handle values Sorts data. ComponentMetaDataCollection
SRT - Sort columns by sql_handle, plan_handle Sorts data. ComponentMetaDataCollection
TPQ - Analyze Interesting Queries   ComponentMetaDataCollection
UNION - Combine interesting requests and interesting stats Merges multiple datasets. ComponentMetaDataCollection
UNION - Combine last and current snapshots for TopN processing Merges multiple datasets. ComponentMetaDataCollection
BufferSizeTuning The Data Flow changed the size of a buffer away from the default values. The event text includes the sizes and the reasons. LogEntryInfos
PipelineBufferLeak After execution, some buffers were left outstanding. Some transform is hanging onto buffer references and if it freed them we would use a lot less memory. The logged text includes information about the transform that owned the buffer, and the ID of the buffer. LogEntryInfos
PipelineComponentTime Information about each phase of validation and execution for each data flow component. The processing time of each phase is specified. LogEntryInfos
PipelineExecutionPlan The execution plan of the data flow. LogEntryInfos
PipelineExecutionTrees The input the scheduler had when forming the execution plan. LogEntryInfos
PipelineInitialization Various information from Data Flow initialization. LogEntryInfos
Calculate TopN stats   PathCollection
Calculate TopN stats   PathCollection
Derived Column Output   PathCollection
Derived Column Output   PathCollection
Derived Column Output   PathCollection
Derived Column Output   PathCollection
Derived Column Output   PathCollection
Interesting Requests   PathCollection
Merge Join Output   PathCollection
Merge Join Output   PathCollection
Multicast Output 2   PathCollection
Multicast Output 3   PathCollection
Multicast Output 4   PathCollection
OLE DB Destination Error Output   PathCollection
OLE DB Destination Error Output   PathCollection
OLE DB Source Output   PathCollection
Process TopN   PathCollection
Process TopN   PathCollection
Raw File Source Output   PathCollection
Raw File Source Output   PathCollection
Row Count Output 1   PathCollection
Row Count Output 1   PathCollection
Row Count Output 1   PathCollection
Row Count Output 1   PathCollection
Save   PathCollection
Save   PathCollection
Sort Output   PathCollection
Sort Output   PathCollection
Sort Output   PathCollection
Sort Output   PathCollection
TxTopQueries Only Output   PathCollection
Union All Output 1   PathCollection
Union All Output 1   PathCollection
NotableQueryPlan   Variables
NotableQueryText   Variables
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
SSIS diagram is missing

Collapse image See also


Package index