Mirror SQL Azure via readonly replica

[ClinDev]

Hello 

We are using a Premium tier P1 SQL Azure database, so we have a readonly replica. When we try to mirror that in Fabric, the connection string window has no option to put the connectionstring. It also does not have the option to select "readonly". This is the screen I am getting in fabric.

I have 2 issues

1. How do I pass the connection string to the readonly replica in Azure?

2. While the mirroring is going on, the DTU of the source database in Azure shoots up. My worry is that while syncing is going on the source database becomes unresponsive and can no longer be used. Is this expected that the DTU of the source database will shootup when syncing starts?

[Anonymous]

Hi @ClinDev ,

To connect to a read-only replica in Azure SQL Database, you need to include the ApplicationIntent=ReadOnly parameter in your connection string.

Read queries on replicas - Azure SQL Database & Azure SQL Managed Instance | Microsoft Learn

DTU will go up, consider off-peak synchronization or temporary capacity expansion.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[ClinDev]

Hi

Thank you for that, but I meant how do I point to that readonly replicae in microsoft Fabric? As I showed in the screenshot above, there is no option in the UI in Fabric when connecting to SQL azure to point to readonly. 

[Anonymous · Accepted solution]

Hi @ClinDev ,

It's currently a preview version, and may not have connection types, but try making the connection. Connections are listed in the documentation for reference:

Tutorial: Configure Microsoft Fabric mirrored databases from Azure SQL Database (Preview) - Microsof...

For more questions about mirroring SQL Azure you can refer to:
Frequently asked questions for Mirroring Azure SQL Database in Microsoft Fabric (Preview) - Microsof...

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.