ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #azuresqldatabase
Learn how Azure SQL Database serverless tier automatically pauses compute when idle, how to configure it via Azure CLI, and what limits and pitfalls to avoid.
Learn how to offload read‑heavy workloads from your Azure SQL primary node using Read‑Scale Out to improve write throughput and reduce CPU contention.
azuresqldatabasedatabase-performanceread-scale-outTasadduq Burneyowner26.5K rep · 11 Mar 2026, 17:38 UTCPick the right Azure SQL Database tier—General Purpose, Business Critical, or Hyperscale—by balancing latency, cost, and scaling needs. A concise comparison table, trade‑off analysis, and step‑by‑step validation guide help you decide and verify your choice.
azuresqldatabasedatabase-performancecost-optimizationTasadduq Burneyowner26.5K rep · 24 Sept 2026, 09:23 UTCAzure SQL Database can detect plan regressions via Query Store and automatically force the last good plan. Here's how FORCE_LAST_GOOD_PLAN works, how to inspect it, and where it falls short.
azuresqldatabaseautomatic-tuningTasadduq Burneyowner26.5K rep · 18 Nov 2025, 14:45 UTCLearn how to offload read-heavy queries to a secondary replica in Azure SQL Database using ApplicationIntent=ReadOnly to reduce primary node CPU and memory contention.
azuresqldatabaseTasadduq Burneyowner26.5K rep · 08 Aug 2026, 16:48 UTCParameter sniffing makes Azure SQL Database queries unstable across parameter values. Using Query Store to observe plan variance and plan forcing to lock a stable plan can provide deterministic performance without schema or code changes.
azuresqldatabaseplan-forcingTasadduq Burneyowner26.5K rep · 05 Mar 2026, 03:44 UTCWhen using Azure SQL Database to paginate a large result set with the OFFSET‑FETCH clause, you may also have Row‑Level Security (RLS) policies that filter rows before the offset is applied. The goal is to retrieve a predictable page size (e.g., 20 rows) regardless of how many rows are hidden by RLS, while keeping the query plan efficient across different off
azuresqldatabaseTasadduq Burneyowner26.5K rep · 09 May 2026, 22:25 UTCQuery Plan Stability During CE Migration Updating the database compatibility level from 140 to 150 in Azure SQL Database triggers a shift from the legacy cardinality estimator (CE) to the new model. This change affects how the engine calculates estimated row counts for queries involving filtered aggregates and parameter-sensitive predicates. A primary concer
azuresqldatabaseTasadduq Burneyowner26.5K rep · 16 Aug 2022, 00:42 UTCAsynchronous Replication Behavior Azure SQL Database Read-Scale Out provides a read-only replica for offloading reporting and analytical workloads from the primary node. This feature is available in the Premium and Business Critical service tiers, utilizing asynchronous replication to keep the secondary node updated. Consistency Constraints Because the repli
azuresqldatabasebusiness-criticalTasadduq Burneyowner26.5K rep · 01 Dec 2020, 05:57 UTC