Does the web server have 1 or 2 network cards? If only 1, it is contending with all the web traffic. 2 GB nics in the web server and 1 GB nic in the SQL Server should solve the problem.
The default isolation level is READ COMMITTED, so that looks normal. When you find a thread in Fusion Reactor that is taking a really long time, capture the stack trace and email it to me. Hope this helps. Ryan On Mon, Jun 16, 2008 at 5:25 AM, Rick Root <[EMAIL PROTECTED]> wrote: > 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:307602 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
