I've got a client who has asked me to move a SQL Server database from one server (the web server) to a separate server.
Everything is working well when they database is on the same machine. However, when I moved the db and modified the DSN to point to the remote SQL Server (different box in the same rack) I'm finding the application is running really slow. I have the CF thread pool limit set to 10 threads right now but a lot of the threads are running very slowly now and if I stack trace them in Fusion Reactor, I see stuff like this: http://cfm.pastebin.com/d53dc3ada Particularly, if I stack trace a request over and over again I see this line changing: waiting on <0x1372a7a> (a coldfusion.server.j2ee.sql.pool.JDBCPool held by thread 373, jrpp-130 So it would appear that something is blocking many of the requests but I can't tell what. Additionally, if I go into SQL Server Enterprise Manager, I'm seeing database locks for both CF processes that are connected to the db. If I look at the details of the database locks, the last SQL batch transmitted is: SET TRANSACTION ISOLATION LEVEL READ COMMITTED So maybe these database locks are causing it, but I'm not sure where those are coming from.... NOTE: This application is fairly active, even at 6:00 am EST. It's running on CF 8 *STANDARD* on Windows SErver 2003. Anyone have any suggestions for me for things to look for? -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
