Audience
database administrators for Microsoft SQL Server
About SQL Query Tuner
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.
Other Popular Alternatives & Related Software
Dynatrace
The Dynatrace software intelligence platform. Transform faster with unparalleled observability, automation, and intelligence in one platform. Leave the bag of tools behind, with one platform to automate your dynamic multicloud and align multiple teams. Spark collaboration between biz, dev, and ops with the broadest set of purpose-built use cases in one place. Harness and unify even the most complex dynamic multiclouds, with out-of-the box support for all major cloud platforms and technologies. Get a broader view of your environment. One that includes metrics, logs, and traces, as well as a full topological model with distributed tracing, code-level detail, entity relationships, and even user experience and behavioral data – all in context. Weave Dynatrace’s open API into your existing ecosystem to drive automation in everything from development and releases to cloud ops and business processes.
Learn more about Dynatrace
Paessler PRTG
Paessler PRTG is an all-inclusive monitoring software solution developed by Paessler. Equipped with an easy-to-use, intuitive interface with a cutting-edge monitoring engine, PRTG optimizes connections and workloads as well as reduces operational costs by avoiding outages while saving time and controlling service level agreements (SLAs). The solution is packed with specialized monitoring features that include flexible alerting, cluster failover solution, distributed monitoring, in-depth reporting, maps and dashboards, and more.
PRTG monitors your entire IT infrastructure. All important technologies are supported:
• SNMP: ready-to-use and custom options
• WMI and Windows Performance Counters
• SSH: for Linux/Unix and macOS systems
• Traffic analysis using flow protocols or packet sniffing
• HTTP requests
• REST APIs returning XML or JSON
• Ping, SQL, and many more
Learn more about Paessler PRTG
SolarWinds Database Performance Analyzer
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.
Learn more about SolarWinds Database Performance Analyzer
IBM Instana
IBM Instana is the gold standard of incident prevention with automated full-stack visibility, 1-second granularity and 3 seconds to notify.
With today’s highly dynamic and complex cloud environments, the average cost of an hour of downtime can reach six figures and beyond. Traditional application performance monitoring (APM) tools simply aren’t fast enough to keep up or thorough enough to contextualize the issues identified. Also, they are typically limited to super users who must complete months of training to learn.
IBM Instana Observability goes beyond traditional APM solutions by democratizing observability so anyone across DevOps, SRE, platform engineering, ITOps and development can get the data they want with the context they need.
Instana Dynamic APM operates using the Instana agent architecture, which incorporates sensors—lightweight, automated programs tailored to monitor specific entities.
Learn more about IBM Instana
Pricing
Starting Price:
$400 per instance
Pricing Details:
USD 400 per instance with first maintenance included; add-on to SQL Diagnostic Manager for SQL Server, together with SQL Workload Analysis
Free Trial:
Free Trial available.
Integrations
Company Information
IDERA, an Idera, Inc. company
Founded: 2004
United States of America
www.idera.com/productssolutions/sqlserver/sql-query-tuner
Videos and Screen Captures
Other Useful Business Software
$300 Free Credits to Build on Google Cloud
Put your $300 in credit toward real workloads, then keep building with free monthly usage for 20+ products. No commitment and no charge until you upgrade.
Product Details
Platforms Supported
Windows
Training
Documentation
Webinars
Support
Phone Support
Online
SQL Query Tuner Frequently Asked Questions
Q: What kinds of users and organization types does SQL Query Tuner work with?
SQL Query Tuner works with these users and organization types: Mid Size Business, Small Business, Enterprise, Freelance, Nonprofit, Government, and Startup.
Q: What languages does SQL Query Tuner support in their product?
SQL Query Tuner supports these languages: English.
Q: What kind of support options does SQL Query Tuner offer?
SQL Query Tuner offers support via phone support and online.
Q: What other applications or services does SQL Query Tuner integrate with?
SQL Query Tuner integrates with: Amazon EC2, Azure Virtual Machines, Collate, IBM InfoSphere Data Architect, and SQL Server.
Q: What type of training does SQL Query Tuner provide?
SQL Query Tuner provides training in the form of documentation and webinars.
Q: Does SQL Query Tuner offer a free trial?
Yes, SQL Query Tuner offers a free trial.
Q: How much does SQL Query Tuner cost?
Pricing for SQL Query Tuner starts at $400 per instance.
Q: What pricing for support is available for SQL Query Tuner?
SQL Query Tuner offers support included with purchase and additional fee / premium available.
Q: What pricing for training is available for SQL Query Tuner?
SQL Query Tuner offers training included with purchase.
SQL Query Tuner Product Features
Database
Monitoring
Supported
Performance Analysis
Supported
Queries
Supported
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
NOSQL
Not Supported
Relational Interface
Not Supported
Virtualization
Not Supported
Database Monitoring
Anomaly Detection
Supported
Dashboard
Supported
Historical Trend Analysis
Supported
Performance Monitoring
Supported
Predictive Analytics
Supported
Query Analysis
Supported
Autodiscovery
Not Supported
Capacity Planning
Not Supported
Dependency Tracking
Not Supported
Multitenancy
Not Supported
Notifications / Alerts
Not Supported
Permissions / Access Controls
Not Supported
Prioritization
Not Supported
Resource Optimization
Not Supported
Troubleshooting
Not Supported
SQL Server
CPU Monitoring
Supported
Deployment Testing
Supported
History Tracking
Supported
Credential Management
Not Supported
Database Servers
Not Supported
Docker Compatible Containers
Not Supported
Event Logs
Not Supported
Patch Management
Not Supported
Scheduling
Not Supported
Supports Database Clones
Not Supported
User Activity Monitoring
Not Supported
Virtual Machine Monitoring
Not Supported
