SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

About

Quickly pinpoint performance issues with SolarWinds® Database Performance Analyzer (DPA) while providing expert advice with tuning advisors. Anomaly detection powered by machine learning allows DBAs to proactively optimize databases before small issues become big problems. Real-time analysis with 24/7 monitoring and automated alerts provides the time an error occurred instead of just knowing it was “sometime last week.” DPA helps ease the use of more than 20 cross-platform databases in hybrid, on-premises and cloud environments.

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

dbForge Studio for Oracle is a powerful integrated development environment (IDE) which helps Oracle SQL developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data. This Oracle IDE allows synchronizing data between different Oracle servers and automating schema change management process during development. dbForge Oracle GUI features powerful functionality wrapped into a smooth management Oracle GUI consistent with Microsoft Visual Studio. Key features: * AI Assistant Integration * PL/SQL Coding Assistant * Database Project * Oracle Database Management * Data Generator * Documenter * Object Manager * Oracle PL/SQL Debugger * Query Builder * Query Profiler * Schema Import/Export * Database Administration * Database Designer * Import/Export Data * Report and Analysis * Find Object You can always find the latest version of the product on the official Devart website.

About

dbForge Studio for PostgreSQL is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to your requirements in a convenient and user-friendly interface. The tool provides a data editing tool to customize your queries and property window so that users can view all the required information of PostgreSQL database objects they are interested in. Key features: * AI Assistant Integration. * SQL Development. Save your time and improve code quality when creating and editing queries. * Explorer. Navigate through the object tree and find any PostgreSQL object you want. * Data Editor. Users can manage the settings of tables. * Data Export and Data Import. Supports 10+ widely used data formats, a number of advanced options, and templates for recurring scenarios. * Query Profiler. * Data and Schema Compare. * Data Generator. * Pivot Table.

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, Database Engineers, System Administrators

Audience

database administrators for Microsoft SQL Server

Audience

Mid Size Business, Small Business, Enterprise, Freelance, Nonprofit, Government, and Startup.

Audience

Mid Size Business, Small Business, Enterprise, Freelance, Nonprofit, Government, and Startup.

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

No information available.
Free Version
Free Trial

Pricing

$400 per instance
Free Version
Free Trial

Pricing

$149.95
Free Version
Free Trial

Pricing

$89.95
Free Version
Free Trial

Reviews/Ratings

Overall 4.5 / 5
ease 5.0 / 5
features 4.5 / 5
design 4.5 / 5
support 5.0 / 5

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

SolarWinds
Founded: 2000
United States
www.solarwinds.com

Company Information

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

Company Information

Devart
Founded: 1997
Czech Republic
www.devart.com

Company Information

Devart
Founded: 1997
Czech Republic
www.devart.com/dbforge/postgresql/studio/

Alternatives

Alternatives

DB Optimizer

DB Optimizer

IDERA, an Idera, Inc. company

Alternatives

Alternatives

Foglight

Foglight

Quest Software
Monitorpack Guard

Monitorpack Guard

Monitorpack
SQL Diagnostic Manager for SQL Server

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
DB Optimizer

DB Optimizer

IDERA, an Idera, Inc. company
DB PowerStudio

DB PowerStudio

IDERA, an Idera, Inc. company
SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company
SQL Sentry

SQL Sentry

SolarWinds

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

Application Performance Monitoring (APM) Features

Baseline Manager
Diagnostic Tools
Full Transaction Diagnostics
Performance Control
Resource Management
Root-Cause Diagnosis
Server Performance
Trace Individual Transactions

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

IT Management Features

Capacity Monitoring
Compliance Management
Event Logs
Hardware Inventory
IT Budgeting
License Management
Patch Management
Remote Access
Scheduling
Software Inventory
User Activity Monitoring

RDBMS Features

Backup
Data Migration
Monitoring
Performance Analysis
Queries
Storage Optimization

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

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

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

Integrations

Amazon EC2
Azure Virtual Machines
Collate
Datto Workplace
HCL BigFix AEX
IBM InfoSphere Data Architect
Microsoft Azure
Oracle Database
Pliant
PostgreSQL
SQL Server
SolarWinds Observability SaaS
SolarWinds Observability Self-Hosted
dbForge AI Assistant

Integrations

Amazon EC2
Azure Virtual Machines
Collate
Datto Workplace
HCL BigFix AEX
IBM InfoSphere Data Architect
Microsoft Azure
Oracle Database
Pliant
PostgreSQL
SQL Server
SolarWinds Observability SaaS
SolarWinds Observability Self-Hosted
dbForge AI Assistant

Integrations

Amazon EC2
Azure Virtual Machines
Collate
Datto Workplace
HCL BigFix AEX
IBM InfoSphere Data Architect
Microsoft Azure
Oracle Database
Pliant
PostgreSQL
SQL Server
SolarWinds Observability SaaS
SolarWinds Observability Self-Hosted
dbForge AI Assistant

Integrations

Amazon EC2
Azure Virtual Machines
Collate
Datto Workplace
HCL BigFix AEX
IBM InfoSphere Data Architect
Microsoft Azure
Oracle Database
Pliant
PostgreSQL
SQL Server
SolarWinds Observability SaaS
SolarWinds Observability Self-Hosted
dbForge AI Assistant
Claim SolarWinds Database Performance Analyzer and update features and information
Claim SolarWinds Database Performance Analyzer and update features and information
Claim SQL Query Tuner and update features and information
Claim SQL Query Tuner and update features and information
Claim dbForge Studio for Oracle and update features and information
Claim dbForge Studio for Oracle and update features and information
Claim dbForge Studio for PostgreSQL and update features and information
Claim dbForge Studio for PostgreSQL and update features and information