SQL Diagnostic Manager

Find and fix database performance problems with efficient
monitoring, alerting, and diagnostics for SQL Server and MySQL

for SQL Server START FOR FREE
for MySQL

START FOR FREE
  •  
  • Monitor in real-time for corrective action and issues resolution
  • Track and compare all changes to MySQL or MariaDB configuration files
  • Monitor, alert, and kill locked or long-running SQL queries in real-time
  • Monitor Amazon RDS, MariaDB, or Amazon Aurora including OS and log files
  • Find top 10 queries across MySQL/MariaDB servers based on execution time
  •  
Disk and Lock Monitoring

Monitor disk space and locks

Analyze disk space usage by displaying the number of databases
with their data and index sizes to see which MySQL and MariaDB
servers take up the most space. View snapshots and charts of
disk space occupied by databases on servers and tables in
databases to quickly spot the largest databases and tables.

Security Monitoring

Check security issues

Easily understand the complete security, availability, health,
and performance of all MySQL and MariaDB servers in a single,
modern, and intuitive web console. Access hundreds of monitors
that examine the configuration and security of servers automatically.
Identify and alert on security vulnerabilities and tuning opportunities
via expert advice.

Provide Access to Multiple Users

Manage access
to multiple users

Set up users who have limited access to specified servers and
settings. Specify the type of user, role, and allowed and disallowed
actions, tags, and tabs. Manage user access to prevent accidental
actions, executing non-reversible operations, and changing server
settings without administrator knowledge.

Flexible Dashboard with Overview

Quickly see an overview and then drill down for details

Display the top level overview of all registered MySQL and
MariaDB servers. View the total number of registered servers,
the total number of disconnected servers, servers with critical alerts,
and servers with warnings. From the overview, drill down to more
detailed information to find the root cause of problems.

 
PERFORMANCE MONITORING

Monitor in real-time

Get started with real-time monitoring in a single mouse click and avoid enabling logging manually. See what MySQL and MariaDB servers are up to anytime.

Deploy agentless

Avoid installing monitoring agents on monitored servers as the architecture of the monitoring solution is agentless.

Monitor queries

Monitor slow, top slowest, and long-locked SQL queries in real-time. View details of SQL queries to investigate the cause of problems.

Detect security problems

Detect MySQL and MariaDB hacking attempts. Also, identify and fix security vulnerabilities.

Monitor replication

Monitor replication including multiple sources. Register slaves automatically. Receive alerts when replications lag or when slaves stopped.

Monitor cloud databases

Monitor managed cloud databases including Amazon RDS for MySQL/MariaDB/Aurora, Microsoft Azure Database for MySQL, Google Cloud SQL for MySQL, and Oracle MySQL Cloud Service.

Store pseudo server logs

Fetch SQL queries from MySQL and MariaDB servers using three methods.

Browse history

Record monitoring sessions by storing all historical data in the embedded repository. Later play back server activity to investigate any problems that occurred in the past.

ALERTING

Detect problems proactively

Keep a check on servers in real-time by providing timely alerts when something goes wrong.

Alert based on best practices

Choose from over 600 predefined monitors and advisors based on industry best practices. Modify configuration settings for greater flexibility.

Set metric thresholds

Set thresholds for each metric via JavaScript to identify warning and critical alerts for different database environments.

Notify effectively

Display alerts on Slack and PagerDuty. Integrate with Syslog. Receive alerts via email and Simple Network Management Protocol traps. Manage, accept, and dismiss events.

Alert on security issues

Alert on hacking attempts and security risks via dedicated metrics to notify relevant staff immediately.

Alert on locks and deadlocks

Detect locks, blocks, and deadlocks by monitoring the relevant metrics as compared to their thresholds.

Alert on disk problems

Observe metrics exceeding thresholds to detect issues with disk space and disk availability.

DIAGNOSTICS AND ANALYTICS

View flexible dashboard

Display unified views of all monitored servers in a single location. Create multiple dashboards and customized sets of charts.

Display parameters and metrics

Display any available settings and metrics for MySQL and MariaDB. Display cumulative and average values for data.

Analyze threads

Display the number of threads currently being executed by MySQL and MariaDB. View the process list with information on running SQL queries as per execution time.

Find and analyze problematic queries

Find problematic SQL queries via three different methods. Monitor custom SQL queries for application-specific monitoring.

Find top queries across servers

Uncover the top problematic SQL queries across multiple servers based on the total execution time.

View parsed audit logs

Display the parsed audit log in a tabular format. Access the audit log file like the slow query log, the general query log, and the error log.

View replication topology

View the replication hierarchy of servers along with details of each replicated server. Switch from graphical to tabular to deep dive into the running servers.

Optimize servers

Monitor deadlocks, disk usage, and error logs. Analyze historical data and trends. Use advisors to improve servers. Tune and optimize performance quickly.

ENTERPRISE MANAGEMENT

Manage multiple users

Specify different access permissions for different users. Integrate the Lightweight Directory Access Protocol for Microsoft Active Directory and OpenLDAP.

Support different operating systems

Run SQL Diagnostic Manager on Microsoft Windows and Linux. Monitor MySQL and MariaDB in the cloud including database-as-a-service.

Deploy with flexible licensing

Acquire the monitoring application with perpetual licensing. Do not be restricted by the number of installations locally and remotely by the licensing.

Set up quickly

Configure SQL Diagnostic Manager easily with a single mouse click. Fetch the file paths of the SQL query logs automatically to start retrieving the contents of the log files.

Customize dashboards and charts

Customize charts and dashboards as per specific requirements for different environments.

Integrate with other systems

Integrate SQL Diagnostic Manager with other software (such as command shells, scripts, and applications) via the application programming interface.

Compare and track configurations

Compare configurations of multiple servers side-by-side with all changes highlighted. Track changes to server configuration files.

Deploy for hybrid cloud

Deploy SQL Diagnostic Manager to monitor on-premise databases, databases on cloud virtual machines, and managed cloud databases.

“For our e-commerce solution that receives hundreds of thousands of page hits per day, quickly fixing deadlock issues made the application run smoothly without any errors. Therefore this led to customer satisfaction – and that is important.”
Stefan Schiele, CEO, SCT Schiele (Small Business, Computer Software, Germany)
  •  
  •  
  •  
  •  

Resources

SQL Diagnostic Manager for MySQL Datasheet

Everything you need to know, all in one downloadable PDF

DOWNLOAD DATASHEET

Moodlerooms Optimizes & Tracks Mission-critical Data

See how Moodlerooms stores queries over time and views execution info

DOWNLOAD CASE STUDY

Overview of SQL Diagnostic Manager for MySQL

Learn about the important features of SQL Diagnostic Manager for MySQL

DOWNLOAD SOLUTION BRIEF

Why Use SQL Diagnostic Manager for MySQL?

See how SQL Diagnostic Manager for MySQL proactively identifies issues affecting database performance

WATCH VIDEO

Top Metrics to Monitor in Your MySQL Databases

Join IDERA and Shree Nair as he demonstrates SQL Diagnostic Manager for MySQL key features

VIEW WEBCAST

Compare MySQL
Monitoring Tools

See key features and functionalities of the top MySQL monitoring tools the market has to offer

COMPARE NOW

Platform Support

Version History
  • Operating Systems: Microsoft Windows and Linux
  • Monitored Database Instances: Oracle MySQL Enterprise Server, MySQL Community Server, MariaDB, Percona Server for MySQL, Galera Cluster for MySQL, MariaDB Galera Cluster, Amazon RDS for MySQL / MariaDB / Amazon Aurora, Microsoft Azure Database for MySQL, Google Cloud SQL for MySQL, Oracle MySQL Cloud Service.
  • Cloud: SQL Diagnostic Manager runs on cloud virtual machines (such as Microsoft Azure VM and Amazon EC2) with Microsoft Windows and Linux. It monitors database instances on cloud virtual machines (such as Microsoft Azure VM and Amazon EC2). It monitors managed cloud databases (that is, Amazon RDS, Microsoft Azure Database, Google Cloud SQL, and Oracle Cloud Service).
more details

Let's get started.

Start your 14-day trial, no credit card required (but all fields are)

*
*
*
*
*

Purchase Now

Includes first year of maintenance.
Volume discounts available.

Buy Now request a quote

Product Demo

See SQL Diagnostic Manager for
MySQL in action with a seasoned pro.

Request a Demo

SQL Diagnostic Manager for MySQL Version History

Version 8.7

  • New name and branding
  • Bug fixes