Separate DB from Server or not
hey guys, this is my Dev machine configuration 2.8ghz P4 1 gig of RAM and SERIAL ATA 100 hard drives Windows Server 2000 For now, we have SQL Server running on a separate computer.I was wondering whether we should run them on the same server, or on a separate server.Security is not an issue.Performance is.There is alot of info traveling between CF and the database and we don't want to overload the network (I dont even know if it will even get to that), and maybe all that data going back and forth might cause a slight perfomance hit to the app. But also, the server might slow down if both DB and coldfusion are running!How do you have your dev set up? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Separate DB from Server or not
Buy two gigabit network cards, and attach the sql server directly to the cf machine.Problem solved. But since this is a dev machine, a presumably doesn't get too much traffic, I don't think you need to worry about it at all. - Original Message - From: brobborb [EMAIL PROTECTED] Date: Monday, March 1, 2004 10:14 am Subject: Separate DB from Server or not hey guys, this is my Dev machine configuration 2.8ghz P4 1 gig of RAM and SERIAL ATA 100 hard drives Windows Server 2000 For now, we have SQL Server running on a separate computer.I was wondering whether we should run them on the same server, or on a separate server.Security is not an issue.Performance is. There is alot of info traveling between CF and the database and we don't want to overload the network (I dont even know if it will even get to that), and maybe all that data going back and forth might cause a slight perfomance hit to the app. But also, the server might slow down if both DB and coldfusion are running!How do you have your dev set up? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Separate DB from Server or not
on a dev box it shouldn't be an issue, unless you are really, really hammering the bejesus out of the thing with a thorough load test or somesuch. If you have to buy anything to do this I'd pass until you know you need it. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 9:14 AM To: CF-Talk Subject: Separate DB from Server or not hey guys, this is my Dev machine configuration 2.8ghz P4 1 gig of RAM and SERIAL ATA 100 hard drives Windows Server 2000 For now, we have SQL Server running on a separate computer.I was wondering whether we should run them on the same server, or on a separate server.Security is not an issue.Performance is.There is alot of info traveling between CF and the database and we don't want to overload the network (I dont even know if it will even get to that), and maybe all that data going back and forth might cause a slight perfomance hit to the app. But also, the server might slow down if both DB and coldfusion are running!How do you have your dev set up? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Separate DB from Server or not
Nice dev box! It depends what you are developing, but for most cases it would be fine to run both SQL and CF on the same box. How many thousands of queries per second you plan to do, if you are warring? Anything under 1000/s of simple queries will not harm your server performance. Also, unless you have 25 developers CFMX should not complain. TK -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 1:57 PM To: CF-Talk Subject: RE: Separate DB from Server or not on a dev box it shouldn't be an issue, unless you are really, really hammering the bejesus out of the thing with a thorough load test or somesuch. If you have to buy anything to do this I'd pass until you know you need it. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 9:14 AM To: CF-Talk Subject: Separate DB from Server or not hey guys, this is my Dev machine configuration 2.8ghz P4 1 gig of RAM and SERIAL ATA 100 hard drives Windows Server 2000 For now, we have SQL Server running on a separate computer.I was wondering whether we should run them on the same server, or on a separate server.Security is not an issue.Performance is.There is alot of info traveling between CF and the database and we don't want to overload the network (I dont even know if it will even get to that), and maybe all that data going back and forth might cause a slight perfomance hit to the app. But also, the server might slow down if both DB and coldfusion are running!How do you have your dev set up? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
