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.
Ops Insights can provide insights for both Oracle databases, and MySQL databases. If you have both types of databases in your environment, you can select which type to view SQL Insights on by selecting it on the Database Type radio buttons at the lower left corner.
Figure 6-1 Database Types for Ops Insights
The following sections detail the functioning parts of SQL Insights for Oracle databases:
The following section details the functioning parts of SQL Insights for MySQL databases: