Keith Sardone on 09 Feb 2018 00:49:20
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
- Comments (2)
RE: SQL Server FailOver Support Application Intent = Read Only
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.)
RE: SQL Server FailOver Support Application Intent = Read Only
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.