Advanced Performance Diagnostics

Embarcadero Performance Analyst takes the guesswork out of performance management. Intelligent diagnostic information and strong drill down details get to the heart of any episode of performance degradation. Running inside the Embarcadero DBArtisan console - or standalone in a Web browser - Performance Analyst helps you pinpoint performance problems that threaten a database's availability or response times. It provides novices with an easy-to-use intuitive interface and expert help as a welcome aid for troubleshooting difficult performance issues. At the same time Embarcadero Performance Analyst offers strong features to satisfy the database performance expert.

At-a-Glance Performance Diagnosis

Embarcadero Performance Analyst organizes performance metrics in an intelligent and organized way to quickly display the total performance picture of a database with plenty of drill down details available when you need them. The powerful interface takes all the guesswork out of determining a database's performance levels and instantly indicates if a key database needs attention.

Embarcadero Performance Analyst employs all key performance methodologies in one tool so that you can utilize one or all performance methods for monitoring key databases.

• Provides ratio-based analysis, using delta-based statistics, across all performance categories like memory, I/O, and others.
• Displays full bottleneck and wait-based analysis on every home page, and reveals detailed information for every item that is causing a database's performance to drop.
• Emphasizes workload analysis on every home page so you can instantly see what sessions are using the most resources in the database.
• Presents SQL-based analysis, which allows you to quickly pinpoint SQL statements that are causing the most I/O usage, consuming the most CPU, etc.
• Offers customizable thresholds that allow you to configure Embarcadero Performance Analyst to visually indicate all performance metrics that are out of line with acceptable standards of performance.
• Includes a central alarm log, which is a one-stop notice board of all problems that a database is currently experiencing.

Detailed Performance Analysis

Embarcadero Performance Analyst provides one of the strongest frameworks available in terms of drill down details so you can get to the heart of any episode of performance degradation. In addition to key analysis views, it presents detailed information for memory, I/O, space, database objects, user activity, and SQL statements.

• Memory drill downs provide a clear picture of memory cache utilization, latch activity, and more.
• I/O drill downs offer a complete picture of global I/O activity as well as detailed file and object I/O.
• Space drill downs reveal database and object fragmentation as well as other space details.
• Object drill downs advise as to which objects have become invalidated on the database, which are the most accessed, and supplies a summary of all object demographics.
• User drill downs feature all session activity, system and session waits, and all locking details.
• Uncover all unoptimized Oracle SQL statements through detailed SQL analysis.
• Capture and profile all Microsoft SQL Server SQL and procedure executions.

Intelligent and Integrated Feature Set

Embarcadero Performance Analyst is fully integrated into Embarcadero DBArtisan so you can perform all your performance management duties, as well as other cross-platform database work, in one place. Embarcadero Performance Analyst also does not install data objects on any monitored datasource, so it leaves no storage-related footprint on the database.

• Run several iterations of Embarcadero Performance Analyst right inside DBArtisan. For example, you can simultaneously monitor an Oracle10g database along with a Microsoft SQL Server 2005, Sybase 12.5, and DB2 LUW server all from within DBArtisan.
• Monitor your database server's operating system performance from within Performance Analyst without using agents. You can monitor all popular UNIX and Linux operating systems as well as the major Microsoft Windows platforms.
• Pinpoint multiple problems with Embarcadero Performance Analyst, and then correct them using DBArtisan. For example, if you discover an Oracle tablespace is low on free space, you can click the tablespace and automatically open it in DBArtisan's Tablespace Editor to enable AUTOEXTEND, resize the tablespace, or add a new datafile.
• Run Embarcadero Performance Analyst outside DBArtisan in any standard Microsoft Internet Explorer Web browser.

DBMS Support

• IBM DB2 for LUW 8.x and 9x
• Microsoft SQL Server 2000, 2005 and 2008
• Oracle 8i, 9i, 10g and 11g
• Sybase ASE 12.5 - 15.x

System Requirements

• Windows® 2000, Windows 2003 (All editions), Windows 2003 R2 (All editions) and Windows XP (SP1 and SP2) and Windows Vista (Ultimate and Business) - 32-bit architecture only
• 512 MB memory
• 512 MB disk space
• DBMS Client connectivity utilities
• Internet Explorer 5.5 or later
• Power User or Administrator privilege required to run software