Problem with a ColdFusion (Queries spend a long time to return)

Hy guys

My team have a problem with a Coldfusion (version 8,0,0,176276). Apparently this issue has a relation with queries that spend a long time to return some result, making the poll to open more connexions with the database until stop the application.

Actually the high number of connexions is a reflex of this issue, a consequence and the same way that is the fail on the application.

I would like to know if exist a way to debug the calls to database? this information will help my team a lot.

Thank you.

Herbert Dias