My company is planning on buying some tools for DB administration and a performance monitoring tool. What I'd like to know is, are there any tools out there that can capture all SQL, or at least negative SQL codes? We would like to be able to know which SQL statements are running longer than they should and if any SQL statements are failing because of a negative code. Of course we want all the other things involved in administration and performance, I'm just mostly curious about the SQL because the tools we've looked at so far don't seem to have that capability.

Thanks!

Consider Optim Performance Expert from IBM.