Performance Tuning & Availability Sets

SQL Server 2016    |    Intermediate
  • 8 Videos | 31m 4s
  • Includes Assessment
  • Earns a Badge
Likes 14 Likes 14
Moving Microsoft SQL Server applications to Azure virtual machines can help optimize overall performance. Discover various methods used for performance tuning and configuring availability sets for redundancy.

WHAT YOU WILL LEARN

  • describe how VM disk caching works
    explain how using data compression reduces overall I/O
    describe the different types of platform events that can affect the availability of VMs
    demonstrate how to configure multiple VMs in an availability set for redundancy
  • configure each application tier into separate availability sets for redundancy
    describe the benefits of combining Azure load balancer with availability sets
    configure multiple storage accounts for each availability set
    migrate data using the Microsoft Azure VM wizard

IN THIS COURSE

  • Playable
    1. 
    VM Disk Options
    4m 36s
    UP NEXT
  • Playable
    2. 
    VM Disk Caching
    3m 58s
  • Locked
    3. 
    Data Compression
    4m 5s
    FREE ACCESS
  • Locked
    4. 
    Microsoft Azure Platform Events
    3m 11s
    FREE ACCESS
  • Locked
    5. 
    Configuring Availability Sets for Redundancy
    4m 24s
    FREE ACCESS
  • Locked
    6. 
    Configuring Application Tiers
    4m 23s
    FREE ACCESS
  • Locked
    7. 
    Azure Load Balancer
    2m 26s
    FREE ACCESS
  • Locked
    8. 
    Multiple Storage Accounts
    4m 1s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Database Performance Settings
Likes 42 Likes 42  
COURSE Microsoft Azure Administrator: Business Continuity
Likes 1 Likes 1  
BOOK MongoDB Performance Tuning: Optimizing MongoDB Databases and their Applications