DB Optimizer

DB Optimizer

IDERA, an Idera, Inc. company
Windocks

Windocks

LangGrant
5.0 out of 5 stars
DB Optimizer Windocks

Related Products

  • AdRem NetCrunch
    4.6 out of 5 stars 165 Ratings
    Visit Website for AdRem NetCrunch
  • RaimaDB
    4.8 out of 5 stars 12 Ratings
    Visit Website for RaimaDB
  • Google Cloud SQL
    4.5 out of 5 stars 554 Ratings
    Visit Website for Google Cloud SQL
  • DbVisualizer
    4.8 out of 5 stars 593 Ratings
    Visit Website for DbVisualizer
  • New Relic
    4.5 out of 5 stars 2,965 Ratings
    Visit Website for New Relic
  • Grafana Cloud
    4.6 out of 5 stars 673 Ratings
    Visit Website for Grafana Cloud
  • Google Cloud Platform
    4.5 out of 5 stars 61,093 Ratings
    Visit Website for Google Cloud Platform
  • Google Cloud BigQuery
    4.5 out of 5 stars 2,037 Ratings
    Visit Website for Google Cloud BigQuery
  • Retool
    4.6 out of 5 stars 608 Ratings
    Visit Website for Retool
  • TIMi
    4.9 out of 5 stars 68 Ratings
    Visit Website for TIMi
DB Optimizer:

About

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.
Windocks:

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.
DB Optimizer:

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
Windocks:

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
DB Optimizer:

Audience

database developer and database administrators
Windocks:

Audience

Developers, DBAs, DevOps, Infrastructure management
DB Optimizer:

Support

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

Support

Phone Support Supported
24/7 Live Support Supported
Online Supported
DB Optimizer:

API

Offers API Not Supported
Windocks:

API

Offers API Not Supported
DB Optimizer:

Screenshots and Videos

Windocks:

Screenshots and Videos

DB Optimizer:

Pricing

$572 per user (workstation_
USD 572 per user (workstation) with first year maintenance included; pricing for new customers only
Free Version Not Supported
Free Trial Supported
Windocks:

Pricing

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

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
Windocks:

Reviews/Ratings

Overall 5.0 / 5
ease 5.0 / 5
features 5.0 / 5
design 5.0 / 5
support 5.0 / 5
Windocks:

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.
DB Optimizer:

Training

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

Training

Documentation Supported
Webinars Supported
Live Online Supported
In Person Not Supported
DB Optimizer:

Company Information

IDERA, an Idera, Inc. company
Founded: 2004
United States of America
www.idera.com/dboptimizer-sql-database-optimization
Windocks:

Company Information

LangGrant
Founded: 2015
United States
www.windocks.com
DB Optimizer:

Alternatives

SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company
Windocks:

Alternatives

DB Optimizer:
SolarWinds Database Performance Analyzer

SolarWinds Database Performance Analyzer

SolarWinds
4.5 out of 5 stars
Windocks:
SQL Secure

SQL Secure

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

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
Windocks:
IRI RowGen

IRI RowGen

IRI, The CoSort Company
DB Optimizer:
SQL Sentry

SQL Sentry

SolarWinds
Windocks:
Google Cloud SQL

Google Cloud SQL

Google
4.5 out of 5 stars
DB Optimizer:
DB PowerStudio

DB PowerStudio

IDERA, an Idera, Inc. company
Windocks:
Redgate Deploy

Redgate Deploy

Redgate Software
DB Optimizer:

Categories

Database Supported
SQL Server Supported
Windocks:

Categories

DB Optimizer:

SQL Server Features

CPU Monitoring Not 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 Not Supported
Prioritization Not Supported
Query Analysis Supported
Resource Optimization Not Supported
Troubleshooting Not Supported
Windocks:

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
DB Optimizer:

Integrations

Oracle Database Supported
SQL Server Supported
Actifio Not Supported
Cohesity Not Supported
Curiosity Modeller Not Supported
IBM Db2 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
PostgreSQL Not Supported
SAP Adaptive Server Enterprise (ASE) Supported
SQL Server Reporting Services (SSRS) Not Supported
Windocks:

Integrations

Oracle Database Supported
SQL Server Supported
Actifio Supported
Cohesity Supported
Curiosity Modeller Supported
IBM Db2 Not Supported
IRI Data Protector Suite Supported
IRI FieldShield Supported
IRI Voracity Supported
Mage Dynamic Data Masking Supported
MySQL Supported
NetApp SnapMirror Supported
PostgreSQL Supported
SAP Adaptive Server Enterprise (ASE) Not Supported
SQL Server Reporting Services (SSRS) Supported
DB Optimizer:
Claim DB Optimizer and update features and information
Claim DB Optimizer and update features and information
Windocks:
Claim Windocks and update features and information
Claim Windocks and update features and information