You will never get the best performance having them on the same server, but disks is the real bottleneck. As long as you have your databases running of a different physical disk than everything else then you can get away with having it all on one machine, more so if you can isolate the CPU's or cores to different processes. This does cause you a single point of failure though, so if CF for example canes the CPU then this will affect the database server as well.
If you can afford separate servers then get separate servers. This is less of an issue on VPS with say RAID 10 setup, as there always multiple disks being read/write to anyway, so the performance hit is no where near as bad, and in tests SQL Server has performed well in a VPS environment. Russ -----Original Message----- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Friday, January 14, 2011 9:55 AM To: cf-talk Subject: (ot) Server Setup Opinions I host approx. 5-6 dozen (small traffic) database driven CF sites on multiple servers and I am in the market for new server hardware. Since I last purchased hardware, the capabilities of server hardware has increased dramatically. That said, for those of you whose company hosts CF web sites, do you: A: Have a separate database server and a separate web server for 'X' number of sites? B: Have one server that is the combined database/web server for only 'X' number of sites? C: Have one 'mega' server that is the combined database/web server for all of your sites? D: Some other combo. Please explain. I guess I'm wondering if it is still frowned upon to combine the database and the web server on the same machine? Any responses would be appreciated. Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm