Mixing virtualisation with SQL Server - a checklist for success

2011

TL; DR

Here I share a checklist I created from my experience and theory designed to make sure we’re ready to put our business critical SQL Servers on a virtualised platform and are prepared for the next time we get a database performance issue.

Session Details

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.

3 things you'll get out of this session

Gavin Payne's previous sessions

An introduction to SQL Server for data scientists

A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster.

Designing quality SQL Server 2014 solutions

This session shows how you can use SQL Server 2014’s features to meet your solution’s non-functional requirements and ensure operational success.

The NUMA internals of SQL Server 2012

This session reviews the purpose of NUMA, how it changes the internal behaviours of Windows and SQL Server 2012 and NUMA related performance monitoring.

Through the virtual looking glass - monitoring virtualised SQL

Virtualisation changes the way you need to monitor the performance of a virtualised instance of SQL Server. In this session I will demonstrate a balanced and well-rounded approach to performance monitoring in the virtual world along with best practices to avoid poor virtualised performance.

Oracle for SQL Server DBAs

If you’ve only ever chosen to use Microsoft database products then there’s a chance you might hide a curiosity deep down about the Oracle database platform; or like me a few years ago be told that your next big production system will use it and now’s the time to upskill. This session introduces some key concepts and differences about the Oracle database platform to people like myself who are used to the UI-heavy Windows-based database world and hopefully make you curious enough to want to at least give it a try when you get back home.