Performance Tuning & Availability Sets

SQL Server 2016    |    Intermediate
  • 8 Videos | 35m 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
  • Locked
    4. 
    Microsoft Azure Platform Events
    3m 11s
  • Locked
    5. 
    Configuring Availability Sets for Redundancy
    4m 24s
  • Locked
    6. 
    Configuring Application Tiers
    4m 23s
  • Locked
    7. 
    Azure Load Balancer
    2m 26s
  • Locked
    8. 
    Multiple Storage Accounts
    4m 1s

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 34 Likes 34  
Likes 31 Likes 31  
Likes 32 Likes 32