Post reply

SQL Server and IIS

  • January 23, 2002 at 3:26 pm

    #158149

    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

    #422568

    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

    #422569

    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

    #422570

    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

    bkelley@sqlservercentral.com

    http://qa.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • February 5, 2002 at 5:38 am

    #423171

    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