SQL Optimizer for SAP ASE

0% Finance Lease rate available on Dell PowerEdge servers. Learn More

Optimize performance through SQL validation.

Detect and analyze problems directly from running SQL statements, T-SQL or other source codes.

Software - SQL Optimizer for SAP ASE


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 features

SQL inspector
Diagnoses bottlenecks by comparing and presenting SQL activity data, and detects poorly performing and resource-heavy SQL statements.

SQL collector
Groups statements by the suspected severity of performance issues, and captures executing SQL statement based on your benchmarks.

SQL scanner
Proactively targets inefficient SQL statements by analyzing SQL query plans, and extracts SQL statements in files, applications and database objects.

Performance monitor
Monitors Adaptive Server’s performance in real time, plus takes snapshots and schedules monitors of its performance data and diagnostic metrics.

Performance optimization key features

SQL optimizer
Identifies the most efficient SQL statements by benchmark testing SQL alternatives, and creates a list of semantically equivalent SQL statements.

Index advisor
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 management

Configuration 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.

Migration analyzer
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

    Operating system
    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

    PDF viewer
    Adobe® Acrobat Reader® 7.0 or later (for viewing installation guide)

    Database client
    SQL Optimizer installs a database client if one is not installed.

    Database server
    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.
Documents Documents
Download printable materials to gain insight on how this product can help you simplify IT challenges.
Events Events
Peruse webcasts and in-person activities near you to explore the technology behind this product.
Community Community
Get the most from this product as you join your peers and Dell experts to access tools and learn best practices.

Go ahead. Ask us anything.

You've got questions, we've got experts that can help. Find out now.
Chat Online
2016 Global Excellence Silver Award Winner: Endpoint Security

KACE K1000 Systems Management Appliance

2016 Global Excellence Silver Award Winner: Endpoint Security
Learn More
Dell Financial Services

Improve the speed of doing business.

0% Finance Lease rate available on Dell SonicWALL systems.** Based on a 36-month Finance Lease.

Learn More
Dell Software | Contact Us

Contact a Dell Expert

Get help with all your business needs.

Learn More
Dell Software | Support

Software Product Support

Single location for all your product needs.

Learn More
 You can only compare up to 7 products. To compare this item, deselect one of the other 7 products.