Running SQL Server on a web server

Question

Is it good, bad, or careless to run SQL Server on your web server?

I am using Server 2008 and SQL Server 2005, but I do not think this is important for this issue.

Answer 1

For small sites this does not really matter. However, as the load grows, this scale is really terrible and faster than you think:

• Database servers are built on the basis that they "own" the server. They sell memory for speed, and they easily use all available RAM for internal caching.
• , - , IIS SQL , , . IIS , SQL Server CPU ..
• , , , - , .
• , SQL !

, , , , PostgreSQL. IIS PostgreSQL , IIS + SQL Server - ...

Answer 2

, , ... , , .

, , . .

, . : , SQL Server 2005 , - ( , ), , Sql Server Management Studio :

• ""
• " " , .

, SQL Server RAM- . , . , .

. , , , , .

Answer 3

, - sql.

, .

Answer 4

, , . , . , .

:)

Answer 5

- , .

, , , , .. , - . -, - , sql .

, .

- , , ?

Answer 6

. ( ). : -, , ..

Answer 7

I have seen this problem again and again. The correct answer is to put SQL Server on one machine and IIS (web server) on another. Your money will go to a SQL Server machine, because to support an efficient server you need to get the right drive system and RAM, but a web server can be a significantly reduced and less expensive device with only a mirrored set of disks.