Changelog

Customers would like to be able to Tag their Instances or Hosts

Some example tags that customers might choose to apply are:

• App=Customer Portal
• Environment=Prod
• OS=Amazon Linux 2
• Project=Customer Portal
• Owner=Joe Bloggs
• Cost Center=DigitalOps
• Customer=Cust1
• Cluster=OracleRAC01
• Version=1.0.2

These tags should be informational when displayed on the Instance details screen.

On the instances overview screen, tags could be used as a way of filtering down the list of instances.

Customers would like to monitor their Informix databases in the same way them monitor their other databases with DBmarlin.

A global SQL Search screen was added in v3.7.

https://docs.dbmarlin.com/docs/Using-DBmarlin/sql-search

This can be useful if you have a statement from another source such as your development IDE, a log file or perhaps another monitoring solution and wish to find that statement in DBmarlin wherever it might have run.

Links to other 3rd-party tools were added in DBmarlin v3.7

https://docs.dbmarlin.com/docs/settings/database-instance-settings/#3rd-party-links

Examples you may use this for:

• Link to the DB Console to administer the database (For example AWS RDS Console, Azure SQL Console, CockroachDB Console, pgAdmin etc.)
• Link to a log monitoring tool to see the database logs (For example CloudWatch Log, ELK, Splunk, SumoLogic, Humio etc.)
• Link to a dashboard in another monitoring tool (For example Grafana, Instana, New Relic, Dynatrace, Datadog etc.)
• Link to a ticketing system to see open incidents or alerts (For example ServiceNow, PagerDuty, Remedy etc.)
• Link to the phone or email of the on-call team, DBA or engineer. For this you can use URLs in the form mailto: or tel:

PagerDuty and Slack notifications were added in v3.7

https://docs.dbmarlin.com/docs/Integrations/pagerduty
https://docs.dbmarlin.com/docs/Integrations/slack

Deadlock screen is now available for SQL Server and Oracle in DBmarlin v3.7

https://docs.dbmarlin.com/docs/Using-DBmarlin/instance-dashboard#deadlocks

Similar to the SQL Stats Explorer Report but allows for 2 time ranges to be compared.

Would like to send data to New Relic through a proxy server

A new screen that allows you to see top SQL by any of the SQL statistics like Logical Read, CPU %, Physical Reads, etc both as a table and an overtime chart.

The SQL Metrics screen will show SQL statements and their KPIs such as Execute count, Duration, CPU time, Logical Reads, Physical Reads, Logical Writes etc.

The SQL Metrics screen will show SQL statements and their KPIs such as Execute count, Duration, CPU time etc

Provide a link from a host to the instances running on that host

Allow DBmarlin data to be sent to New Relic so it can be viewed along with other application and infrastructure data.

I need to have DBmarlin alert me when performance goes bad.

Would like to be able to save detailed data at maximum granularity for certain events such as Black Friday or incidents or load tests for example.

Would like more information to help read explain plans such as what the operations mean. E.g Hash join or nested loops.

Would like to be able to group similar statements so that I can see the overall performance of many similar statements which are identical except for the parameters.

Would like to be able to monitor IBM Db2 on Linux, Unix or Windows.

Description of what wait events mean and what can be done to reduce them.