SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company
Windocks

Windocks

LangGrant
+
+

Related Products

  • AdRem NetCrunch
    165 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • Google Cloud SQL
    554 Ratings
    Visit Website
  • DbVisualizer
    585 Ratings
    Visit Website
  • New Relic
    2,938 Ratings
    Visit Website
  • Grafana Cloud
    860 Ratings
    Visit Website
  • Retool
    593 Ratings
    Visit Website
  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • Google Cloud Platform
    61,049 Ratings
    Visit Website
  • TIMi
    68 Ratings
    Visit Website

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

Windocks is a leader in cloud native database DevOps, recognized by Gartner as a Cool Vendor, and as an innovator by Bloor research in Test Data Management. Novartis, DriveTime, American Family Insurance, and other enterprises rely on Windocks for on-demand database environments for development, testing, and DevOps. Windocks software is easily downloaded for evaluation on standard Linux and Windows servers, for use on-premises or cloud, and for data delivery of SQL Server, Oracle, PostgreSQL, and MySQL to Docker containers or conventional database instances. Windocks database orchestration allows for code-free end to end automated delivery. This includes masking, synthetic data, Git operations and access controls, as well as secrets management. Windocks can be installed on standard Linux or Windows servers in minutes. It can also run on any public cloud infrastructure or on-premise infrastructure. One VM can host up 50 concurrent database environments.

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 Supported
Mac Not Supported
Linux Supported
Cloud Not 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

Developers, DBAs, DevOps, Infrastructure management

Support

Phone Support Supported
24/7 Live Support Not Supported
Online Supported

Support

Phone Support Supported
24/7 Live Support 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

$799/month
Standard edition server supports 20 simultaneous database clones from images up to 1 TB.
Free Version Supported
Free Trial Supported

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 5.0 / 5
ease 5.0 / 5
features 5.0 / 5
design 5.0 / 5
support 5.0 / 5

Pros & Cons from Real Users

Pros

  • We have been using Windocks for a number of years now. We currently are using 5 Windocks hosts and 40+ containers. To have access to a functional SQL server, for development or trouble-shooting production issues, in minutes is invaluable.
  • Very reliable deliver of SQL Server database environments with cloned databased. Excellent and timely support.
  • - concept of "database containers" to isolate enable each dev and test to work in their own writable environments - easy application of access controls so devs only access their designated environments - database cloning to minimize disk space associated with instances - familiar docker commands to environments to be updated frequently and automatically

Cons

  • I can't think of anything negative to say about Windocks. The installation is extremely easy. The upgrades are timely and useful. We have asked a lot from them feature-wise over the years and they never fail to come through.
  • Required a DevOps mindset to adopted but more than worth it at the end.
  • - cultural change to automate what used to be manually done by our DBA. Had to sell this internally to the team, but it was totally worth it in the end. - some initial time needed to set this up just right to automate what we wanted. Once set up, it just runs flawlessly.

Training

Documentation Supported
Webinars Supported
Live Online Not Supported
In Person Not Supported

Training

Documentation Supported
Webinars Supported
Live Online Supported
In Person Not Supported

Company Information

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

Company Information

LangGrant
Founded: 2015
United States
www.windocks.com

Alternatives

DB Optimizer

DB Optimizer

IDERA, an Idera, Inc. company

Alternatives

SQL Secure

SQL Secure

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

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
Redgate Deploy

Redgate Deploy

Redgate Software
DB PowerStudio

DB PowerStudio

IDERA, an Idera, Inc. company
ClusterControl

ClusterControl

Severalnines
SQL Sentry

SQL Sentry

SolarWinds
Delphix

Delphix

Perforce

Categories

Database Supported
SQL Server Supported

Categories

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

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

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

SQL Server Features

CPU Monitoring Not Supported
Credential Management Supported
Database Servers Supported
Deployment Testing Supported
Docker Compatible Containers Supported
Event Logs Not Supported
History Tracking Not Supported
Patch Management Not Supported
Scheduling Not Supported
Supports Database Clones Supported
User Activity Monitoring Not Supported
Virtual Machine Monitoring Not Supported

Application Development Features

Access Controls/Permissions Supported
Code Assistance Not Supported
Code Refactoring Not Supported
Collaboration Tools Supported
Compatibility Testing Supported
Data Modeling Supported
Debugging Supported
Deployment Management Supported
Graphical User Interface Supported
Mobile Development Supported
No-Code Supported
Reporting/Analytics Supported
Software Development Supported
Source Control Supported
Testing Management Supported
Version Control Supported
Web App Development Not Supported

Data Privacy Management Features

Access Control Not Supported
CCPA Compliance Not Supported
Consent Management Not Supported
Data Mapping Supported
GDPR Compliance Not Supported
Incident Management Not Supported
PIA / DPIA Not Supported
Policy Management Not Supported
Risk Management Supported
Sensitive Data Identification Not Supported

DevOps Features

Approval Workflow Not Supported
Dashboard Supported
KPIs Supported
Policy Management Supported
Portfolio Management Not Supported
Prioritization Not Supported
Release Management Supported
Timeline Management Not Supported
Troubleshooting Reports Not Supported

Integrations

SQL Server Supported
Actifio Not Supported
Amazon EC2 Supported
Azure Virtual Machines Supported
Cohesity Not Supported
Collate Supported
Curiosity Modeller Not Supported
IBM InfoSphere Data Architect Supported
IRI Data Protector Suite Not Supported
IRI FieldShield Not Supported
IRI Voracity Not Supported
Mage Dynamic Data Masking Not Supported
MySQL Not Supported
NetApp SnapMirror Not Supported
Oracle Database Not Supported
PostgreSQL Not Supported
SQL Server Reporting Services (SSRS) Not Supported

Integrations

SQL Server Supported
Actifio Supported
Amazon EC2 Not Supported
Azure Virtual Machines Not Supported
Cohesity Supported
Collate Not Supported
Curiosity Modeller Supported
IBM InfoSphere Data Architect Not Supported
IRI Data Protector Suite Supported
IRI FieldShield Supported
IRI Voracity Supported
Mage Dynamic Data Masking Supported
MySQL Supported
NetApp SnapMirror Supported
Oracle Database Supported
PostgreSQL Supported
SQL Server Reporting Services (SSRS) Supported
Claim SQL Query Tuner and update features and information
Claim SQL Query Tuner and update features and information
Claim Windocks and update features and information
Claim Windocks and update features and information