> You don't say what DB it is, but I'd start by > running a request profiler against it. See if > the slowdown is on the DB side or the CF side.
Yeah, that was all covered in the original post I think. It's MS-SQL and the same query run in query analyzer or from another one of our web servers (identical data source configuration) was running just fine with no slowdown. Only a query from a specific ColdFusion server to a particular database table (same table on any one of the several dozen databases with the same schema that we run) would run slowly. Unfortunately, the table in question was includes as a join from a lot of queries on the server, so it was having quite an impact on that server. We ended up rebooting that web server and after it came back up everything was fine and the queries were running normally again (darn Windows!). It was really bizarre, and I hope it doesn't come back to haunt us again. As for disk space, we monitor free space on all drives on all servers as part of normal operations, and there is gobs of free space on the database server (according to monitoring and confirmed by checking the server itself. Good thought though. Thanks for the suggestions everyone! -Justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322768 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
