Database Expert allows Adaptive Server Enterprise database administrators to analyze, predict, preempt, diagnose, optimize, and manage performance changes to ensure that mission-critical business applications run optimally. Database Expert allows you to maximize application performance by focusing on database factors that contribute to 90% of performance problems—SQL statements, indexes, and database changes.
Database Expert provides the following modules and functionality:
Performance diagnostics
SQL Inspector
SQL Collector for Monitor Server
SQL Scanner
Performance Monitor
Performance optimization
SQL Optimizer
Index Advisor
Abstract Plan Manager
Performance management
Configuration Analyzer
Migration Analyzer
Index Impact Analyzer
Index Usage Analyzer
Database administration
Database Explorer
Object Extractor
SQL Worksheet
Development
SQL Formatter
Code Finder
Functionality
User-defined temp table
SQL History
SQL Repository
Common SQL functions
Editor functions
Activity log
Reports
Plan help
Database Expert assistant
See the Database Expert online help for complete instructions on using this tool.
