none
What names did you use for your servers and instances in your Enterprise Data Warehouse Environments RRS feed

  • Question

  • Following the Kimball patterns I was wondering if I should name the servers to sort of match.

    So for the development environment I might go with

    EDWSQLBackroomDEV

    EDWSQLFrontroomDEV

    EDWSSASDEV

    OR

    EDWSQLETLDEV

    EDWSQLPresentationDEV

    EDWSSASAnalyticsDEV


    And now that NUMA issues with SSAS aren't an issue anymore is anyone putting SQL Server and SSAS on the same box? So the server might be laid out as EDWFrontroomDEV\Presentation

    EDWFrontroomDEV\Analytics

    Thoughts?

    Friday, December 13, 2019 2:53 PM

All replies