Package element: DFT - Find and save plan text
Properties
| 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 |
Elements
| 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 |
See also