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.
SQL SERVER – Maintenance Plan Error: Cannot Create a Task From XML For Task, Eue to Error 0x80070057. The Parameter is Incorrect. (OnPreExecute)
Creating a new maintenance plan on my virtual machine failed with cannot create a task from XML, error 0x80070057. Here is the fix that worked for me.
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.
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.
How Many CPUs SQL Server Really Uses
CPUs SQL Server really uses depend on edition, guest topology, affinity, and online schedulers; learn to see the instance’s usable capacity.