Microsoft has recently announced the general availability of Azure Durable Functions support for both the new storage providers, Netherite and Microsoft SQL Server (MSSQL). Azure Durable Functions allow developers to write reliable, long-running, stateful logic, and they can have multiple storage providers or backends for orchestration and entity runtime states. The default option for new projects is Azure Storage, but developers can also choose Netherite and MSSQL backends for more price-performance efficiency and portability. Netherite has better throughput performance than Azure Storage, using Azure Event Hubs and FASTER database technology with Azure Page Blobs to store state information. MSSQL is designed to meet enterprise needs and is compatible on both on-premises and cloud-hosted deployments of SQL Server, including Azure SQL Database, Edge devices, and Linux containers. Microsoft recommends Azure Storage for minimal setup and cost, Netherite for maximum throughput, and MSSQL for running Durable Functions anywhere. More detailed documentation is available on the github.io pages for Netherite and MSSQL.
