Package element: NotableQueryPlan
Name | Value |
CreationName | |
DataType | String |
Description | |
EvaluateAsExpression | True |
Expression | "SELECT [sql_handle],{LF} [plan_handle],{LF} [statement_start_offset],{LF} [statement_end_offset],{LF} [creation_time]{LF}FROM [snapshots].[fn_get_notable_query_plans](" + (DT_WSTR, 10) @[User::SourceId] + ")" |
IncludeInDebugDump | False |
Name | NotableQueryPlan |
Namespace | User |
QualifiedName | User::NotableQueryPlan |
RaiseChangedEvent | False |
ReadOnly | False |
SystemVariable | False |
Value | SELECT [sql_handle],{LF} [plan_handle],{LF} [statement_start_offset],{LF} [statement_end_offset],{LF} [creation_time]{LF}FROM [snapshots].[fn_get_notable_query_plans](1) |
VariablePath | \Package\SEQ - Capture and analyze query statistics and query plan and text\DFT - Create Interesting Queries Upload Batch.Variables[User::NotableQueryPlan] |