January 23, 2002 at 3:26 pm
Is there any information available on why you should not install IIS on a SQL Server?
Rob DeMotsis
Sr. SQL Server DBA
Pier 1 Imports, Inc.
Rob DeMotsis
Sr. SQL Server DBA
January 23, 2002 at 3:52 pm
In addition to my original posting. I read somewhere a while back that there could be a conflict with SQL Server and IIS on the same machine that could cause performance issues.
Rob DeMotsis
Sr. SQL Server DBA
Pier 1 Imports, Inc.
Rob DeMotsis
Sr. SQL Server DBA
January 23, 2002 at 4:36 pm
Hi
I believe you wont have any compatibility issues for anything like that, but you may experience CPU contention. As an example, we use COM+ for all our business logic, under load, you will see my SQLServer and WebnServer box's cpu timebasically "follow" each other (ie around 30 to 40%) when on seperate boxes. POn our test and dev machines this is simply componded and the CPU hits around 60% to 80% under load (dual cpu).
Apart from very small apps, I always push for more than 1 server in prod. And make them scalable. In the end, even if its only 100 or 200 users, their wrath and loss of business because your server cant keep up is not worth the cost saving of a single server to run everything.
The only other issues with many servers = many fail points = good DR plan.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
January 23, 2002 at 4:45 pm
One thing that was an issue in NT4 was whether or not to configure the server to be optimized for Network Applications (SQL Server) or File Sharing (IIS). The way the two applications used resources were fundamentally different, though I don't believe this is to be as much of an issue in Windows 2000.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
February 5, 2002 at 5:38 am
The basics of it is SQL likes memory and CPU time but with IIS on the same server you create contention between the two fighting for resources (especialy if large number of users and databse activity).
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply