• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

System Setup suggestions

Hello,

I’m after some advice please.  I need to spec out a system for some software.

The software itself is fairly light weight.  It delivers the service via IIS (server 2008 R2) Along side it needs to connect to a MS SQL database and lastly there needs a file store area.

At the moment these three elements sit on the same physical server.  It has worked okay, but this doesn’t strike me as being the most resilient setup.

The new policy is to use virtual machines.   Given these high level requirement do you think a single server is the best option, or would it be better to maybe have two servers.  One for the app + files and another as a database server?

Presumably at the very least the drive should partition to separate OS from file store?
Appreciate any suggestions as to what the best setup should be.
0
andyw27
Asked:
andyw27
1 Solution
 
Paul MacDonaldDirector, Information SystemsCommented:
All things being equal, there's nothing wrong with virtualized servers, but you'd want more than one host if the application is mission-critical.  

Another approach to take would be to set up two identical physical servers, put IIS on both with Network Load Balancing to distribute web requests appropriately.  Cluster the SQL Server so it runs on both in an Active/Passive mode.  Then use DFS to keep the web site files and file server files on each server in sync with each other.

Either approach requires an external storage mechanism (SAN) to keep things going.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now