Solved

SQL and iis together

Posted on 2014-02-05
4
140 Views
Last Modified: 2014-02-09
Microsoft experts out there.
I am in a situation to spec a server/servers to host sql ,iis.
I was apporched by development team for this.
I sugest them to put all in one server, is it good idea to put iis and sql together?
0
Comment
Question by:sara2000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 40

Assisted Solution

by:Kyle Abrahams
Kyle Abrahams earned 167 total points
ID: 39836565
What's your application and what environment are you intending (production, dev, etc)?

They definitely *CAN* run together . . . the question is should they.

Now adays though I would buy a heavy duty server, install VMware on it, and then spin up machines as needed.
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 166 total points
ID: 39836644
I agree on the above. technically, nothing will say "you cannot".
performance-wise (and for other "best practice" reasons), better to have them apart.
0
 
LVL 16

Expert Comment

by:Surendra Nath
ID: 39836651
No, it is not a good idea, and this not the way the enterprise solutions work....

We generally recomend to put database (SQL Server) in a seperate machine (a VM maybe) and Web in a different server (IIS).

The reasons for this is also different,
As a DB Server Currently needs HIGH I/O throughput and high memory...
If a IIS Server needs a high network bandwidth...
0
 
LVL 1

Accepted Solution

by:
IT_admin_031 earned 167 total points
ID: 39836703
SQL is a heavy application that writes to disk often. Some state it should be on it's own hardware platform rather than a VM. With that said, I have VMs that host SQL.

It matters more about load - How many users/application reads/writes per second will occur.

For dev environments, especially if they are working on an application pool that will eventually go into production, it would be wise to scale down, but not beyond what would be expected from production. For example, your production system will be 10 web front ends to 2 SQL cluster nodes. This means your dev environment should be at least a 2 SQL cluster nodes (to properly mimic the expected cluster interactions) and 2-4 web front ends. If you have all of that on one box, and lots of activity, you will have high latency and poor performance.

If it will be for a small environment it can work on one server but latency can be pretty high and I'm not sure if you want to spend additional time helping developers out on a system that you under spec'd. Your best bet is to throw it back to these developers and find out how they are going to use it and how much load they will put on it. As Kyle stated, you can give them a new server, setup a hypervisor for it and create the servers as needed in a virtual sandbox environment. While this doesn't address the potential latency, it does allow the full creation of the developers expectations of how it will work in Prod.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question