question

NikunjPatel-2604 avatar image
0 Votes"
NikunjPatel-2604 asked NavtejSaini-MSFT answered

How to scale out read only replica in SQL Manage instance for business critical tier?

In production we have SQL MI with business critical tier. As of now we used azure default read only replica for application to use read only query using "ApplicationIntent=ReadOnly" connection parameter.

Now we are planning to interduce new reporting tool so we need to add one more read only replica to intact performance of application.

For this we have following questions.
[1] How we can scale out one more read only replica for SQL MI?
[2] How we can differentiate connection between readonly replica1 and replica2.
[3] Is this required Geo replication features?
[4] What is additional cost for this?

We need something like below link.
https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

Thanks in advance.

Regards,
Nikunj

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NavtejSaini-MSFT avatar image
1 Vote"
NavtejSaini-MSFT answered

@NikunjPatel-2604

According to this document the read replica is definitely by default but it can have 0-4 replicas with geo-replication

89179-image.png

The cost is the 100 percent of the primary DB. So basically the cost for each replica will be same as cost for Primary DB.
89180-image.png

Please check the geo replication document and get back to us for any questions.

Regards
Navtej S



image.png (7.9 KiB)
image.png (25.4 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you Navtej for your answer. It helps a lot.

Quick question, Using Geo replication we can scale out read only replica in mange instance. If yes then what is difference between geo replication and instance failover group. I cant find Geo replication option in manage instance in azure portal.

Provide an input for point no 2 also.

0 Votes 0 ·

@NikunjPatel-2604

We are glad you found the information helpful and thanks for sharing the link. Regarding your follow up question please visit this link for more detail and let us know if you have follow up questions.

Regards
Navtej S


0 Votes 0 ·