FusionReactor or SeeFusion, and make sure you set up the jdbc passthrough so that you can see all the queries and how long they take to run. FusionReactor allows you to see all the queries that were on that page along with the execution time for each.
Russ > -----Original Message----- > From: Maureen Barger [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 22, 2006 2:54 PM > To: CF-Talk > Subject: Tools for determining bottlenecks > > We just started hosting an *extremely* busy site on a solaris box running > CFMXE 7.x with an Oracle 10g backend along with 2 MySQL 3.x databases. > There is a bottleneck somewhere and I am trying to determine where; I am > wondering if it is even the database drivers. I have Fusion Reactor > running and while it can tell me the slow requests, I am trying to > determine why they are slow. Are there any tools to monitor the throughput > of the jdbc or MySQL driver, especially the MySQL instance? The database > servers are relatively idle yet something is the bottleneck. > Thanks. > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250640 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
