Simple play icon Course
Skills Expanded

SQL Server: Scaling SQL Server 2012 and 2014: Part 2

by Glenn Berry

Learn how to avoid configuration issues from the hardware to the database that can limit the scalability of a SQL Server 2012/2014 workload, along with features and design methodologies for scaling up and scaling out.

What you'll learn

When considering how to improve the scalability of a SQL Server workload, many people jump to the conclusion that scaling up or scaling out are the only answers. This course, SQL Server: Scaling SQL Server 2012 and 2014: Part 2, builds on the earlier "Scaling SQL Server 2012 - Part 1" course and will show you a huge number of things you can do to improve performance and scalability. First, you'll learn about configuration issues in hardware, storage, Windows, and SQL Server, and you'll also see demonstrations of some of the issues and tools to help you find the issues in the first place. Finally, you'll get an explanation of some of the techniques and features you can use to scale up or scale out, once you've configured the system correctly. By the end of this course, you'll be able to improve the performance and scalability of a SQL Server workload.

Table of contents

About the author

Glenn works as a Principal Consultant at SQLskills.com. He has been a SQL Server MVP since 2007, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, and performance tuning. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher P... more

Ready to upskill? Get started