Defining and running queries

You can use the query facility to define performance-management queries to run on the Statistics and Accounting tables in the Performance Warehouse database.

For example, Accounting tables contain performance data that shows how many resources are consumed by the applications. Appropriate queries on the ACCOUNTING table can help you achieve performance improvements. A set of queries is provided. They can be run as they are but you can also define and save your own queries.

You always start on the Performance Warehouse window. In the System Overview window, click the Performance Warehouse toolbar button. to start Performance Warehouse. The Performance Warehouse window is displayed.