The following example reports tuning activity for the past 3 days.
CALL TDStats.DAILYTUNINGACTIVITY('{"BeginDate":"CURRENT_DATE - 2","EndDate":"CURRENT_DATE"}');
Result:
| ReportDate | DatabaseName | IdentifiedMissingStats | IdentifiedStaleStats | IdentifiedUnusedStats | StatsCollected | ThresholdSkipped | StatsDropped |
|---|---|---|---|---|---|---|---|
| 2024/20/04 | TPCS | 113 | 0 | 0 | 110 | 0 | 0 |
| 2024/20/04 | TPCH | 68 | 0 | 0 | 71 | 0 | 0 |
| 2024/20/05 | TPCD | 53 | 8 | 0 | 52 | 8 | 0 |
| 2024/20/05 | TPCH | 35 | 12 | 0 | 36 | 12 | 0 |
| 2024/20/06 | TPCD | 5 | 25 | 1 | 5 | 2 | 1 |
| 2024/20/06 | TCPH | 2 | 34 | 0 | 2 | 4 | 0 |