SQL View

The SQL view gives a complete performance overview of the selected SQL statement. The chart may be toggled between total time spent, or the individual wait-state breakdown.

https://d33wubrfki0l68.cloudfront.net/afee9da92923bd5a19ea69dfd5503384f83fc3f8/87705/img/sql-view.jpg

KPI Widgets

The key performance indicators at the top of the screen are there to show top level metrics and alerts.

https://d33wubrfki0l68.cloudfront.net/a946b7b48b69ab773852b80b15890509c4658e29/55fa8/img/kpi-widgets.jpg

  1. DB Time - This is the total amount of time spent executing this SQL statement within the selected period.
  2. Executions - This is the total number of executions for the SQL statement within the selected period (not always available depending on the database type)
  3. Change History - This shows 2 values: 1) the total number of changes within your environment such as schema changes or database parameter changes within the time range selected and 2) any custom events you have created for things like code releases or infrastructure changes.

Statement performance over time

This shows the DB time and wait states over time for the SQL statement. You can optionally toggle the wait-states on of off with the button in the top right.

https://d33wubrfki0l68.cloudfront.net/234efb2dfa30ef1371360a095bfacab56a996672/5ac70/img/sql-over-time.jpg

Statement breakdown

  • The chart shows where the SQL was executed from. For example which client, user, program and database the SQL was run against. Note this table is not displayed in Beta release 0.1.
  • The charts shows a breadkown of the SQL statement time by wait state.

https://d33wubrfki0l68.cloudfront.net/8ff7d70ad8afcda568b52dbf977742140b1fa94e/964c7/img/sql-breakdown.jpg

Lower tabs

SQL Text

Shows the formatted SQL text. https://d33wubrfki0l68.cloudfront.net/e27b72fa6292515ebdad7e88830d7c348fe28d75/40adf/img/sql-text.jpg

Explain Plan

If the SQL statement had multiple explain plans within the selected period you will see a dropdown where you can toggle between the different plans and see what changed. Note that the the time range when a plan was used represents the earliest and latest times that plan was used. So if a new plan was used for a short period, before reverting to the original, then the plan time ranges overlap. Explain plans are generated automatically by DBmarlin as a background process. When you have many SQL statements only the top statements will get explained each time it runs. /img/sql-explain.jpg

Changes

Shows any database changes for the database instance where the SQL ran such as DB parameter changes or schema changes.

static/img/sql-changes.jpg