Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

SQL and IIS on the same Box? Expand / Collapse
Author
Message
Posted Tuesday, June 16, 2009 12:02 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 1, 2010 2:46 PM
Points: 11, Visits: 30
Hi David,

It seems I am a entry level developer, and not as experienced *** you to comment on your article. But would surely like to say this was the best article on the topic I am researching on IIS and sql on same box... I loved your article the way you explained all the issues...

I would like to get an advice from some one like you... I want to put a proposal to management for separating the iis and sql server...now after reading your article I am clear on that...but i would like to get a knowledge on how much hardware config is required for 2 separate boxes...

Let me give you some info on my websites running..i am using a Asp.net based CMS and we have many of our international websites like 15 websites running on the same server...which also has sql server in it....I just got to know that we have around 8000 hits everyday combining all the websites ( which are running on the same one server) Currently our config of the server is ...Intel Xeon E5430 @2.66Ghz..4 gb Ram..70 gb harddisk....We are running out of hard disk space and I have to download the backups daily and its very irritating.... I just joined this firm and feel with their growth they need the upgrade..On our website we have lots of images..

2 questions... 1-> do you feel current config is enough?
2->if we separate the box what should be the minimum config for both iis and sql server...

I would appreciate your help...

Thanks,
Sid
Post #735908
Posted Tuesday, June 16, 2009 12:34 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:32 AM
Points: 33,055, Visits: 15,165
Moving to SQL 2005 - strategies. Please don't post in author's forums.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #735930
Posted Tuesday, June 16, 2009 12:51 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:32 AM
Points: 33,055, Visits: 15,165
Ok, moved back. Doh! Didn't realize this was a continuation of another thread.

One note, if you are not asking a question on the article, you want to start your own thread. This isn't consulting, and it's a little inappropriate to ask a specific person for advice on your own issue.

As far as the config, it's hard to know what to recommend. The same size boxes for SQL will obviously give you more resources. you ought to be able to calculate disk space needs (mdf/ldf + 2 days backups at least and pad), for memory, get at least as much, it's cheap now.

CPU, go with something modern. You'd have to examine your system and determine how CPU bound it is now. If it's not, then you should be fine with the current CPU







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #735947
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse