Package element: SnapshotQueryStatsQuery
Properties
| Name | Value |
| CreationName | |
| DataType | String |
| Description | |
| EvaluateAsExpression | True |
| Expression | "EXEC [msdb].[dbo].[sp_syscollector_snapshot_dm_exec_query_stats] " + (DT_WSTR,10) (@[User::ItemID]) |
| IncludeInDebugDump | False |
| Name | SnapshotQueryStatsQuery |
| Namespace | User |
| QualifiedName | User::SnapshotQueryStatsQuery |
| RaiseChangedEvent | False |
| ReadOnly | False |
| SystemVariable | False |
| Value | EXEC [msdb].[dbo].[sp_syscollector_snapshot_dm_exec_query_stats] 100 |
| VariablePath | \Package.Variables[User::SnapshotQueryStatsQuery] |
See also