This article is contributed. See the original author and article here.
Whether it’s for reporting and offloading queries from production, there are things you need to keep in mind when using a Geo Replicated Azure SQL Database Readable Secondary. Discuss with MVP Monica Rathbun the challenges when it comes to performance tuning, what to keep in mind, and what to expect.
Resources:
Offload read-only workload to secondary replica of an Always On availability group
Best practices with Query Store
Best practices with Query Store
Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.
Recent Comments