Customer Engagement & Dynamics CRM Forum

Does CRM support SQL Read-Only Routing?

  • 1.  Does CRM support SQL Read-Only Routing?

    SILVER CONTRIBUTOR
    Posted 10 days ago
    We have two SQL servers set up in a High Availability group with an availability listener behind our Dynamics CRM 2016 on-premise deployment.  Does anyone know if CRM supports Read-Only Routing, or "Read Intent", where the secondary SQL replica can be used for reads?  I believe this equates to including the following in the Connection String:
    ApplicationIntent=ReadOnly

    Reference:
    Configure Read-Only Routing for an Availability Group (SQL Server)
    Microsoft remove preview
    Configure Read-Only Routing for an Availability Group (SQL Server)
    To configure an Always On availability group to support read-only routing in SQL Server, you can use either Transact-SQL or PowerShell. Read-only routing refers to the ability of SQL Server to route qualifying read-only connection requests to an available Always On readable secondary replica (that is, a replica that is configured to allow read-only workloads when running under the secondary role).
    View this on Microsoft >


    Thanks for any input.
    #Technical #SQL #Admin

    ------------------------------
    Mike Power
    Senior CRM Solutions Developer
    American University
    Washington DC
    ------------------------------