Advanced Space Management

Embarcadero Space Analyst provides sophisticated diagnostic capabilities to help you proactively detect, diagnose, and correct all types of storage problems. Running inside Embarcadero DBArtisan , Space Analyst automates all diagnostic and correction procedures so any space-related problem can be quickly detected and corrected before it reaches critical mass. It allows novices to easily identify storage problems through its intuitive interface, while at the same time offers all the robust features to satisfy any expert.

Remove Space Bottlenecks

A single storage bottleneck can be an overwhelming event, capable of completely stopping the operation of a database. Because of this, you must be equipped to take corrective so a database's operation can continue without interruption. Embarcadero Space Analyst comes with intelligent and automated diagnostic facilities that simplify the otherwise complex process of pinpointing critical space problems. Once located, any storage bottleneck can be quickly remedied through Embarcadero Space Analyst's correction wizards and editors.

• Determine Oracle tablespace/datafile and Sybase database/object fragmentation levels using the fragmentation index.
• Quickly locate Microsoft SQL Server and Sybase databases/transaction logs that are experiencing space shortages.
• Use the graphical Oracle tablespace or SQL Server database file maps to gain understanding about object usage and locations at the physical storage level.
• Determine object space consumption throughout all databases with object overview grids.
• Correct any potential space outage by invoking DBArtisan's powerful storage and object editors from within Space Analyst.
• Easily relocate objects to new Oracle tablespaces or SQL Server filegroups with space management wizards.
• Perform full Oracle, SQL Server, Sybase, and DB2 LUW database reorganizations, which run right the first time, when space issues threaten overall database availability.
• Convert Oracle dictionary-managed tablespaces to locally-managed for databases that are 8.1.6 or later.

Identify and Correct Performance Inefficiencies

Many database administrators focus on memory settings, wait events, and tuning SQL when diagnosing performance issues, they oftentimes overlook storage problems. Embarcadero Space Analyst not only identifies storage problems that can cause a database to go down, but also pinpoints space situations that are keeping a database from performing at peak efficiency. After bringing such problems to light, Embarcadero Space Analyst can then fix any found storage problems and immediately elevate a database's performance levels.

Embarcadero Space Analyst visually identifies and corrects all space problems through its powerful set of storage diagnostic facilities.

• Review the reorganization candidate summary for both tables and indexes to immediately identify object storage characteristics that are contributing to reduced database performance.
• Pinpoint space-related performance inefficiencies with intelligent filtering mechanisms.
• Determine wasted space in objects through Space Analyst's diagnostics, which show the percentage of unused space consumed by tables and indexes.
• Identify and diagnose the severity of table chaining/migrating/forwarding by viewing each table's chained/forwarded row ratio.
• View Oracle deleted index leaf row statistics that help identify index fragmentation levels.
• Understand object extent space proximity through Space Analyst's powerful Oracle tablespace and SQL Server database file maps.
• Reorganize any object, no matter the complexity with smart space management wizards.
• Schedule all reorganization jobs for later execution with Microsoft's Task Scheduler.

Intelligent and Integrated Feature Set

Embarcadero Space Analyst is fully integrated into Embarcadero DBArtisan so you can perform all your storage management duties, as well as other cross-platform database work, in one place.

• Build a large reorganization job with Embarcadero Space Analyst while continuing to perform other tasks within DBArtisan.
• Create smart reorganization jobs that automatically detect and eliminate object fragmentation problems. Build once, schedule once, and automate.
• Schedule all tablespace or object reorganization jobs on any UNIX, Linux, or Windows machine using Windows Task Scheduler.
• Create database integrity jobs that automatically notify you if any problems are found in your critical databases.
• Automatically build HTML analysis reports, which document all the performance inefficiencies found inside designated tablespaces, in HTML format.
• Customize thresholds for identified space problems.
• Edit any storage structure or object using DBArtisan's object editors.

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