Having SQL on the web server is generally not a good idea, especially if the sites are making heavy use of it. CF, IIS and SQL will be competing for CPU time and disk access. Ideally you should have separate servers. You can inprove performance on a single server by having a separate disk for SQL Server, and better still a separate disk for the databases, indexes and logs as well. A further step up is to have dual CPU's and to assign 1 CPU for SQL only. So you need to weight up whether doing this or having a dedicated server is more cost effective.
You could also install Fusion Reactor to help you termine if there are any CFMX issues. Russ -----Original Message----- From: Glenn Miller [mailto:[EMAIL PROTECTED] Sent: 04 August 2006 12:45 To: CF-Talk Subject: CF/.NET/SQL Express Server Install Question Good morning all, We're having some issues with server performance, and I wondered if anyone else has been beating their heads against a wall with this issue. We've got some brand new Dell servers, all configured with CF, .NET and SQL Express on the same machine. Currently I'm seeing decreased performance in serving time, JRun crashes, etc. on a daily basis to the point that uptime's falling below 75% with server alarms being thrown at least once an hour. I've done a sweep on all machines for attacks and/or viruses without any being found, and the only thing that I can think is that the 3 installed on the same box just aren't playing nice together... Anyone hitting this issue, know of any fixes, or have any ideas? At the moment the best plan that I can think of is to separate the 3 technologies to separate boxes and send them to their rooms... Any advice is greatly appreciated! Thanks! Glenn Miller ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248784 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
