Package element: DFT - Find and save plan text
Name | Value |
[LKUP - Look up query plans on target server].[SqlCommand] | [dbo].[sp_syscollector_text_query_plan_lookpup] ?,?,? |
[LKUP - Look up query plans on target server].[SqlCommandParam] | [dbo].[sp_syscollector_text_query_plan_lookpup] ?,?,? |
[ODC - Save known plans to warehouse].[SqlCommand] | EXEC snapshots.sp_update_query_plan ?,?,?,?,?,?,?,?,?,? |
ApartmentThreaded | False |
AutoAdjustBufferSize | False |
AutoGenerateIDForNewObjects | True |
BLOBTempStoragePath | |
BufferTempStoragePath | |
CreationName | SSIS.Pipeline.5 |
DebugMode | False |
DefaultBufferMaxRows | 10000 |
DefaultBufferSize | 10485760 |
DelayValidation | True |
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 | {06401E14-2D8B-4F21-AEF7-BDBD02C9C408} |
IsDefaultLocaleID | True |
IsolationLevel | Serializable |
IsSavingXml | False |
LocaleID | English (United States) |
LoggingMode | UseParentSetting |
MaximumErrorCount | 0 |
Name | DFT - Find and save plan text |
RunInOptimizedMode | True |
SuspendRequired | False |
TransactionOption | Supported |
Name | Description | Type |
LKUP - Look up query plans on target server | Looks up values in a reference dataset by using exact matching. | ComponentMetaDataCollection |
ODC - Save known plans to warehouse | Executes an SQL command for each row in a dataset. | ComponentMetaDataCollection |
ODS - Get all plan handles without saved plan | OLE DB Source | ComponentMetaDataCollection |
RC - Identified query plans count | Counts the rows in a dataset. | ComponentMetaDataCollection |
RC - Unidentified query plans count | Counts the rows in a dataset. | ComponentMetaDataCollection |
RC - Unknown query plans count | Counts the rows in a dataset. | 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 |
Lookup Match Output | PathCollection | |
Lookup No Match Output | PathCollection | |
OLE DB Source Output | PathCollection | |
Row Count Output 1 | PathCollection | |
Row Count Output 1 | PathCollection | |
SourceSqlQuery | 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 |