none
Load Data Mart parallel RRS feed

  • Question

  • Hi,

    What is the best practice for decoupling a DataMart (SQL2014) which is filled several times a day by the DWH via ETL load. The goal is that the end user is not impaired in terms of performance during a load.
    One option would be Scalable Shared Database. Or are there even more elegant solutions for this? Replicate, Cloud, Stretch DB ?  More than 20 Fact-Tables; all Layer on one Server;
    Regards
    Nicole
    Monday, September 3, 2018 2:20 PM

Answers

  • Hi Nicole44,

    -->>The goal is that the end user is not impaired in terms of performance during a load.

    In this scenario, you would consider the SQL Server High Availability. An availability group supports a replicated environment for a discrete set of user databases, known as availability databases. You can create an availability group for high availability (HA) or for read-scale. Then you could configure read-only routing for secondary databases.

    See: Configure Read-Only Routing for an Availability Group (SQL Server)

    Also please have a check:

    Features and Benefits of AlwaysOn Availability Groups

    Check if this helps.

    Regards,

    Pirlo Zhang 


    MSDN Community Support<br/> Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:MSDNFSF@microsoft.com">MSDNFSF@microsoft.com</a>.

    • Proposed as answer by Pirlo ZhangModerator Thursday, September 6, 2018 6:52 AM
    • Marked as answer by Nicole44 Thursday, June 13, 2019 5:52 PM
    Tuesday, September 4, 2018 8:09 AM
    Moderator