Azure SQL Database, Memory and Compute Optimized Options

Azure SQL Database, Microsoft’s hosted relational database service, now offers the ability to select specific memory- and compute-optimized hardware configurations to help database administrators address the performance requirements of their database applications. General availability includes a wider range of deployment sizes than were available in preview, including low-end options for smaller databases. The hardware choices (Fsv2 and M) correspond to Azure VM families. Fsv2 series hardware provides low CPU latency and high clock speed for CPU-intensive workloads. Fsv2 hardware is available for General Purpose vCore database deployments with options ranging from 8 virtual cores and 15GB of memory up to 72 virtual cores and 136GB of memory. M series hardware provides an optimized ratio of memory to virtual cores for memory-intensive workloads. M hardware is available for business-critical vCore database deployments with options ranging from 8 virtual cores and 235GB of memory up to 128 virtual cores and 3,767GB of memory. The existing Gen5 hardware option remains as the default option to provide a balanced compute and memory option for standard workloads. Azure SQL Database is covered in the Azure Roadmap at https://www.directionsonmicrosoft.com/azure/database-development/data-storage-access/sql-database-azure.