Skip to content

Commit f71e417

Browse files
Update hyperscale-named-replica-configure.md
Added the named replica optimization paragraph to keep same SLO as primary replica.
1 parent 0af24a4 commit f71e417

1 file changed

Lines changed: 9 additions & 0 deletions

File tree

azure-sql/database/hyperscale-named-replica-configure.md

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -226,6 +226,15 @@ DELETE https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444
226226
> [!IMPORTANT]
227227
> Named replicas will be automatically removed when the primary replica from which they have been created is deleted.
228228
229+
## Optimizing named replica configuration
230+
231+
It is recommended to configure the named replica with the same compute size (vCores) as the primary replica. If the primary replica experiences a heavy write workload, a named replica with a lower compute size might not be able to keep up, causing replication lag. To maintain the recoverability SLAs, primary's transaction log rate can be temporarily reduced to allow its secondaries to catch up.
232+
233+
If you choose to create the named replica with a different compute size (vCores) than the primary, monitor the log IO rate on the primary over time. This helps estimate the minimal compute size required for the named replica to sustain the replication load. The [sys.dm_hs_database_log_rate()](/sql/relational-databases/system-dynamic-management-views/sys-dm-hs-database-log-rate) dynamic management function (DMF) provides additional details to help understand log rate reduction, if any. It can indicate which specific secondary replica is behind in applying log records and the total size of the unapplied transaction log. To retrieve historical log IO data, use the [sys.resource_stats](/sql/relational-databases/system-catalog-views/sys-resource-stats-azure-sql-database) view. For recent log IO data with higher granularity that better reflects short-term spikes, use the [sys.dm_db_resource_stats](/sql/relational-databases/system-dynamic-management-views/sys-dm-db-resource-stats-azure-sql-database) view.
234+
235+
For more details, refer to the [Azure SQL Database Hyperscale Performance Diagnostics](hyperscale-performance-diagnostics.md#reduced-log-rate-waits).
236+
237+
229238
## Related content
230239

231240
- [Hyperscale secondary replicas](service-tier-hyperscale-replicas.md)

0 commit comments

Comments
 (0)