Azure BlobCache

When configuring the VM or adding storage, you can set the caching for the disk. BlobCache provides a multi-tier capability by using the VM's memory and the local SSD for caching. This is only available for Premium disk and is the default for Azure Marketplace images. If you've self-installed SQL Server, then you'll have to manually set up Azure BlobCache.

There are three options for disk caching: ReadWrite, None, and ReadOnly.

For SQL Server workloads, ReadWrite should not be used. ReadWrite can lead to data consistency issues with SQL Server.

None should be used for SQL Server log files. SQL Server log files write data sequentially to disk. There would be no benefit to using ReadOnly caching in that scenario.

SQL Server data files should take advantage of the ReadOnly caching option. By using ReadOnly, reads are pulled from the cache, which are stored within the VM memory and the local SSD. Memory is fast, and the local SSD provides better...