These two technologies can make a very big — and very bad — difference in how your SQL Server performs. Wouldn’t it be great if you could get the real, honest lowdown from a virtualization administrator, a SAN administrator, and a DBA? Wouldn’t it be even better if one person had done all three, and could give you the pros and cons of each point of view?
In this one-hour session, I explain how virtualization changes CPU, memory, and monitoring, and I show how to get specific recommendations for your make & model of SAN:
The links I discuss in the video are BrentOzar.com/go/san and BrentOzar.com/go/virtual.
4 Comments. Leave new
Any ideas to make a series available as elearning? Cannot attend any in-person event as I’m from far away.
It’s a webcast series. :-). You can attend from the comfort of your home or office.
Howdy Brent, long time follower here. Wasn’t sure where to ask this question and randomly came across this page in a Google search.
I’m looking for some clarification of various things I’ve read. I understand it to be best practice to store your transaction logs on a separate drive (spindle) than where you MDFs and NDFs are housed.
Does this same principal hold true in a virtualized environment on a SAN?
Great question! Unfortunately the answer is longer than I can go into here – it’s something I cover in our virtualization training videos.