Post reply

Analysis and Reporting Services on same server?

  • May 10, 2007 at 12:50 pm

    #153577

    Normally if we are using Data Warehouse and Reporting Services, do we keep them on same server? but other than OLTP server.

     

    Data Sheet

  • May 10, 2007 at 2:29 pm

    #705664

    I would say it depends on your situation...mainly on size. Smaller scale stuff w/ less data and traffic require less isolation. From my experience I've always been running SSAS, SSRS, and SSIS on the same server that was seperate from the OLTP server and it has worked fine. A good next step would be to run all the SSAS and SSRS databases on one server and the actual applications services on another. Larger deployments would suggest using a cluster where you have several servers running each service separately in a virtual environment.

    Cheers,

    Ben

    Cheers,

    Ben Sullins
    bensullins.com
    Beer is my primary key...

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

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