|Name:||Cached query statistics|
|Description:||This task returns aggregate performance statistics based on cached query plans in SQL Server.|
|Long description:||This task returns aggregate performance statistics based on cached query plans in SQL Server (the sys.dm_exec_query_stats dynamic management view). The view contains one row per query statement within the cached plan, and the lifetime of the rows are tied to the plan itself. When a plan is removed from the cache, the corresponding rows are eliminated from this view which might produce inaccurate results if there are many plans removed between sampling of statistics by the dbWatch task.|
|Default schedule:||16 2,5,8,11,14,17,20,23 * *|
|Requires engine install:||Yes|
|Compatibility tag:||[CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2000’ & maj_version < ‘2017’ & hasengine=‘YES’ & engine_edition = ‘Microsoft SQL Server’|
Thanks for your feedback.