Dynamic SQL statements The main purpose of a BI system is to return the answers for analytic queries. Therefore, it is crucial to keep track of the queries that the BI system is running and how they are performing. The best starting point is the Dynamic SQL Statements pane (Figure C-14) in the Statistics Details window. It shows you each statement that was recently executed along with such key properties as number of executions, compile time, and execution time. Figure C-14 Dynamic SQL statements Application monitoring and tracing Applications are a crucial element to monitor in BI environments because they typically execute long running queries. PE provides a special view for application specific metrics that can be accessed by clicking the Application Summary from the PE System Overview window. The window that opens shows a list of all active applications and includes a couple of important performance metrics (Figure C-15 on page 538). You can see all details about a certain application by double-clicking it. The Application Details pane opens, which can be used in a manner that is similar to the Statistic Appendix C. DB2 Performance Expert For Business Intelligence 537