Today, a customer asked how to run a query against the read-scale replica using SQL Server Agent in a Azure SQL Managed Instance.
In the following example, I would like to share with you how to achieve this.
In order to instruct how to use the read-scale feature I added the following parameter values for:
Finally, using, for example, the option OPENQUERY or running the query I was able to run my queries to the read-scale replica.
SELECT * FROM MyExample.UserDatabaseName.SchemaName.Table WHERE Id=1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.