Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL and IIS on the same Box?


SQL and IIS on the same Box?

Author
Message
sid18in
sid18in
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
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
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: Administrators
Points: 35984 Visits: 18728
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
My Blog: www.voiceofthedba.com
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: Administrators
Points: 35984 Visits: 18728
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
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search