Richard, You've only scratched the surface of what "could" be happening (ha). GC or other JVM related stuff could be happening... networking is also a good starting vector - assuming you are right about the SQL and I/O. For example, switches and NICs set to "auto" negotiate can sometimes exhibit this exact behavior if they are resynching for speed or duplex.
-Mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com E: mkru...@cfwebtools.com Skype: markakruger -----Original Message----- From: Richard Steele [mailto:r...@photoeye.com] Sent: Wednesday, July 17, 2013 2:12 PM To: cf-talk Subject: Slow running request We occasionally have a slow running request for no apparent reason. We have Fusion-Reactor and can see that there is no heavy traffic on the server. The same query run at a different time, runs just fine. The SQL db queries (as shown by F-R) are running very fast. I/O is also fine at the time this happens as can be seen in the performance monitor. How should we go about finding out the cause of these slow running requests? Thanks! Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356231 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm