Re: Slow running request
On Wed, Jul 17, 2013 at 3:11 PM, Richard Steele wrote: How should we go about finding out the cause of these slow running requests? Rick - Ever get to the bottom of this? -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| 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:356245 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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:356227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Slow running request
On Wed, Jul 17, 2013 at 3:11 PM, Richard Steele r...@photoeye.com wrote: 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. You say that same query run at a different time, runs just fine and SQL db queries (as shown by F-R) are running very fast. So is any database query ever running slow? Fusion Reactor should show the query time for the slow running request vs the entire pagetime. What are those numbers? Is the DB taking most of the request time for this slow request or no? -Cameron ... ~| 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:356228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Slow running request
if you perform a stack trace on the slow requests while they are running this will tell you what it is doing at the time. On Wed, Jul 17, 2013 at 8:18 PM, Cameron Childress camer...@gmail.comwrote: On Wed, Jul 17, 2013 at 3:11 PM, Richard Steele r...@photoeye.com wrote: 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. You say that same query run at a different time, runs just fine and SQL db queries (as shown by F-R) are running very fast. So is any database query ever running slow? Fusion Reactor should show the query time for the slow running request vs the entire pagetime. What are those numbers? Is the DB taking most of the request time for this slow request or no? -Cameron ... ~| 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:356229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Slow running request
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