SQL Query TunerIDERA, an Idera, Inc. company
|
||||||
Related Products
|
||||||
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
Deliver consistent database performance and availability through intelligent tuning advisors and continuous database profiling. Drill down into detailed per-query statistics and benefit from insights into your query performance history to detect slow queries. Automatically collect your plans and get detailed insights based on query plans gathered from your database. Understand why a query is slow and get tuning recommendations on how to make the query faster. Identify slowdowns for specific queries over time, I/O vs CPU time spent, and buffer cache hit ratio for each query. Automatically detects missing indexes and recommends single and multi-column indexes that improve query performance across your databases. Provides per-table recommendations for auto vacuum settings to optimize table bloat, freezing, VACUUM performance, and more. Discover effective config settings tailored to your database workload that enable you to achieve consistent Postgres performance and availability.
|
|||||
Platforms Supported
Windows
Supported
Mac
Not Supported
Linux
Not Supported
Cloud
Not Supported
On-Premises
Not Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
Platforms Supported
Windows
Not Supported
Mac
Not Supported
Linux
Not Supported
Cloud
Supported
On-Premises
Not Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
|||||
Audience
database administrators for Microsoft SQL Server
|
Audience
Enterprises in search of a solution to manage and monitor their production databases
|
|||||
Support
Phone Support
Supported
24/7 Live Support
Not Supported
Online
Supported
|
Support
Phone Support
Not Supported
24/7 Live Support
Not Supported
Online
Supported
|
|||||
API
Offers API
Not Supported
|
API
Offers API
Not Supported
|
|||||
Screenshots and Videos |
Screenshots and Videos |
|||||
Pricing
$400 per instance
USD 400 per instance with first maintenance included; add-on to SQL Diagnostic Manager for SQL Server, together with SQL Workload Analysis
Free Version
Not Supported
Free Trial
Supported
|
Pricing
$149 per month
Free Version
Not Supported
Free Trial
Supported
|
|||||
Reviews/
|
Reviews/
|
|||||
Training
Documentation
Supported
Webinars
Supported
Live Online
Not Supported
In Person
Not Supported
|
Training
Documentation
Supported
Webinars
Not Supported
Live Online
Supported
In Person
Not Supported
|
|||||
Company InformationIDERA, an Idera, Inc. company
Founded: 2004
United States of America
www.idera.com/productssolutions/sqlserver/sql-query-tuner
|
Company Informationpganalyze
Founded: 2012
United States
pganalyze.com
|
|||||
Alternatives |
Alternatives |
|||||
|
|
||||||
|
|
|
|||||
|
|
||||||
|
|
||||||
Categories |
Categories |
|||||
Database Monitoring Features
Anomaly Detection
Supported
Autodiscovery
Not Supported
Capacity Planning
Not Supported
Dashboard
Supported
Dependency Tracking
Not Supported
Historical Trend Analysis
Supported
Multitenancy
Not Supported
Notifications / Alerts
Not Supported
Performance Monitoring
Supported
Permissions / Access Controls
Not Supported
Predictive Analytics
Supported
Prioritization
Not Supported
Query Analysis
Supported
Resource Optimization
Not Supported
Troubleshooting
Not Supported
Database Features
Backup and Recovery
Not Supported
Creation / Development
Not Supported
Data Migration
Not Supported
Data Replication
Not Supported
Data Search
Not Supported
Data Security
Not Supported
Database Conversion
Not Supported
Mobile Access
Not Supported
Monitoring
Supported
NOSQL
Not Supported
Performance Analysis
Supported
Queries
Supported
Relational Interface
Not Supported
Virtualization
Not Supported
SQL Server Features
CPU Monitoring
Supported
Credential Management
Not Supported
Database Servers
Not Supported
Deployment Testing
Supported
Docker Compatible Containers
Not Supported
Event Logs
Not Supported
History Tracking
Supported
Patch Management
Not Supported
Scheduling
Not Supported
Supports Database Clones
Not Supported
User Activity Monitoring
Not Supported
Virtual Machine Monitoring
Not Supported
|
||||||
Integrations
AccessOwl
Not Supported
Active Directory
Not Supported
Amazon EC2
Supported
Amazon Web Services (AWS)
Not Supported
Azure Virtual Machines
Supported
Collate
Supported
Docker
Not Supported
Google Apps Script
Not Supported
Google Cloud Platform
Not Supported
IBM InfoSphere Data Architect
Supported
|
Integrations
AccessOwl
Supported
Active Directory
Supported
Amazon EC2
Not Supported
Amazon Web Services (AWS)
Supported
Azure Virtual Machines
Not Supported
Collate
Not Supported
Docker
Supported
Google Apps Script
Supported
Google Cloud Platform
Supported
IBM InfoSphere Data Architect
Not Supported
|
|||||
|
|
|