-
Course
- Data
SQL Server: Scaling SQL Server 2012 and 2014: Part 2
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
- Introduction | 34s
- Statistics-related Database Properties | 3m 26s
- Recovery Model and Compatibility Level | 3m 39s
- Undesirable Database Properties | 4m 46s
- Miscellaneous Settings to Consider | 5m 1s
- Demo: Checking Database Properties | 1m 47s
- Database Filegroup Considerations | 2m 20s
- Database File Layout Considerations | 1m 43s
- Database File Size and Growth Settings | 2m 21s
- Demo: Finding Files That Have Percent Growth | 57s
- Demo: Changing Database Properties with T-SQL | 1m 11s
- Module Summary | 32s
About the author
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.
More Courses by Glenn