Optimize performance through SQL validation.
Detect and analyze problems directly from running SQL statements, T-SQL or other source codes.
SQL Optimizer for SAP ASE maximizes your SQL performance with a completely automated approach. Detect and analyze problems directly from running SQL statements, T-SQL or other source codes. This advanced tool eliminates manual, time-intensive tasks, and actively searches for ways to improve performance. Plus, it helps you analyze , optimize and manage performance changes so critical applications can run faster.
Performance diagnostics key featuresSQL inspector
Diagnoses bottlenecks by comparing and presenting SQL activity data, and detects poorly performing and resource-heavy SQL statements.
Groups statements by the suspected severity of performance issues, and captures executing SQL statement based on your benchmarks.
Proactively targets inefficient SQL statements by analyzing SQL query plans, and extracts SQL statements in files, applications and database objects.
Monitors Adaptive Server’s performance in real time, plus takes snapshots and schedules monitors of its performance data and diagnostic metrics.
Performance optimization key featuresSQL optimizer
Identifies the most efficient SQL statements by benchmark testing SQL alternatives, and creates a list of semantically equivalent SQL statements.
Proposes new index scenarios for better performance by studying the syntax of an SQL statement and the database structure.
Abstract plan manager
Makes it easy to generate, view, delete and amend abstract plans and groups through a graphical interface, plus streamlines abstract plan maintenance.
Performance managementConfiguration analyzer
Analyzes how modifying Adaptive Server’s parameters would impact performance, and evaluates potential improvements before making permanent configuration changes.
Index usage analyzer
Eliminates unused indexes to create more space – as well as accelerate the speed of DML statements – after analyzing query plans from SQL statements located in the SQL repository.
Index impact analyzer
Highlights the index set alternative that offers the highest performance gain with the least database impact, and identifies which SQL statements are affected by new indexes.
Tracks query plan and cost changes for better performance, and integrates abstract plan management to stabilize SQL performance during migrations. Also, helps stop performance degradations during upgrades and application rollouts.
- Before installing SQL Optimizer ensure your system meets the following minimum hardware and software requirements:
233 MHZ minimum
512 MB of RAM minimum, 1 GB recommended
Hard disk space
67 MB of disk space for installation
Windows® Server 2003, 2008 (32-Bit or 64-Bit), 2008 R2 (64-Bit), 2012 (32-Bit or 64-Bit)
Windows 7, 8, 8.1 (32-Bit or 64-Bit)
Windows® Vista® (32-Bit or 64-Bit)
Microsoft® Internet Explorer® 6.0 or later
Adobe® Acrobat Reader® 7.0 or later (for viewing installation guide)
SQL Optimizer installs a database client if one is not installed.
SAP Adaptive Server 15.0 or later
For a complete list of recommended software and hardware requirements, please refer to the most recent release notes document.
Download printable materials to gain insight on how this product can help you simplify IT challenges.
Peruse webcasts and in-person activities near you to explore the technology behind this product.
Get the most from this product as you join your peers and Dell experts to access tools and learn best practices.