Azure Elasticpool Premium Read Scalet-Out

Question

Hello

How are you?

I have a question, is it possible that now the Read Only or Read Scale-Out option can be enabled for Azure data bases that are associated within a Premium Elastic Pool?

Now I see that the databases that are within this type of Premium Elastic Pool have the option to enable read only

Thanks

Answer 1

Hi Fernando Gutierrez,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

Yes, it is possible to enable the Read Only or Read Scale-Out option for Azure databases that are associated with a Premium Elastic Pool.

Read scale-out is enabled by default on Premium, Business Critical, and Hyperscale service tiers for SQL Database. However, it cannot be enabled in Basic, Standard, or General Purpose service tiers. Additionally, read scale-out is automatically disabled on Hyperscale databases with zero secondary replicas.

For single and pooled databases in Azure SQL Database, you can disable and re-enable read scale-out in the Premium or Business Critical service tiers using the Azure portal and Azure PowerShell. These options are not available for SQL Managed Instance, as read scale-out cannot be disabled.

Note: For single databases and elastic pool databases, the ability to disable read scale-out is provided for backward compatibility. Read scale-out cannot be disabled on Business Critical managed instances.

Please refer to the below mentioned links for more information.

https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/database-read-scale-out-configuration?source=recommendations

I hope, This response will address your query and helped you to overcome on your challenges.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.