We have a database with about 500 stored procedures in it, and I'm finding a number have queries that are executing with non-indexed searches. As the user community on this application is increasing, this is becoming harder for the users to deal with. This is a legacy application in FB 1.5 so I don't have the luxury of upgrading it at this time. I'm looking for a tool or a technique to identify performance issues, particularly issues relating to non-indexed searches.

I took a quick Google search on this and found tools like FBScanner out there, but is there a generally accepted method or tool for detecting bottlenecks in performance such as non-indexed searching?

All advice is greatly appreciated.

Thanks
Myles