- Course
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.
Intermediate
- Course
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.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.
SQL Server: Scaling SQL Server 2012 and 2014: Part 2
Intermediate
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
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.