SQL Insights
The SQL Insights feature is based on SQL-level performance data collected on databases enabled for Ops Insights. This telemetry is collected every 30 minutes and transferred into the Ops Insights warehouse where it is curated, persisted, and made available through data objects.
The main purpose of SQL Insights is to provide application database analysts and developers an important historical archive of detailed SQL performance data, as well as operationally useful insights derived from that data at the SQL statement, database and fleet levels.
Top level use cases for SQL Insights:
- Collect and curate detailed SQL workload performance data from OPSI-enabled databases.
- Analyze this data for meaningful and potentially important insights at the SQL, database, and fleet levels.
- Present interactive dashboards to visualize, verify, and investigate insights.