0

I'm trying to see the current setting for read-scale out in the Azure Portal.

The document says:

You can manage the read scale-out setting on the Configure database blade.

I'm unable to find any "Configure" option in the menu on the left in the SQL Managed Instance, or for individual DBs.

This is what I have available:

enter image description here

Where can I find this option?

The pricing tier for the SQL Managed Instance is:

Business Critical Standard-series (Gen 5) (2048 GB, 24 vCores, Geo-redundant backup storage)

David Klempfner
  • 8,700
  • 20
  • 73
  • 153
  • The read scale-out radio button appears on the pricing tier page. I only see it when selecting business critical SKU for VCore - not standard (though this is for SQL Database not managed instance) – Martin Smith Jul 04 '22 at 05:47
  • Seems clear from here https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql that same applies to managed instance – Martin Smith Jul 04 '22 at 05:49
  • I updated the question, I'm actually using Business Critical Standard-series. Can you provide a screenshot? I can't see that option. – David Klempfner Jul 04 '22 at 07:25
  • I don't use managed instance and don't fancy provisioning one to provide a screenshot. For SQL database it appears here https://i.stack.imgur.com/FLM7c.png but only when a compatible service tier is selected – Martin Smith Jul 04 '22 at 07:45

2 Answers2

0

Read scale-out is enabled by default on Premium, Business Critical, and Hyperscale service tiers. For Hyperscale, one secondary replica is created by default for new databases. Read scale-out cannot be enabled in Basic, Standard, or General Purpose service tiers. Read scale-out is automatically disabled on Hyperscale databases configured with zero replicas.

Refer official document: Use read-only replicas to offload read-only query workloads

Utkarsh Pal
  • 4,079
  • 1
  • 5
  • 14
  • Thanks for your answer but this doesn't answer my question. Just because something is enabled by default doesn't mean you can't change it. – David Klempfner Jul 06 '22 at 07:48
0

This isn't located under the "Configure" blade. You can manage the read scale-out setting in the "Compute + Storage" blade - but only if you are on Premium, Business Critical or Hyperscale service tiers.

Andreas Butze
  • 131
  • 1
  • 4