DBAs, sysadmins, managers, or anyone who faces challenges with their database infrastructure on SAN.
When storage doesn’t perform and scale it causes issues for SQL Server and can make DBA life extremely challenging. In many cases SQL Server storage is provisioned on a SAN. However, very few DBAs even get to see a SAN or understand how it works. Even though the SAN is someone else’s responsibility, as a DBA you feel the pain and you’re typically a first responder when there is a problem. Understanding the “magic” behind it will make you a better DBA and help you have productive conversations with your storage administrator. After all, pointing fingers has a negative impact on your superhero status!
In this session you will learn what a SAN is , how it works, and why it’s typically used vs. direct attached storage. These ‘black boxes” have a lot of capabilities, so you will also learn about some of the common features today that they offer and how they can help you. You will also learn about what can go wrong, some basic troubleshooting when you’re not getting what you expected, and how to communicate with your SAN administrator if you’re not getting what you need.
Why I Want to Present This Session:
Spending almost 20 years as a DBA, I went through several performance challenges and many conversations with storage and infrastructure people. Countless times I got the blank stare when I told them my storage performance wasn’t as I expected and the conversations were less than productive. Over the past 5 years I’ve gotten an in-depth look at this technology as well as the challenges that both DBAs and SAN administrators face. I would like to pass that information on to you.