Changelog

The previous Liquibase integration described here: https://www.dbmarlin.com/docs/integrations/liquibase/ no longer works since it has a dependency on Liquibase Hub which is now shutdown.

We need an update to the integration to work without Hub

SQL and database tuning using the power of AI.

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.

Support for SAP HANA database

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

This is now available since v3.6.0 https://docs.dbmarlin.com/docs/Release-notes/v3.6.0

Additional granularity added to all charts in the product as of v3.4.0

Fixed in v3.4.0

Added in v3.2.0

Available in v3.5.0

Available from v3.5.0 for Linux and Kubernetes

Available in beta in v3.4.0

Available in Beta in v3.4.0

Tried configuring dbmarlin on a RHEL7.9 box. It took some time to figure out why it did not succeed, but configure passes $LANG down to postgres lc_messages. When LANG is not set, havoc awaits;-). A simple test in configure would avoid that:

<pre>
if (( $EUID == 0 )); then
"Please don't run as root. We recommend you create a dbmarlin user."
exit
fi

• LANG=$(locale | grep "LANG")
• if [ -n ${LANG} ]; then
• echo "Please set LANG, i.e. export LANG=<your choise>";
• exit 1;
• fi

DIR="$(cd "$(dirname "$0")" && pwd)"
</pre>

Would like to be able to monitor WIndows host metrics like CPU, memory and disk I/O via WMI but from a Linux DBmarlin host

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

Support SQL Server database where the master DB is case sensitive and DMVs must use lower case.

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 etc.

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.