asp.net - Amazon EC2 Windows: Should I have separate instances for my IIS and SQL Server? -


i have website (asp.net web application) hosted on iis on amazon ec2 "windows sql standard" instance, sql server on same instance well.

i wondering if better (strictly performance wise, i.e. site faster user) separate them 2 instances, 1 web application on iis, , 1 sql server.

the application uses entity framework 4 access , read/write database. workload wise, expecting there 1000 records (e.g. record customer, each orders, details, history, budget, payments, etc...) getting created daily.

server has 15gb memory, intel xeon cpu 2 @ 1.8gz. standing idle, sqlserver.exe using 300mb memory, , w3wp using 600mb memory. on single request, e.g. login, cpu usage sqlserver.exe goes 10%, , same w3wp.exe.

i know there lot of other details need go making such decision, not looking yes/no answer, hoping more considerations, past experiences, pros/cons, things think make better decision, , of course recommendations.

generally speaking, yes. consensus separate box each, said, operate lots of low/medium traffic sites both coexists happily on 1 box , there no issues.

if money not problem, separate them; if budget issue, separate them if have performance issue.

there bit of latency 2 boxes, if having performance issues, separating servers should more makeup latency loss.


Comments

Popular posts from this blog

javascript - Count length of each class -

What design pattern is this code in Javascript? -

hadoop - Restrict secondarynamenode to be installed and run on any other node in the cluster -