Skip to content

SQL Server Blog

Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions

A common practice on-premise to improve the performance of SQL Server workloads is storing TempDB and/or Buffer Pool Extensions (SQL Server 2014) on SSDs. The former improves the performance of workloads that use temporary objects heavily (e.g. queries handling large recordsets, index rebuilds, row versioning isolation levels, temp tables, and triggers). The latter improves the...

Read more