DB OptimizerIDERA, an Idera, Inc. company
|
DataGripJetBrains
|
|||||
Related Products
|
||||||
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
Meet DataGrip, our new database IDE that is tailored to suit the specific needs of professional SQL developers. Allows you to execute queries in different modes and provides a local history that keeps track of all your activity and protects you from losing your work. Lets you jump to any table, view, or procedure by its name via the corresponding action, or directly from its usages in the SQL code. Gives you an extended insight into how your queries work and into the database engine behavior, so you can make your queries more efficient. DataGrip provides context-sensitive code completion, helping you to write SQL code faster. Completion is aware of the tables structure, foreign keys, and even database objects created in code you're editing. DataGrip detects probable bugs in your code and suggests the best options to fix them on the fly. It will immediately let you know about unresolved objects, using keywords as identifiers and always offers a way to fix the problems.
|
|||||
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
Not Supported
Mac
Not Supported
Linux
Not Supported
Cloud
Supported
On-Premises
Not Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
|||||
Audience
database developer and database administrators
|
Audience
SQL developers looking for a database IDE software solution to execute queries and manage databases
|
|||||
Support
Phone Support
Supported
24/7 Live Support
Not Supported
Online
Supported
|
Support
Phone Support
Supported
24/7 Live Support
Not Supported
Online
Supported
|
|||||
API
Offers API
Not Supported
|
API
Offers API
Not Supported
|
|||||
Screenshots and Videos |
Screenshots and Videos |
|||||
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
|
Pricing
$199 per year
Free Version
Not Supported
Free Trial
Supported
|
|||||
Reviews/
|
Reviews/
|
|||||
Pros & Cons from Real UsersPros
Cons
|
||||||
Training
Documentation
Supported
Webinars
Supported
Live Online
Not Supported
In Person
Not Supported
|
Training
Documentation
Supported
Webinars
Not Supported
Live Online
Not Supported
In Person
Supported
|
|||||
Company InformationIDERA, an Idera, Inc. company
Founded: 2004
United States of America
www.idera.com/dboptimizer-sql-database-optimization
|
Company InformationJetBrains
Founded: 2000
Czech Republic
www.jetbrains.com/datagrip/
|
|||||
Alternatives |
Alternatives |
|||||
|
|
||||||
|
|
||||||
|
|
|
|||||
|
|
|
|||||
Categories |
Categories |
|||||
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
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
|
||||||
Integrations
IBM Db2
Supported
Oracle Database
Supported
SQL Server
Supported
.NET
Not Supported
Booking.com
Not Supported
Claude Opus 4.5
Not Supported
Claude Opus 4.8
Not Supported
Cody
Not Supported
Devin Desktop
Not Supported
Firebender
Not Supported
|
Integrations
IBM Db2
Supported
Oracle Database
Supported
SQL Server
Supported
.NET
Supported
Booking.com
Supported
Claude Opus 4.5
Supported
Claude Opus 4.8
Supported
Cody
Supported
Devin Desktop
Supported
Firebender
Supported
|
|||||
|
|
|