I'm hoping some system engineers or DB admins can answer this better than I can. Got a problem with one of our CF servers hitting a stored procedure.
If I execute this procedure manually from the SQL Server Console from my machine or one of the common dev machines, the execution time is 9 seconds. However, today we've been seeing warnings in the logs, on the CFSTOREDPROC tag in the code. Time of execution is being reported in the range from 32 seconds to 90 seconds. What are the possible causes for seeing a larger execution time? I thought that, perhaps, all DB connections are currently being used at the time of the call and none are released for that time period because the server admins have 5 application running in once CF instance. However, if that was case, we'd be seeing large timeout warnings for all 5 apps instead of just 1. I just can't think of what other factors could be involved. - Steve ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282822 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
