I know it depends, but I am just curious what specifications others are using to run a simple site with a MS SQL Server back-end. What is recommended for the application, not the database?
+4
A:
If you're not talking about the database, I would say that running a simple MVC web application you would just need enough RAM to run whatever Windows OS you plan on deploying it under. You shouldn't need any more than the recommended amount.
So for example, here are the Windows Server 2008 requirements.
Joseph
2009-11-19 14:56:33
which would be better: 1 (1gbRAM) machine with sqlexpress and asp application OR 2 machines at .5RAM app and db separate computers?
zsharp
2009-11-19 15:05:47
I think separating a the database and app into separate machines would only gain you more of a security advantage rather than performance. Unless your app is performing very large queries.
James
2009-11-19 15:55:44
@zsharp for a simple app? I would say one machine, as James has indicated. However, for larger apps, you're going to need to scale, and that means you'll need to tier out your architecture.
Joseph
2009-11-19 16:05:40
A:
You can run a simple MVC site on Windows XP with IIS 5.1 and SQL Server 2005 Express. Here are the system requirements for Windows XP.
RAM is so cheap now I would go with at least 2 GB.
Dave Swersky
2009-11-19 14:57:02
+1
A:
Would have to agree with Joe, the recommended RAM for running the OS should be sufficient. However, when you start to use resource hungry tools like SQL Server I would always recommend adding at least 1 GB.
James
2009-11-19 14:58:47
@James Totally Agree. When you slap on SQL Server into the mix you're talking about a completely different kind of memory footprint needed.
Joseph
2009-11-19 15:00:18