SQL performance optimization through SQL validation
Automatically maximize SQL performance with SQL Optimizer for SAP ASE. 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.
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.
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.
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:
|Platform||233 MHZ minimum|
|Memory||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)
|Browser||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.