is it really important to put application and database on different servers (for asp.net and sql-server)? [closed]

A开发者_如何转开发s it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 12 years ago.

I heard that for java (jboss + any DB) it's really important because there is going to be lot of problems, but for .net not so much, is it ?

---

It's all a matter of scalability. If you have an application with a very small userbase, small database with only a little bit of data, and basic application logic (like simple CRUD functionality), you probably aren't going to gain very much by separating them. In an enterprise environment, with a large userbase, a gigantic database, and complex application logic, there will definitely be a benefit to physically separating them.

---

I always put application and database on different servers for production. This prevents a high load on one part of the structure from cascading into problems for the other part, which just starts to feedback on itself and bring the whole system to a screeching halt.

---

This entirely depends on your environment, the hardware you have and the load you anticipate on your database. SQL server is quite resource hungry and depending on your circumstances, it may well help to have them separate.

---

In environments like LAMP or WAMP (Linux/Windows + Apache + MySQL + PHP) servers they are usually all on the same machine. As the previous commenter said, it's more to do with your expected load.

One other reason the DB is often split is for security concerns. Many security architectures have the DB servers hidden behind a separate firewall (PCI requires this).

And another reason (it's early and I'm making this up as I'm going) is if your DB server will be used by multiple applications, or maybe your one application running on multiple servers. Typically a well-built DB server can handle multiple app servers and client machines easily.