MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

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

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 Syllabus

    - 7m 35s

    —Introduction 1m 29s
    —What This Course Covers 4m 4s
    —Course Structure 2m 1s
    Database 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 32s
    Instance Configuration Settings
    - 25m 58s
    Storage Subsystem Issues
    - 22m 58s
    Hardware Issues
    - 22m 22s
    Scaling up SQL Server
    - 13m 6s
    Scaling Out SQL Server
    - 16m 0s
    New Scalability Features in SQL Server 2014
    - 29m 57s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url