A: Yes. Embarcadero DB Performance Center XE provides one summary view of all of your IBM® DB2®, Microsoft® SQL Server, Oracle®, and Sybase® databases. From this screen, you can see which databases are running smoothly, which ones are potential problem areas, and which ones have reached a critical point. You can also drill down on any database to gain more information about performance.

A: SQL Capture. Configurable 24x7 SQL capture automatically triggers a SQL capture session when there is a threshold violation. Session profiles drill down into the SQL statements for detailed performance metrics including process id, application name, and hostname to for root-cause analysis and pinpoint the exact cause of the performance issue.

A: The Health Index is a single indicator that communicates the overall performance level of every monitored database. By sampling critical statistics in the areas of memory, I/O, contention, space, network, objects, users, and SQL, Embarcadero DB Performance Center XE is able to quickly ascertain a database's complete performance picture. The result is one statistic that can be used to determine how well each database is performing. Each Health Index for a database can be customized, so that individualized thresholds and measurements that apply to each unique database scenario can easily be established.

A: Yes. In the latest version of Embarcadero DB Performance Center XE, you can export any information you wish into flat files, Excel, or even another database. This will allow you to create additional reports that you can share with management or other interested parties.

A: Embarcadero DB Performance Center XE finds the problem. DB Optimizer XE fixes it. DB Performance Center XE is a 24x7 monitoring system that helps you identify performance problems, even before they lead to down time. Once you have found the problem, you can use DB Optimizer to diagnose, and optimize poor-performing SQL. DB Optimizer eliminates performance bottlenecks by discovering data intensive or frequently executed queries, focusing in on specific SQL statements through query statistics (CPU, I/O, wait times), and optimizing any problematic statements.

A: DBArtisan and Embarcadero DB Performance Center XE are highly complementary products. DB Performance Center XE gives you a 24x7 monitoring system that helps you identify performance problems, even before they lead to down time. Once you have found areas for improvement, you can use DBArtisan to tune your databases to achieve better service levels. With DBArtisan Workbench, you can actually pinpoint problems in your code, actively manage space, and plan intelligently for capacity expansion. Within DBArtisan, you can use the embedded Web client to view almost all of DB Performance Center XE's metrics and global availability status.

A: Embarcadero DB Performance Center XE is a 24x7 monitoring solution. Unlike client-side monitoring solutions, DB Performance Center XE's server-side component maintains your settings and continuously monitors your systems. Also, DB Performance Center XE keeps all of your data in a central repository for easy query access.