About Read-Only replicas

Dynamics 365 ERP - Development

Dynamics 365 Business Central On-Premise and SaaS backend structures are not the same, with SaaS backend using Azure SQL databases in Elastic Pools.
Elastic Pools offer shared resources and performance elasticity, optimal for cost-saving large database hosting.
Dynamics 365 Business Central supports redirecting calls to a read-only replica for specific objects like Pages, Reports, and Queries by specifying DataAccessIntent property.
Read-only replica capability for Dynamics 365 Business Central was introduced in the 2020 Wave 1 release, allowing for offloading read transactions to improve performance.
On-premises read-only feature requires SQL Server Enterprise Edition, while online sandboxes do not have this capability.
Business Critical tier in the vCore purchasing model for Azure SQL Database offers read-scale replicas for improved availability and performance.
There is currently no telemetry signal to indicate if a read-only replica is available, and probing methods have not been successful in determining its presence.
Decoupling read workload into a replica can be beneficial for scenarios with heavy API usage or long-running read-only reports, but identifying the availability of a read-only replica remains a challenge.

Registered users can view the full text for FREE!