This course shows how to properly configure SQL Server storage for the best performance, scalability, and reliability with several different types of workloads, and how to measure your storage performance.
Storage subsystem performance can often be the biggest factor affecting a SQL Server workload. This course, SQL Server: Improving Storage Subsystem Performance, shows you how to detect and correct important and common storage misconfiguration issues with SQL Server. You'll get to see how to measure and analyze storage subsystem performance, as well as and how to change SQL Server configurations for the best performance. You'll also get to see common RAID levels and how to choose an appropriate one for the SQL Server workload. By the end of this course, you'll be prepared to properly design and configure SQL Server storage subsystems for various types of SQL Server workloads for the best performance, scalability, and reliability. The course is relevant to all current versions of SQL Server, and demonstrates some new features from SQL Server 2014 and SQL Server 2016.
Glenn works as a Principal Consultant at SQLskills.com. He has been a SQL Server MVP since 2007, and he is also an Adjunct Faculty member at University College - University of Denver. He is the author of the book SQL Server Hardware (Redgate 2011), and he wrote chapters for both SQL Server MVP Deep Dives books.
Course Overview My name is Glenn Berry, and welcome to my course, SQL Server: Improving Storage Subsystem Performance. I'm a principal consultant with SQL skills as well as a Microsoft data platform MVP, and this topic is one that I've been presenting and writing about for many years, because I feel so passionate about this subject. In the course of my career as a database administrator and consultant, I've never had anyone tell me that their database or database server was too fast. It's all too common for people to complain about slow application performance, and often jump to the conclusion that any performance or scalability issue must be caused by your database server. Quit often, application and database performance issues are actually caused by poor storage subsystem performance. I want to give you the concepts and tools that you can use to help prevent your storage subsystem from being a performance or scalability bottleneck. I also want to show you a number of techniques that you can use to reduce the load on your storage subsystem. We cover how to measure and analyze your storage subsystem performance, how to test and benchmark your storage subsystem, and how to improve your storage subsystem performance. If you work with SQL server in any capacity, whatever your level, this course is relevant to you. Experience with hardware and storage subsystems is helpful, along with a basic understanding of how SQL Server works. I hope you'll join me as we explore the world of storage subsystems with the SQL Server: Improving Storage Subsystem Performance course here on Pluralsight.