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
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
ScaleGrid
ScaleGrid is a fully managed Database-as-a-Service (DBaaS) platform that helps you automate your time-consuming database administration tasks both in the cloud and on-premises. Easily provision, monitor, backup and scale your open source databases with high availability, advanced security, full superuser and SSH access, query analysis, and troubleshooting support to improve the performance of your deployments. Supported databases include:
- MySQL
- PostgreSQL
- Redis™
- MongoDB® database
- Greenplum™ (coming soon)
The ScaleGrid platform supports both public and private clouds, including AWS, Azure, Google Cloud Platform (GCP), DigitalOcean, Linode, Oracle Cloud Infrastructure (OCI), VMware and OpenStack. Used by thousands of developers, startups, and enterprise customers including Atlassian, Meteor, and Accenture, ScaleGrid handles all your database operations at any scale so you can focus on your application performance.
Learn more
DB Optimizer
DB Optimizer helps database administrators to tune and profile SQL code across database platforms. 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.
Learn more
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
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
Other Useful Business Software
Simplify IT and security with a single endpoint management platform
NinjaOne automates the hardest parts of IT, delivering visibility, security, and control over all endpoints for more than 20,000 customers.
The NinjaOne automated endpoint management platform is proven to increase productivity, reduce security risk, and lower costs for IT teams and managed service providers. The company seamlessly integrates with a wide range of IT and security technologies. NinjaOne is obsessed with customer success and provides free and unlimited onboarding, training, and support.
Product Details
Platforms Supported
Windows
Training
Documentation
Webinars
Support
Phone Support
Online
SQL Query Tuner Frequently Asked Questions
SQL Query Tuner Product Features
Database
Monitoring
Performance Analysis
Queries
Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
NOSQL
Relational Interface
Virtualization
Database Monitoring
Anomaly Detection
Dashboard
Historical Trend Analysis
Performance Monitoring
Predictive Analytics
Query Analysis
Autodiscovery
Capacity Planning
Dependency Tracking
Multitenancy
Notifications / Alerts
Permissions / Access Controls
Prioritization
Resource Optimization
Troubleshooting
SQL Server
CPU Monitoring
Deployment Testing
History Tracking
Credential Management
Database Servers
Docker Compatible Containers
Event Logs
Patch Management
Scheduling
Supports Database Clones
User Activity Monitoring
Virtual Machine Monitoring