SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

About

MySQLTuner is a lightweight, Perl-based script designed to assist database administrators in optimizing the performance and configuration of MySQL and MariaDB databases. It analyzes key metrics and parameters related to system performance, security, and resource usage, providing actionable recommendations for improvement. By examining the current workload, cache efficiency, query performance, and memory usage, MySQLTuner identifies potential bottlenecks and suggests adjustments to configuration files. It is particularly valuable for ongoing maintenance, as it highlights issues such as inefficient indexes, excessive temporary tables, or suboptimal query caching. MySQLTuner is widely used by database administrators to ensure optimal performance, reduce system overhead, and maintain a healthy, efficient database environment.

About

SQL Query Tuner helps database administrators to tune and profile SQL code for SQL Server. Unlike its competition, it provides automated SQL tuning and performance optimization suggestions with color-coded index analysis, database profiling of wait-time analysis for a single stored routine or an entire data source, SQL stress load testing to simulate a production environment with parallel users and executions over a specific period of time or execution cycle, and review of SQL execution and performance costs using explain plans.

About

ThinkSQL is a powerful, cross-platform relational database management system designed for modern operating systems and hardware. It aims to comply fully with the ISO SQL standard to provide an open and flexible SQL server for your applications. Compliance with the SQL standard means it supports transactions, sub-selects, views, set operators (union, except, intersect), access privileges and comprehensive referential constraints to ensure the integrity of your data. ThinkSQL uses a multi-versioning engine to provide consistent views of data and concurrent access to rows without locking. The server also has stored procedures and functions (using the standard syntax), and has support for large multimedia objects. It's easy to install, runs on Windows ® and Linux ®, and has native ODBC, JDBC™, dbExpress™ and Python drivers so your applications can connect directly from any platform.

About

Webair provides Database-as-a-Service (DBaaS), a reliable and secure database management solution that gives your business simple, efficient and always available access to its mission-critical data. Our team has proven experience in managing the implementation, configuration, administration and optimization of database clusters, including business-critical, load-balanced and replicated MySQL clusters, including MariaDB, Galera and NoSQL. Webair’s Database Administrators are experts in helping you create a high-performance database environment. We work with you to design the best solution, matching the finest infrastructure to the right database configuration to meet your unique requirements. Free your business from routine database tasks such as performance monitoring, configuration, memory, storage and log file management, sizing, service pack upgrades and service patches. Focus on more important business aspects, including managing the critical data within your database.

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Audience

Database administrators

Audience

database administrators for Microsoft SQL Server

Audience

Companies searching for a solution to manage and improve their database operations

Audience

Database Management solution for businesses

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Screenshots and Videos

Screenshots and Videos

Pricing

Free
Free Version
Free Trial

Pricing

$400 per instance
Free Version
Free Trial

Pricing

No information available.
Free Version
Free Trial

Pricing

No information available.
Free Version
Free Trial

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Company Information

MySQLTuner
github.com/major/MySQLTuner-perl

Company Information

IDERA, an Idera, Inc. company
Founded: 2004
United States of America
www.idera.com/productssolutions/sqlserver/sql-query-tuner

Company Information

ThinkSQL
United Kingdom
www.thinksql.co.uk

Company Information

Webair
Founded: 1996
United States
www.webair.com/database-management/

Alternatives

Alternatives

DB Optimizer

DB Optimizer

IDERA, an Idera, Inc. company

Alternatives

Alternatives

CA Datacom

CA Datacom

Broadcom
SQL Diagnostic Manager for SQL Server

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
Tibero

Tibero

TmaxSoft
DB PowerStudio

DB PowerStudio

IDERA, an Idera, Inc. company
SQL Sentry

SQL Sentry

SolarWinds
Huawei RDS

Huawei RDS

Huawei Cloud
ClusterControl

ClusterControl

Severalnines

Categories

Categories

Categories

Categories

Database Features

Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization

Database Monitoring Features

Anomaly Detection
Autodiscovery
Capacity Planning
Dashboard
Dependency Tracking
Historical Trend Analysis
Multitenancy
Notifications / Alerts
Performance Monitoring
Permissions / Access Controls
Predictive Analytics
Prioritization
Query Analysis
Resource Optimization
Troubleshooting

SQL Server Features

CPU Monitoring
Credential Management
Database Servers
Deployment Testing
Docker Compatible Containers
Event Logs
History Tracking
Patch Management
Scheduling
Supports Database Clones
User Activity Monitoring
Virtual Machine Monitoring

RDBMS Features

Backup
Data Migration
Monitoring
Performance Analysis
Queries
Storage Optimization

Integrations

Amazon EC2
Azure Virtual Machines
Collate
IBM InfoSphere Data Architect
MariaDB
MySQL
Perl
SQL
SQL Server

Integrations

Amazon EC2
Azure Virtual Machines
Collate
IBM InfoSphere Data Architect
MariaDB
MySQL
Perl
SQL
SQL Server

Integrations

Amazon EC2
Azure Virtual Machines
Collate
IBM InfoSphere Data Architect
MariaDB
MySQL
Perl
SQL
SQL Server

Integrations

Amazon EC2
Azure Virtual Machines
Collate
IBM InfoSphere Data Architect
MariaDB
MySQL
Perl
SQL
SQL Server
Claim MySQLTuner and update features and information
Claim MySQLTuner and update features and information
Claim SQL Query Tuner and update features and information
Claim SQL Query Tuner and update features and information
Claim ThinkSQL and update features and information
Claim ThinkSQL and update features and information
Claim Webair and update features and information
Claim Webair and update features and information