What is SQL trace tool?

[Former Member]

Please try to help me in answering this question

[Former Member · Accepted solution]

hi seetha,

this may help you,

Checking Database Access with SQL Trace Usage Certain combinations of database software, table

contents, and database Customizing can result in unnecessarily high access times. This is also the case

for outdated database statistics. This can have a negative effect on the performance of the mass

simulation.

Therefore, within the performance optimization of the mass simulation, you can use the Trace Requests (ST05) transaction to check database access and access times in the production system.

Procedure

1. In the production system, create a small number of simulation indexes (30 indexes, for example).

2. Call the Trace Requests (ST05) transaction. To do this, go to the SAP Easy Access Menu

and choose Tools ® ABAP Workbench ® Test ® ST05 SQL Trace.

3. Activate the trace. You can also do this in the production system as this function only logs

database accesses that have already been executed.

4. Bill the small number of simulation indexes.

5. Deactivate the SQL trace and display the list of accesses.

The list contains the executed database accesses and the access times Longer than average access times are marked in red. If a table contains a large amount of accesses marked in red, repeat the analysis. If the long runtimes continue, it may be necessary to perform a database

tuning for this table.

reward if helpful,

regards,

sravanthi.