Instance Dashboard

The database instance dashboard screen gives a complete performance overview of the database activity and host metrics related to that instance.

https://d33wubrfki0l68.cloudfront.net/a0f6be36e665521948943ff6272a60e2bddeacc6/4919d/img/database-instance-screen.jpg

Database Activity Tab

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 SQL statements within the selected period.
  2. Executions - This is the total number of SQL executions within the selected period.
  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.

Performance over time

Time Spent and Executions over time for the period selected. You can optionally toggle the wait-states on of off with the button in the top right. If any changes have been detected, or manually added, they will be displayed as annotated markers on the timeline.

https://d33wubrfki0l68.cloudfront.net/ede9404243af6898a227493f71eac88ec0520513/68ad4/img/perf-over-time.jpg

SQL & Wait state breakdown

The first ring chart shows the top 10 SQL statements by total DB time. The colours match those in the table below. The second ring chart shows a breakdown of the top 10 wait states.

https://d33wubrfki0l68.cloudfront.net/a4242f0fc0a069451d8eb25315849610ce0b8577/7ea72/img/wait-state-breakdown.jpg

Lower tabs

The lower tabs show the top SQL, Databases, Sessions, Programs, Client, Batches, Users as well as Changes. Note that some columns are not available depending on which database type you are looking at; for example, programs is not available for MySql and batches is only there for SQL Server. Each of these tables may be sorted by clicking in the column headings which have the arrow pairs. After sorting, the highlighted arrow shows the direction of sort.

https://d33wubrfki0l68.cloudfront.net/86060a236035d36d7907f989156ae349517d5da4/16fe6/img/top-sql.jpg

Top SQL

Top SQL statements sorted by total DB time. An inline bar chart is diplayed for any statements whose weighted % is more than 5% and coloured to match the ring chart above. Clicking on the statement id or the statement itself will then take you on to the SQL view for that statement.

Top Databases

Top Databases sorted by total DB time. If you have enabled the Instana integration then a button will be shown here if the matching database is found in Instana.

Top Sessions

Top Sessions sorted by total DB time.

Top Clients

Top Clients sorted by total DB time.

Top Users

Top Users sorted by total DB time.

Changes

Shows a list of changes to the database instance. These include:

  1. DB parameter changes. E.g. innodb_buffer_pool_size increased
  2. Schema changes. E.g. Index added
  3. Custom Events added (see Event Types view )

Host Metrics Tab

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/50d8ff67f6948bd5df8420a5619215695e3f7600/e76d8/img/kpi-widgets-host-metrics.jpg

CPU and Memory over time

These charts show the CPU and memory usage over time for any hosts that are linked to this particular database instance.

https://d33wubrfki0l68.cloudfront.net/e8b4d84a10d341384d564a114a6dc10a1f5ad645/32a9f/img/host-performance-charts.jpg

Monitored hosts table

This table show the host metrics for any hosts that are linked to this particular database instance.

https://d33wubrfki0l68.cloudfront.net/dff3b71c6491c9ae666b32007d634f9826c775a8/36b6c/img/host-performance-table.jpg