Oh... I forgot to mention that ColdFusion caches IP addresses. During down time, you need to: 1. Stop the ColdFusion Service 2. run ipconfig /flushdns 3. run ipconfig /registerdns 4. run ping yourSQLServer and you should get back the new IP 5. Start the ColdFusion Service
Make sure that in the ColdFusion Administrator you are using the name of the SQL Server and not the old IP address. I think this will solve your problem. Ryan On Tue, Jun 17, 2008 at 8:42 AM, Ryan Duckworth <[EMAIL PROTECTED]> wrote: > 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:307604 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
