DB PowerStudio XE2, DBA Edition with Analyst Pack is a highly-intuitive toolset that helps simplify cross-platform database administration and performance tuning. DB PowerStudio XE2 comes complete with support for all popular DBMSes, including Oracle, SQL Server, Sybase ASE, DB2, and more. Designed for DBAs that work in mixed DBMS environments, DB PowerStudio XE2 complements native tools with critical capabilities such as database change management and SQL optimization and tuning.
DBAs can now take their database administration capabilities to the next level. Whether it’s producing on-the-fly, DBMS-specific language conversions or creating new users across the entire enterprise, consistent workflows make it easy to extend one’s expertise into less familiar DBMSes. DB PowerStudio XE2’s deep tooling offers unique capabilities. Visual diagnostics not only help pinpoint problematic queries, but also determine the best solution. A Visual SQL Tuner can save hours or days of time when tuning problematic SQL statements. And deep change management functionality not only successfully coordinates database changes across the development life cycle, but also enforces database configuration standards.
DB PowerStudio XE2 provides DBAs with Embarcadero’s industry-leading XE2 database tools at an unbeatable value.
The Analyst Pack not only provides insight into current database health, but also where each database is heading in the future:
The Space Analyst provides analysis of database space information to pinpoint space-related exceptions and provides assistance in diagnosing and reorganizing storage inefficiencies using an intelligent reorganization wizard
-
The Performance Analyst provides intelligent analysis of real-time database and OS performance diagnostic information to troubleshoot and remedy performance problems
-
The Capacity Analyst collects and stores key database metadata and performance metrics and performs trend analysis to forecast database growth and usage
DB PowerStudio XE2 provides DBAs with Embarcadero’s industry-leading XE2 database tools at an unbeatable value.
This DBA Edition with Analyst Pack includes:
-
DBArtisan XE2 with Analyst Pack – the industry’s premier database administration tool with advanced Performance, Space and Capacity Analysts
-
DB Optimizer XE2 – visually profile key metrics inside the database and optimize SQL using the Visual SQL Tuner
-
DB Change Manager Enterprise XE2 – simplify, automate, and report on database changes
DB PowerStudio XE2, DBA Edition with Analyst Pack provides DBAs with everything they need to:
-
Work with multiple DBMS brands and versions from a single toolset
-
Develop, test, profile and tune SQL in an easy-to-use IDE
-
Eliminate performance bottlenecks in production databases and applications
-
Adopt reliable, repeatable and trackable database change management best practices
-
Ensure database performance and compliance
Enjoy these DB PowerStudio XE2, DBA Edition with Analyst Pack capabilities:
Simplify Database Administration and Change Management
-
Save time with its highly-visual, intuitive user interface that streamlines and automates common and repetitive tasks
-
Easily carry out complex actions such as schema extraction, schema migration and data load and unload
-
Compare a live database to a schema or configuration “snapshot” to quickly identify changes and correct problems
Maximize Database Performance and Availability
-
Eliminate performance bottlenecks by visually profiling key metrics inside the database (CPU, I/O, wait times), relating resource utilization to specific queries, and by helping you visually tune problematic SQL
-
Tune single statements or a batch of statements, including DML statements, stored routines, and entire SQL files
-
Use powerful database monitors, intelligent diagnostic information and strong drill-down details to quickly find and fix performance issues
Maintenance
Price above does not include Maintenance, which is required to be purchased on the first year. 1 Year Maintenance will be added to your shopping cart when you purchase the license.
Maintenance entitles customers to:
-
Unlimited technical support
-
All product upgrades
-
Closed beta programs
-
Product answer books/li>
DBMS Support
DBArtisan XE2, DB Optimizer XE and DB Change Manager Enterprise XE all include support for the following DBMSes:
-
Oracle 8i – 11g
-
SQL Server 2000 – 2008 R2
-
Sybase ASE 12.5 – 15.x
-
DB2 for LUW 8 – 9.x
DBArtisan XE2 also adds support for:
-
DB2 for OS/390 and z/OS 8.x and 9.x
-
MySQL 4.x and 5.x
DB Change Manager Enterprise XE2 adds support for:
-
DB2 for LUW 9.5
-
InterBase 2007, 2009
-
Firebird 1.5, 2.0
System Requirements
-
Windows 2003 - Windows 7; see product pages of individual products for more detailed system requirements information
File Size