Select Page
wlp-disabled.png

Improving concurrency of asynchronous statistics update

Executive summary In Azure SQL Database and Azure SQL Managed Instance, the background process that updates statistics asynchronously can now wait for the schema modification lock on a low priority queue. This improves concurrency for workloads with frequent query plan ... continue reading
Gen5-HammerDB-2.png

Compute-optimized Fsv2 hardware in Azure SQL Database

Executive summary For CPU-bound workloads, Fsv2 can improve query response time and workload throughput by 20-40%, compared to Gen5 hardware. What is Fsv2-series hardware? At the Ignite conference in November 2019, we introduced the preview of two new hardware generations ... continue reading
ingestion-4.2.png

Scaling up an IoT workload using an M-series Azure SQL database

Executive summary M-series provides close to 30 GB of memory per core and up to 128 cores, enabling significant scale-up capability in Azure SQL Database. For the same IoT workload, we achieved 3 times higher throughput on M-series compared to ... continue reading