Pluralsightintermediateen

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

Scale SQL Server 2012/2014 workloads! Learn to avoid configuration problems and master scaling strategies (up & out) for improved performance and scalability.

4.7(24)
2h 46m
Certificate
Glenn Berry
Glenn BerryInstructor

Course Content

SQL Server: Scaling SQL Server 2012 and 2014: Part 2 is an intermediate-level Pluralsight course taught by Glenn Berry. It runs 2h 46m, is taught in English, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 24 reviews. It is a paid course, first published February 2025.

Looking to improve SQL Server performance and scalability? This course, SQL Server: Scaling SQL Server 2012 and 2014: Part 2, is the next step after "Scaling SQL Server 2012 - Part 1". Go beyond simple scaling up or scaling out and discover a comprehensive approach to optimizing your SQL Server workload.

This course delves into a wide range of strategies for boosting SQL Server scalability. You'll start by identifying and resolving common configuration issues across critical components:

  • Hardware: Learn how to optimize your server's physical components for peak performance.
  • Storage: Understand the impact of storage configurations on SQL Server performance and discover best practices.
  • Windows: Explore Windows Server settings that can significantly affect SQL Server scalability.
  • SQL Server: Identify and address configuration settings within SQL Server itself.

You'll see practical demonstrations of these issues and learn about powerful troubleshooting tools to quickly pinpoint bottlenecks.

Finally, you'll gain a deep understanding of techniques and features to effectively scale up (vertical scaling) or scale out (horizontal scaling) your SQL Server environment after ensuring a solid foundation.

By the end of this course, you'll be equipped with the knowledge and skills to significantly enhance SQL Server workload performance and achieve robust SQL Server scalability.

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.