DB OptimizerIDERA, an Idera, Inc. company 
                        
                        
                     | 
        
        
        
            SQL Workload AnalysisIDERA, an Idera, Inc. company 
                        
                        
                     | 
        
        |||||
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
            Monitor and diagnose detailed database wait states and application transactions. Problematic SQL queries can severely reduce the performance of SQL Server and the business-critical applications that it supports. With the SQL Workload Analysis add-on, continuously monitor and analyze server workload, leverage the simple user interface that focuses on wait states and application performance, and troubleshoot problematic SQL code from changes made to database applications. Perform real-time analysis with continuous SQL sampling intervals. Know instantly where databases are spending time. Quickly isolate slow SQL statements and drill down for actionable advice. Investigate historical query plan trends. Utilize automatic recommendations to improve query performance.
             
            
        
         | 
        |||||
        
        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
         
        
    
         | 
        |||||
                
            
        
        Support
            
                Phone Support
            
            
         
        
    
        
        
            
                24/7 Live Support
            
            
         
        
    
        
        
            
                Online
            
            
         
        
    
         | 
        
        
                
            
        
        Support
            
                Phone Support
            
            
         
        
    
        
        
            
                24/7 Live Support
            
            
         
        
    
        
        
            
                Online
            
            
         
        
    
         | 
        |||||
                
            
        
        API
            
                Offers API
            
            
         
        
    
         | 
        
        
                
            
        
        API
            
                Offers API
            
            
         
        
    
         | 
        |||||
                
            
        
        Screenshots and Videos | 
        
        
                
            
        
        Screenshots and Videos | 
        |||||
                
            
        
        Pricing
        $572 per user (workstation_
        
     
    
    
        
        
            
                Free Version
            
            
         
        
    
        
        
            
                Free Trial
            
            
         
        
    
         | 
        
        
                
            
        
        Pricing
        $400 per instance
        
     
    
    
        
        
            
                Free Version
            
            
         
        
    
        
        
            
                Free Trial
            
            
         
        
    
         | 
        |||||
                
            
        
    
        
Reviews/
         | 
        
        
                
            
        
    
        
Reviews/
         | 
        |||||
                
            
        
        Training
            
                Documentation
            
            
         
        
    
        
        
            
                Webinars
            
            
         
        
    
        
        
            
                Live Online
            
            
         
        
    
        
        
            
                In Person
            
            
         
        
    
         | 
        
        
                
            
        
        Training
            
                Documentation
            
            
         
        
    
        
        
            
                Webinars
            
            
         
        
    
        
        
            
                Live Online
            
            
         
        
    
        
        
            
                In Person
            
            
         
        
    
         | 
        |||||
                
            
        
        Company InformationIDERA, an Idera, Inc. company 
    
    Founded: 2004 
    
    United States of America 
    www.idera.com/dboptimizer-sql-database-optimization 
         | 
        
        
                
            
        
        Company InformationIDERA, an Idera, Inc. company 
    
    Founded: 2004 
    
    United States of America 
    www.idera.com/productssolutions/sqlserver/sql-workload-analysis 
         | 
        |||||
                
            
            
    
        
        
        
            Alternatives | 
        
        
                
            
            
    
        
        
        
            Alternatives | 
        |||||
| 
                
            
            
    
        
        
        
        
             | 
        
        
                
            
            
    
        
        
        
        
             | 
        |||||
| 
                
            
            
    
        
        
        
        
             | 
        
        
                
            
            
    
        
        
        
        
             | 
        |||||
| 
                
            
            
    
        
        
        
        
             | 
        
        
                
            
            
    
        
        
        
        
             | 
        |||||
| 
                
            
            
    
        
        
        
        
             | 
        
        
                
            
            
    
        
        
        
        
             | 
        |||||
                
            
        
    
        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
            
            
         
        
    
                     | 
        |||||
                
            
        
    
        Integrations
            
                
    SQL Server
            
            
         
        
    
        
        
            
                
    Amazon EC2
            
            
         
        
    
        
        
            
                
    Azure Virtual Machines
            
            
         
        
    
        
        
            
                
    IBM Db2
            
            
         
        
    
        
        
            
                
    Oracle Database
            
            
         
        
    
        
        
            
                
    SAP Adaptive Server Enterprise (ASE)
            
            
         
        
    
                
             | 
        
        
                
            
        
    
        Integrations
            
                
    SQL Server
            
            
         
        
    
        
        
            
                
    Amazon EC2
            
            
         
        
    
        
        
            
                
    Azure Virtual Machines
            
            
         
        
    
        
        
            
                
    IBM Db2
            
            
         
        
    
        
        
            
                
    Oracle Database
            
            
         
        
    
        
        
            
                
    SAP Adaptive Server Enterprise (ASE)
            
            
         
        
    
                
             | 
        |||||
| 
                
            
        
    
     | 
        
        
                
            
        
    
     |