SQL Server on Azure VM
Some considerations when configure SQL Server on Azure VM. This also applicable to AWS VM
For storage:
- Separate volume for data and log file - Enable read caching on data file volume - Disable any caching on log file volume - Use D: drive (local SSD that will be cleared each time with server reboot) for TempDB - Enable instant file initialization - Move trace file and error log directories to data volume To evaluate disk performance when migrate from on-premises to cloud, capture following counters in Performance Monitor:
Posted by John Liu Wednesday, November 17, 2021