Quest Support
  • Global Coverage
  • Highly Skilled Engineers
  • Commitment to Customer Satisfaction
  • Flexible Support Offerings
Learn more »

SQL Optimizer for Sybase ASE

Maximum Performance through SQL Validation

Quest SQL Optimizer for Sybase ASE offers a fully automated approach to maximizing SQL performance. It scans and analyzes SQL, identifying potential performance issues directly from running SQL statements, T-SQL, or other source code. It explores every possible way of improving SQL performance to validate that you have the best performing SQL — and if you don't, it suggests better performing alternatives. It eliminates your manual, time-intensive tasks. Plus, it helps you analyze, predict, preempt, diagnose, optimize, and manage performance changes, so your organization’s critical applications run faster.

Features

Performance Diagnostics

SQL Inspector — Identifies poorly performing and resource-intensive SQL statements. Displays and compares SQL activity statistics to diagnose performance bottlenecks.

SQL Collector — Captures executing SQL statements based on your criteria. Categorizes statements by suspected levels of performance problems.

SQL Scanner — Extracts SQL statements in applications, database objects, or files. Analyzes SQL query plans to proactively identify inefficient SQL statements.

Performance Monitor — Monitors Adaptive Server’s performance. Take snapshots, monitor in real time, and schedule monitors of Adaptive Server’s performance statistics and diagnostic metrics.

Performance Optimization

SQL Optimizer — Generates a list of semantically equivalent SQL statements. Benchmark test SQL alternatives to identify the most efficient SQL statements.

Index Advisor — Analyzes the syntax of a SQL statement and the database structure to propose new index scenarios for improved performance. Provides detailed information on the suggested indexes. Benchmark index recommendations to identify the greatest performance gains.

Abstract Plan Manager — Simplifies abstract plan maintenance. Provides a graphical interface to easily view, create, delete, and modify abstract plans and abstract plan groups.

Performance Management

Configuration Analyzer — Evaluates how changing Adaptive Server’s parameters affects performance. Analyze potential performance improvement before making configuration parameter changes permanent.

Index Usage Analyzer — Identifies unused indexes by analyzing query plans from SQL statements in the SQL repository.  Delete unused indexes to free up space and improve the speed of DML statements.

Index Impact Analyzer — Shows which SQL statements are impacted by new indexes and identifies the index set alternative that yields the highest performance gain with the least impact on the database.

Migration Analyzer — Helps pre-empt performance degradation during migrations, upgrades, and application rollouts.  Ensures peak performance by tracking query plan and cost changes. Integrate abstract plan management to stabilize SQL performance during migrations.

Sys Reqs

System Requirements

Before installing SQL Optimizer ensure your system meets the following minimum hardware and software requirements:

Platform233 MHZ minimum
Memory512 MB of RAM minimum, 1 GB recommended
Hard Disk Space67 MB of disk space for installation
Operating SystemWindows® Server 2003, 2008 (32-Bit or 64-Bit), 2008 R2 (64-Bit), 2012 (32-Bit or 64-Bit)
Windows 7, 8 (32-Bit or 64-Bit)
Windows® XP Professional (32-Bit or 64-Bit, Service Pack 3 or later)
Windows® Vista® (32-Bit or 64-Bit)
BrowserMicrosoft® 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 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.