Failover support has been added for AOHA SQL Server. Which is great. However, there is no option to set the Application Intent to Read Only. This routes the Connection String to the primary, placing the reporting load on primary, and leaving secondary unloaded. Can we have the ability to set the Application Intent to balance the server load? Thanks
3 Comments
- Currently I use OleDb.Query instead of Sql.Database to apply "ApplicationIntent=ReadOnly". but It force to use authentication by password. I would like to use OAuth2.
- Hoping to clarify for the OP and other commenter: Checking the "Enable SQL Server Failover Support" is functionally equivalent to using "ApplicationIntent=ReadOnly" in my experience. We use this setting religiously against Azure SQL Database Premium tier, and PowerBI consistently queries the secondary. (My request for MSFT is to make this checkbox checked by default. I can not conceive of a common scenario where you would not want to use the secondary.)
- Status added:Needs Votes
