none
It seems like a data warehouse. RRS feed

全部回复

  • you could use database mirror, one db for write,update,add, the another is for query only.


    专注于.NET ERP/CRM开发框架,C/S架构,SQL Server + ORM(LLBL Gen Pro) + Infragistics WinForms

    2018年6月11日 0:16
  • Hi yamoo863,

    According to your description, I think what you mentioned is read/write splitting.

    In many cases, read/write splitting will improve the performance significantly, especially in the high concurrency scenario. 

    I would suggest you considering AlwaysOn Availability Group if you are using SQL Server 2016 and later version, in these version, AG provides Load Balance Read-Only Routing across a set of read-only replicas, if you met a High-concurrent-Read scenario, this will improve the performance a lot.

    Best Regards,

    Teige


    MSDN Community Support
    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 MSDNFSF@microsoft.com.

    2018年6月11日 7:24
    版主
  • It depends on your business. If there is a lot of read and write blocking in the database, read and write splitting can significantly improve performance.
    2018年6月12日 2:51