DB Optimizer

DB Optimizer

IDERA, an Idera, Inc. company
SQL Defrag Manager

SQL Defrag Manager

IDERA, an Idera, Inc. company
SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

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.

About

Automatically find and fix database index fragmentation. Database administrators for SQL Server need to maintain the high availability and performance of their databases. Key areas that dramatically affect the performance of SQL Server are indexes that are fragmented and out of cluster. SQL Defrag Manager is a unique solution for defragmenting indexes for SQL Server. It automates the time-consuming process of finding fragmented indexes based on policies for the targeted databases.

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

dbForge Studio for PostgreSQL is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to your requirements in a convenient and user-friendly interface. The tool provides a data editing tool to customize your queries and property window so that users can view all the required information of PostgreSQL database objects they are interested in. Key features: * AI Assistant Integration. * SQL Development. Save your time and improve code quality when creating and editing queries. * Explorer. Navigate through the object tree and find any PostgreSQL object you want. * Data Editor. Users can manage the settings of tables. * Data Export and Data Import. Supports 10+ widely used data formats, a number of advanced options, and templates for recurring scenarios. * Query Profiler. * Data and Schema Compare. * Data Generator. * Pivot Table.

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 developer and database administrators

Audience

database administrators for Microsoft SQL Server

Audience

database administrators for Microsoft SQL Server

Audience

Mid Size Business, Small Business, Enterprise, Freelance, Nonprofit, Government, and Startup.

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

$572 per user (workstation_
Free Version
Free Trial

Pricing

$1,196 per instance
Free Version
Free Trial

Pricing

$400 per instance
Free Version
Free Trial

Pricing

$89.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/dboptimizer-sql-database-optimization

Company Information

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

Company Information

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

Company Information

Devart
Founded: 1997
Czech Republic
www.devart.com/dbforge/postgresql/studio/

Alternatives

SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

Alternatives

SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

Alternatives

DB Optimizer

DB Optimizer

IDERA, an Idera, Inc. company

Alternatives

DB Optimizer

DB Optimizer

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

SQL Diagnostic Manager for SQL Server

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

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
DB PowerStudio

DB PowerStudio

IDERA, an Idera, Inc. company
DB PowerStudio

DB PowerStudio

IDERA, an Idera, Inc. company
SQL Sentry

SQL Sentry

SolarWinds
SQL Sentry

SQL Sentry

SolarWinds

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

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

Integrations

Amazon EC2
Azure Virtual Machines
Collate
IBM Db2
IBM InfoSphere Data Architect
Oracle Database
PostgreSQL
SAP Adaptive Server Enterprise (ASE)
SQL Server
dbForge AI Assistant

Integrations

Amazon EC2
Azure Virtual Machines
Collate
IBM Db2
IBM InfoSphere Data Architect
Oracle Database
PostgreSQL
SAP Adaptive Server Enterprise (ASE)
SQL Server
dbForge AI Assistant

Integrations

Amazon EC2
Azure Virtual Machines
Collate
IBM Db2
IBM InfoSphere Data Architect
Oracle Database
PostgreSQL
SAP Adaptive Server Enterprise (ASE)
SQL Server
dbForge AI Assistant

Integrations

Amazon EC2
Azure Virtual Machines
Collate
IBM Db2
IBM InfoSphere Data Architect
Oracle Database
PostgreSQL
SAP Adaptive Server Enterprise (ASE)
SQL Server
dbForge AI Assistant
Claim DB Optimizer and update features and information
Claim DB Optimizer and update features and information
Claim SQL Defrag Manager and update features and information
Claim SQL Defrag Manager and update features and information
Claim SQL Query Tuner and update features and information
Claim SQL Query Tuner and update features and information
Claim dbForge Studio for PostgreSQL and update features and information
Claim dbForge Studio for PostgreSQL and update features and information