This stored procedure reports daily number of logged queries referencing one or more AutoDBA marked objects over a specified period of time. Reported activity is limited to SQL statement types that offer tuning opportunities such as Select, Insert, Update, Delete and Merge Into.
Required SQL Access Rights
- EXECUTE PROCEDURE, SELECT ON TDStats
- SELECT ON the following DBC objects:
- Dbase
- QryLogV
- QryLogXMLV
- DBQLQERTbl
- SELECT ON the following PDCRINFO objects:
- DBQLLogTbl_Hst
- DBQLXMLTbl_Hst
- SELECT ON TD_METRIC_SVC.AutoDbQryLogV