TRace Queries running on a SQLBase server

[jipsi]

We have a packaged application running and have some serious performance problems.
How do capture the queries running in the server? The queries are mostly dynamic queries (not store procs) and we don't have access to the source code. Is there any way I can capture the SQL? Does audit capture SQL as well (not store proc)?

Any ideas?

Regards

 

[ManuelPallas]

There exists a little application that you can find on the Iceteagroup homepage. The application is called SQLPerformance. All statements will be traced in a overview with some informations like the used indexes, the time and count of execution..nice tool..try it, i think its freeware