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.