Friday, June 23, 2017

Microsoft Dynamics 365 Local Business Data aka On-Premise - Database Topology

Greetings

As you know Microsoft have release Dynamics 365 LBD - On premise version.

Dynamics 365 for Finance and Operations, Enterprise edition (on-premises) system requirements

About Database the main question is use SQL Server 2016 Standard or Enterprise Edition.
Obviously, refer to the Microsoft link in order to check the features supported by the SQL Server editions.

In a medium and not complex Project, my suggestion is to use the Standard Edition.
With the standard version is possible to setup an Always On Availability Group Cluster with a limit of two replicas (Primary and Secondary).

From a Business Intelligence perspective, we can setup a SQL snapshot on the Secondary replica and link to the snapshot the Reporting activities.

Stay Tuned!


2 comments:

anegis consulting said...


Nice post. I was checking constantly this
blog and I'm impressed! Very helpful information particularly the last part :) I care for such information a lot. I was looking for this particular info for a long time. It follows your previous guideline for post length as well as clarity

Sandra Johnson said...


Would you like to learn more about Microsoft Dynamics 365 and how it allow to your business to build ?.If you like to learn more about Micosoft Dynamics 365 and its functionality you can visit at Microsoft Dynamics 365 Overview.