Features & Benefits

Quest® SQL Optimizer for Sybase ASE

Benefits: 

	Validate database code to ensure the best-possible performance
	Pinpoint and resolve SQL performance problems quickly, before end users are impacted
	Automate SQL optimization
	Analyze the impact of database changes on SQL performance
	Reduce overall development and administration costs and spend less time reacting to performance issues

Features:
 

Performance Diagnostics

• SQL Inspector identifies poorly performing SQL statements by extracting SQL statements and SQL performance statistics from the Adaptive Server Monitoring tables (Adaptive Server 12.5.0.3 or later) or from the QP Metrics (Adaptive Server 15 or later). The SQL Inspector graphically displays and compares SQL activity statistics to diagnose performance bottlenecks and identifies the top most resource intensive SQL statements.
• SQL Collector for Monitor Server allows you to capture any currently executing SQL statements according to your user-defined criteria.  Each SQL statement captured is categorized according to suspected levels of performance problem.
• SQL Scanner extracts SQL statements in existing applications, database objects or files and analyzes the SQL query plans to proactively identify inefficient SQL statements without execution of programs.
• Performance Monitor facilitates monitoring Adaptive Server’s performance based on its sophisticated built-in monitoring tables (12.5.0.3 and later). From this feature, users can take snapshots, monitor in real time and schedule monitors of Adaptive Server’s performance statistics and diagnostic metrics.

Performance Optimization

• SQL Optimizer applies advanced SQL transformation technology to generate a list of semantically equivalent SQL statements. Benchmark test SQL alternatives to identify the most efficient SQL statement for your database environment.
• Index Advisor analyzes the syntax of a SQL statement and the database structure and  proposes new index scenarios to improve performance. It provides detailed information on the suggested indexes, such as space requirements and selectivity. Further, the index recommendations can be benchmarked to identify which index yields the greatest performance gain.
• Abstract Plan Manager simplifies abstract plans maintenance. It provides a graphical interface to easily view, create, delete and modify abstract plans and abstract plan groups. Abstract plans are available in Adaptive Server 12.0 and later.

Performance Management

• Configuration Analyzer evaluates the effect on SQL performance when changing Adaptive Server parameter settings.  It enables users to analyze potential database 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.  These unused indexes can then be deleted to free up space and improve the speed of DML statements.
• Index Impact Analyzer evaluates the effect of the creation of the indexes in the database. It shows which SQL statements are impacted by the 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 when performing database migrations, upgrades and application rollouts.  It ensures reliable database performance by tracking query plan and cost changes. Additionally users have the option to integrate abstract plan management to help stabilize SQL performance during migrations.