SQL Server: Scaling SQL Server 2012 and 2014: Part 2
Pluralsight
Course Summary
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.
-
+
Course Description
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.
-
+
Course Syllabus
Introduction- 7m 35s
—Introduction 1m 29s
—What This Course Covers 4m 4s
—Course Structure 2m 1sDatabase Configuration Settings- 28m 24s
—Introduction 0m 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 0m 57s
—Demo: Changing Database Properties with T-SQL 1m 11s
—Module Summary 0m 32sInstance Configuration Settings- 25m 58sStorage Subsystem Issues- 22m 58sHardware Issues- 22m 22sScaling up SQL Server- 13m 6sScaling Out SQL Server- 16m 0sNew Scalability Features in SQL Server 2014- 29m 57s