Use primary node with applicationintent=readonly on Azure Sql database hyperscale tier

Erik Eriksson 1 Reputation point
2021-01-27T08:03:12.26+00:00

Hi,

We have a analytics api that is read only for our users. We use an Azure Sql database on the hyperscale tier with read scale out, however that primary node is just sitting there receiving new data every now and then. Is there any way to engage that besides using another connection string? I mean just because the application intent is just to read, why not use the primary node? I realize that there is a use case for just writing to the primary node, but there is also a use case for reading from it, but I cant see a way to do it.
We are thinking about writing our own load balancer, but I wanted to see if there was any easier way.

Thanks in advance!

/Erik

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-01-27T13:22:58.02+00:00

    @Erik Eriksson Welcome to Microsoft Q&A forums and thank you for your interest in Azure SQL Database.

    Power BI for instance doesn't write data to the primary node even when you use the connection string without a readonly intent.
    So, if you have any other light weight workloads/reporting solutions that can benefit from reading data from primary node, you can go ahead and use it.

    Please let us know if you have any further questions.

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

    0 comments No comments