Question

A company runs a mission-critical application on an Azure SQL Database in the Business Critical service tier. The reporting team runs heavy analytical queries that are currently competing for resources with the OLTP workload, causing latency for transactional users. The team wants to offload the reporting queries to a separate replica without provisioning any additional databases, incurring extra licensing cost, or changing the service tier. What should you do?

Accepted Answer

Enable read scale-out and direct the reporting connections using ApplicationIntent=ReadOnly in the connection string

Answer

Create a geo-replica in a secondary region and point the reporting team to that replica

Answer

Configure an auto-failover group and route read queries to the secondary

Answer

Scale the database up to a higher vCore count to accommodate both workloads