Wednesday, January 26, 2011

SQL 2008 and IIS 7

should I run sql 2008 and IIS7 on the same server with 12GB of RAM? This is a high end Dell server.

  • If the question is "will they work together on this server?" the answer is yes. In fact, installing IIS on SQL servers is a very common practice in the context of SQL Server Reporting Services. Even on a Server 2008 R2 machine with only 2GB of RAM and a single-core processor, you could install both and they would play well together.

    If the question is about performance, the answer is exactly what you would expect: "it depends." How many concurrent users do you expect? How many IOPS? What kind of work is the server doing?

0 comments:

Post a Comment