Post reply

Services on same or separate servers

  • February 1, 2008 at 1:16 pm

    #154105

    I am doing research on SQL Server 2005 and have not yet found any definitive answers to the question:

    Should the separate components/services (Database, Analysis, Reporting, and SSIS) be on the same server or on separate servers.

    While I continue to research this and try to find appropriate documentation, has anyone tested this? What did you find out? Has anyone seen any white papers, other documentation about best practices on installing the different components/services?

    -SQLBill

  • February 1, 2008 at 1:23 pm

    #774426

    Most of my servers have these services running on the same server without any issue. Database, Reporting, and SSIS. We don't have Analysis installed.

    SQL DBA.

  • February 1, 2008 at 1:37 pm

    #774434

    Y, it really just depends on how busy those services are going to be. There's nothing wrong with putting them on the same box as long as the box can handle it.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • February 1, 2008 at 1:56 pm

    #774450

    It all depends on your servers hardware strength and performance. mostly running them in single machine will be no problem unless something is messed up.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • February 1, 2008 at 3:43 pm

    #774493

    I would suggest to have the Reporting services installed seperatley, because RS needs IIS Enabled and for security reasons its not a good idea to have SQL and IIS running on the same box.

Viewing 5 posts - 1 through 4 (of 4 total)

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