My client wanted to upsize an Azure VM running Always On from D-Series to a higher tier G-Series size, but it was missing from the list. Here is what I suggested.
Running SQL Server on an Azure Virtual Machine
SQL Server on an Azure virtual machine keeps instance control while moving storage and hosting to Azure; learn disk, backup, and sizing checks.
SQL SERVER – Virtualized SQL Server Performance and Storage System – Notes from the Field #013
Tuned everything in a VM and still slow? In Notes from the Field #013, David Klee explains Virtualized SQL Server Performance and the storage behind it.
SQL Server Performance Stack: Look Beyond the Query
Tuned every query and SQL Server is still slow? David Klee looks at the SQL Server performance stack, from storage and virtualization to the network. He also explains why a baseline matters.
Trying New SQL Server Features Without Risk
Trying New SQL Server Features safely takes a separate instance, a controlled data copy, and before and after measurements.
SQL Server on a Virtual Machine: What Actually Changes
SQL Server on a virtual machine cannot see the host it is sharing. Why more virtual processors can be slower, what memory reservation buys you, why snapshots are not backups, and the four things I check first.







