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!
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.
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.
Asked:
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 Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
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.