Post reply

COM+ on SQL server

  • May 24, 2005 at 2:14 am

    #86402

     Hi Gurus,

    I need to know if its ok to use COM+ on a SQL Server or should it be on the Application server ie are there any performance or security issues with it on the SQL Server

    my thoughts are not to have COM+ running on shared server as it may affect all the other db's, but I need to give a reason why it can't be on a shared server or any server with SQL on it.

     

    Any pointers towards this is welcome


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • May 24, 2005 at 2:59 am

    #560696

    SQL Server always 'prefers' to be alone on a machine. That way it is easier to configure and optimize the server for SQL Server. But it depends on what your COM+ apps will be doing. Placing all of your business logic there might not be a good idea, but placing the data access layer (or parts of it) could be. But there is no easy answer like yes or no (except for the "yes, it is ok to place com+ apps on a sql server machine as it will not blow up from it")

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • May 24, 2005 at 3:10 am

    #560699

    Hi Chris,

    Thanks for the update


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply