SQL Server on IIS Box - HTML Forums

Bobba Buoy · 03-08-2009, 08:02 AM

I have a server running Windows 2003 Server. It has 500GB storage and 2 GB memory. I am only using 5 GB of storace so far. Currently my sql server is on a different box, which is working fine. However I am thinking I should put them both on the same machine since it is new and fairly robust. The problem is that SQL Server gobbles up lots of resources. Any advice? Does my new server have enough resources to handle both at least as good, if not better, than my current system?

Thanks!

BrayH · 03-25-2009, 11:38 AM

If you SQL is already running a high load I wouldn't recommend it. 2 gigs is kinda low to begin with for a web server that is going to be hosting many sites. I have the high availability solution with Server Intellect. Runs my sites and SQL very well. If you have higher than normal loads I recommend this.

mikeyp · 04-02-2009, 12:05 PM

This is a "depends" question. How much traffic are you expecting to get to this website? Is there going to be a ton of data stored in the MySQL server? A ton of reads? A ton of writes?

Bobba Buoy · 04-02-2009, 12:08 PM

Thanks to both of you. Your input is helpful. Based on what you have said I think I will leave it as is for now.