Virtualising SQL Server is nothing new, but as our confidence increases so value of what we are virtualising.  This is fine until there are performance problems. On top of the usual monitoring and diagnostics, we have a whole new world of components to investigate, which is complicated by these typically being shared (SAN, hypervisor and host server).

To make sure you’re prepared to troubleshoot a virtualised platform I’ve put together a checklist. I’ll discuss what items are on the checklist and the importance of why they’re there.  When you deploy your next SQL Server using virtualisation or perform your next SQL Server audit you can tick my checklist items off and feel more prepared for any issues that come in.