Performance Tuning & Availability Sets

SQL Server 2016    |    Intermediate
  • 8 videos | 31m 4s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 10 users Rating 4.6 of 10 users (10)
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

  • 4m 36s
    After completing this video, you will be able to describe how VM disk caching works. FREE ACCESS
  • 3m 58s
    After completing this video, you will be able to explain how using data compression reduces overall I/O. FREE ACCESS
  • Locked
    3.  Data Compression
    4m 5s
    After completing this video, you will be able to describe the different types of platform events that can affect the availability of VMs. FREE ACCESS
  • Locked
    4.  Microsoft Azure Platform Events
    3m 11s
    In this video, you will learn how to configure multiple VMs in an availability set for redundancy. FREE ACCESS
  • Locked
    5.  Configuring Availability Sets for Redundancy
    4m 24s
    During this video, you will learn how to configure each application tier into separate availability sets for redundancy. FREE ACCESS
  • Locked
    6.  Configuring Application Tiers
    4m 23s
    Upon completion of this video, you will be able to describe the benefits of combining Azure load balancer with availability sets. FREE ACCESS
  • Locked
    7.  Azure Load Balancer
    2m 26s
    To configure multiple storage accounts for each availability set: FREE ACCESS
  • Locked
    8.  Multiple Storage Accounts
    4m 1s
    In this video, you will learn how to migrate data using the Microsoft Azure VM wizard. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Developing Solutions for Microsoft Azure: Caching in Azure
Rating 4.6 of 12 users Rating 4.6 of 12 users (12)
Course Microsoft Azure Fundamentals: Azure Cloud Computing
Rating 4.6 of 1713 users Rating 4.6 of 1713 users (1713)
Course Working with Microsoft Azure SQL: Using Transact-SQL for Queries & Transactions
Rating 4.7 of 11 users Rating 4.7 of 11 users (11)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Troubleshooting Data Integration
Rating 3.9 of 11 users Rating 3.9 of 11 users (11)
Course Upgrading to SQL Server 2016
Rating 4.5 of 22 users Rating 4.5 of 22 users (22)
Course Application Patterns
Rating 4.1 of 29 users Rating 4.1 of 29 users (29)