DB Optimizer

DB Optimizer

IDERA, an Idera, Inc. company
IDERA Precise for Databases

IDERA Precise for Databases

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

Precise for Databases helps database administrators to find and fix database performance problems in physical, virtual, and cloud environments. Unlike its competition, it provides deep database optimization, isolation of problems and causes, scalable deployment, what-if analysis for changes, and history, trending, and planning. Precise for Databases ensures that databases perform at peak efficiency. It captures, measures, and correlates performance metrics from all critical components of the system. It then detects and corrects the root cause of database and transaction performance problems before they become noticeable for databases and their related applications. Monitor Microsoft SQL Server, Oracle Database, IBM Db2, and SAP Sybase ASE. For each of these database platforms, the interface of Precise looks and behaves the same to minimize the learning curve. Precise for Databases samples the monitored databases once per second or more frequently, has low overhead (typically 1%).

About

Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. Run your sql and sql scripts, manage users, create and edit objects, import data to new or existing tables, diagnose performance issues, visualize your schemas, and much more. The power of your favorite desktop tool, in your browser. Available with Oracle REST Data Services for your on-premises instances. Migrate Oracle On-Premises to Oracle Cloud. Click, browse, and managed the contents of your Oracle Database.

About

Enjoy the highest performance and unlimited possibilities when working with SQLite. SQLite Data Access Components (LiteDAC) is a library of components that provides native connectivity to SQLite from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. LiteDAC is designed for programmers to develop truly cross-platform desktop and mobile SQLite database applications with no need to deploy any additional libraries. LiteDAC-based DB applications are easy to deploy and do not require the installation of other data provider layers (such as BDE or ODBC), and that's why they can work faster than the ones based on standard Delphi data connectivity solutions. Moreover, LiteDAC provides an additional opportunity to work with SQLite in Delphi and C++Builder directly by linking the client library statically in your application.

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, Oracle Database, Sybase ASE, and IBM Db2

Audience

Developers in search of a database management solution to simplify the development and management of Oracle Database in both traditional and Cloud deployments

Audience

Developer teams and anyone seeking a solution providing a library of components to build cross-platform databases

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

No information available.
Free Version
Free Trial

Pricing

No information available.
Free Version
Free Trial

Pricing

$169.95 per year
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 5.0 / 5
ease 3.0 / 5
features 4.0 / 5
design 3.0 / 5
support 4.0 / 5

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
www.idera.com/precise-for-databases

Company Information

Oracle
Founded: 1977
United States
www.oracle.com/database/technologies/appdev/sqldeveloper-landing.html

Company Information

Devart
Founded: 1997
Czech Republic
www.devart.com/litedac/

Alternatives

SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

Alternatives

Alternatives

Alternatives

Aqua Data Studio

Aqua Data Studio

AquaFold, 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
SQL Sentry

SQL Sentry

SolarWinds
SQL Sentry

SQL Sentry

SolarWinds
SQLGate

SQLGate

CHEQUER

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

Application Performance Monitoring (APM) Features

Baseline Manager
Diagnostic Tools
Full Transaction Diagnostics
Performance Control
Resource Management
Root-Cause Diagnosis
Server Performance
Trace Individual Transactions

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

.NET
AIHelperBot
C++
COBOL
Convertigo
Delphi
Devart ODBC Drivers
FreeBSD
IBM Db2
Java
Oracle Cloud Infrastructure
Oracle Database
Pascal
SEA Manager
SQL
SQL Server
SQLite
SQLthroughAI
Safyr
Visual Basic

Integrations

.NET
AIHelperBot
C++
COBOL
Convertigo
Delphi
Devart ODBC Drivers
FreeBSD
IBM Db2
Java
Oracle Cloud Infrastructure
Oracle Database
Pascal
SEA Manager
SQL
SQL Server
SQLite
SQLthroughAI
Safyr
Visual Basic

Integrations

.NET
AIHelperBot
C++
COBOL
Convertigo
Delphi
Devart ODBC Drivers
FreeBSD
IBM Db2
Java
Oracle Cloud Infrastructure
Oracle Database
Pascal
SEA Manager
SQL
SQL Server
SQLite
SQLthroughAI
Safyr
Visual Basic

Integrations

.NET
AIHelperBot
C++
COBOL
Convertigo
Delphi
Devart ODBC Drivers
FreeBSD
IBM Db2
Java
Oracle Cloud Infrastructure
Oracle Database
Pascal
SEA Manager
SQL
SQL Server
SQLite
SQLthroughAI
Safyr
Visual Basic
Claim DB Optimizer and update features and information
Claim DB Optimizer and update features and information
Claim IDERA Precise for Databases and update features and information
Claim IDERA Precise for Databases and update features and information
Claim Oracle SQL Developer and update features and information
Claim Oracle SQL Developer and update features and information
Claim SQLite Data Access Components and update features and information
Claim SQLite Data Access Components and update features and information