## 4.6.4  Analysis Tools in SAP HANA Web-based Developer Workbench
There are a number of tools available for application performance analysis in the SAP HANA Web-based Developer Workbench.
## SQL Console
The extended SQL Console (part of the Catalog perspective) supports implicit and explicit performance measurement while executing a SQL statement. It allows you to easily acquire sound measurement data and to assess whether a SQL statement is problematic.
Implicit performance measurement can be triggered via F9 run command and provides execution time information for the database, XS, and UI layers. Additional information to judge the measurement quality like table locks and system alerts is also provided. Detailed performance analysis supports the repeated execution of statements thus allows you to check whether performance characteristics are stable.
You can use this feature to quickly check SQL performance and to determine whether the observed poor performance is caused by system load or variability.
## Expensive Statements Trace
The expensive statements trace in the Trace perspective allows you to quickly analyze how the SQL layer of your SAP HANA system is used (globally or within a specific session/application). It allows you to analyze if the SAP HANA database is used effectively and efficiently for a given application.
The expensive statement view supports filtering for passport-based application sessions - if the trace is configured accordingly by the system administrator and you run your application with SAP passport. For each statement you can see metrics such as start time, number of processed records and many more.
Furthermore, a statistical summary is provided that gives insight on the overall SQL load. It details metrics such as:
- Number of statements executed
- Number of unique statements executed
- Number of result records
Last, for each unique statement summary statistics are shown that detail the frequency of their usage as well as aggregated duration metrics.
You can use the expensive statement trace to analyze:
- the overall SQL load in your current system
- the SQL interaction of a specific application, for example, to figure out if an application that is not currently performing well due to an issue on the application layer or on the database layer.
## Immediate Database Performance Feedback
This feature is part of the Immediate Feedback context in WebIDE.It provides a performance overview of all SQL statements which are executed during an Immediate Feedback session, thus helps application developers to immediately understand the number and performance of their DB-related statements.
The Database Performance overview provides 3 metrics for each SQL statement: step, statement and execution.
- Step: the actual immediate feedback step in which a SQL statement was executed
- Statement: the SQL statement
- Execution time: the execution time of the statement (in milliseconds)
You can use this feature to understand the performance behavior of the SQL statements (for example, finding expensive statements that belong to a particular function) and exploit this understanding for possible further performance investigations, like subsequently taking a dedicated measurement using the SQL Console.