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
Post a Comment