Package element: DFT - Create Interesting Queries Upload Batch
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 |
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 |