DHarmon1
2 years agoNew Member
Status:
New
Allow connections from Data Factory to Azure SQL DB read scale-out replicas
https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql As part of High Availability architecture, each single database or elastic pool database in the Premium and Business Critical service tier is automatically provisioned with a primary read-write replica and one or more secondary read-only replicas. The secondary replicas are provisioned with the same compute size as the primary replica. The read scale-out feature allows you to offload read-only workloads using the compute capacity of one of the read-only replicas, instead of running them on the read-write replica. This way, some read-only workloads can be isolated from the read-write workloads, and don't affect their performance. The feature is intended for the applications that include logically separated read-only workloads, such as analytics. In the Premium and Business Critical service tiers, applications could gain performance benefits using this additional capacity at no extra cost. I would like to use the Azure Data Factory in Microsoft Fabric to copy over large tables from our production databases for the initial load of a data warehouse. Since this is a copy operation, I would like to use the read scale out instance so that I do not impact the production database. However, the ADF Connector for an Azure SQL Database does not provide the functionality to set ApplicationIntent=ReadOnly in the connection string so that I can connect to the read scale out. The ask is to provide a check box in the Azure SQL Database connector that will add the configuration option "ApplicationIntent=ReadOnly" to the connection string so that I can connect to the read scale out instance and not impact my production databases.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Allow Managed Private Endpoint to be disabled/enabled per notebook
Could notebooks have an option to use or not use the workspace's Managed Private Endpoint (MPE)? MPE can significantly increase notebook startup time, even for notebooks that don't need private conn...frithjof_v10 hours agoCommunity ChampionNew20Views1like0CommentsMatrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente1 day agoRegular VisitorNew80Views6likes1Comment