SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company
SQL Workload Analysis

SQL Workload Analysis

IDERA, an Idera, Inc. company

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

Monitor and diagnose detailed database wait states and application transactions. Problematic SQL queries can severely reduce the performance of SQL Server and the business-critical applications that it supports. With the SQL Workload Analysis add-on, continuously monitor and analyze server workload, leverage the simple user interface that focuses on wait states and application performance, and troubleshoot problematic SQL code from changes made to database applications. Perform real-time analysis with continuous SQL sampling intervals. Know instantly where databases are spending time. Quickly isolate slow SQL statements and drill down for actionable advice. Investigate historical query plan trends. Utilize automatic recommendations to improve query performance.

About

Disk fragmentation is the main cause of slow computers. With an enhanced multi-threading defrag engine and improved defrag speed, Smart Defrag provides a better solution for faster data access and outstanding disk performance. Then you can enjoy faster game launching speed, copy files in half the time, etc. As your computer gets older, it takes longer to start up your computer to begin to work. Smart Defrag helps fix this problem easily. Configuring Boot Time Defrag feature, those files on HDD that cannot be moved while the system is running can be quickly defragmented for faster startup. Nobody wants to experience long game load time. Game Optimizer in Smart Defrag can optimize your game experience quickly with an ultra-fast engine, and all you need to do is select the game you’d like to defrag. Smart Defrag helps speed up PC and data access speed. And now it gets even better with all the new updates available.

About

dbForge Query Builder for SQL Server is a professional tool for designing complex SQL queries in a visual mode using query diagrams and drag-and-drop capabilities. The tool enables SQL developers to quickly and accurately create sophisticated queries without manual code typing, including queries with numerous subqueries. Key Features: - SQL statement builder executes created queries and edits tables data - Accelerate routine tasks with integrated AI Assistant - Construct data manipulation queries without manual coding - Auto Join of columns by primary/foreign key or name - Combine a few queries to a sub-query via visual SQL editor - Sort and filter data based on a custom complex criteria - Reverse engineer queries it into a visual representation - Use visual SQL query builder to profile designed queries dbForge Query Builder for SQL Server significantly reduces the need for manual code ty

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 for Microsoft SQL Server

Audience

database administrators for Microsoft SQL Server

Audience

Any user looking for a fast and deep defrag solution to optimize their hard drive and PC performance

Audience

Database developers and administrators

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

$400 per instance
Free Version
Free Trial

Pricing

$400 per instance
Free Version
Free Trial

Pricing

$19.99 one-time payment
Free Version
Free Trial

Pricing

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

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

Company Information

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

Company Information

IObit
Founded: 2004
www.iobit.com/en/iobitsmartdefrag.php

Company Information

Devart
Founded: 1997
United States of America
www.devart.com

Alternatives

DB Optimizer

DB Optimizer

IDERA, an Idera, Inc. company

Alternatives

SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

Alternatives

Alternatives

IDERA Precise for Databases

IDERA Precise for Databases

IDERA, an Idera, Inc. company
SQL Diagnostic Manager for SQL Server

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
SQL Sentry

SQL Sentry

SolarWinds
FastQueryBuilder

FastQueryBuilder

Fast Reports
DB PowerStudio

DB PowerStudio

IDERA, an Idera, Inc. company
SQL Diagnostic Manager for SQL Server

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
SQL Sentry

SQL Sentry

SolarWinds
SQL Doctor

SQL Doctor

IDERA, an Idera, Inc. company

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

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

Integrations

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

Integrations

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

Integrations

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

Integrations

Amazon EC2
Azure Virtual Machines
Collate
IBM InfoSphere Data Architect
SQL
SQL Server
Claim SQL Query Tuner and update features and information
Claim SQL Query Tuner and update features and information
Claim SQL Workload Analysis and update features and information
Claim SQL Workload Analysis and update features and information
Claim IObit Smart Defrag and update features and information
Claim IObit Smart Defrag and update features and information
Claim dbForge Query Builder for SQL Server and update features and information
Claim dbForge Query Builder for SQL Server and update features and information