This stored procedure reports historical AutoStats tuning events, including applied missing statistic recommendations, where such events are recorded within various telemetry sources including TDStats, the Data Dictionary (DBC), and DBQL tables. Callers can limit the report to a specified time period and/or specified user objects. Use this API to diagnose unexpected performance problems that occur as a result of a past tuning action.
Required SQL Access Rights
- EXECUTE PROCEDURE, SELECT ON TDStats
- SELECT ON DBC.StatsTbl