Virtualization, SAN, and SQL Server: The Perfect Storm
Each of these things alone is tough enough to manage, but when you start to combine them, the forecast calls for rogue waves of bad performance. Metrics like CPU % and disk queue length just don't mean anything anymore. No matter what numbers you hand your virtualization sysadmins, Windows admins, or SAN admins, they all say the same thing: "It's a SQL Server problem."
Learn how to fight back as Brent Ozar, Microsoft Certified Master, exposes some surprising truths like:
- What metrics can prove it's not a SQL Server problem
- Why you might not want to separate your data and log files onto different drives
- How to double-check to make sure the other guys are doing their job
- The crucial configuration choices that can doom your SQL Server performance from the start
By the end of this session, you'll be able to walk back into your office, gather statistics and configurations, and give your sysadmins and SAN admins the information they need to fix performance problems on their end.