SQL Performance
In the Problem Analysis user menu, you can find, among other things, tools for checking SQL performance.
Use these tools in combination with the analysis of database bottlenecks.
Prerequisites
Procedure
In the Database Assistant, choose Problem Analysis → SQL Performance.
...
Result
The following tools are available to you:
·
Command
Monitor
You can perform a short analysis with the command monitor, if, for example,
users have reported especially long-running transactions.
·
Resource
Monitor
You can use the resource monitor to create an overview of the SQL statements
that have used the most resources in a specified period.