WhatāsĀ newĀ inĀ SQLĀ ServerĀ Performance,Ā Scalability,Ā andĀ Availability.
This module introduces the performance enhancements provided by Adaptive Query Processing and Automatic Tuning, as well as the scalability and availability enhancements provided by new Availability Group architectures, including Read-Scale Availability Groups and Availability Groups with SQL Server on Linux
Lessons
- AdaptiveĀ queryĀ processingĀ
- AutomaticĀ tuningĀ
- AvailabilityĀ ScalabilityĀ
Ā
Lab: PerformanceĀ andĀ availabilityĀ āĀ adaptiveĀ queryĀ processingĀ
- InterleavedĀ executionĀ
- BatchĀ modeĀ memoryĀ grantĀ feedback
- BatchĀ modeĀ adaptiveĀ joinsĀ
Ā
After completing this module, students will be able to:
- DescribeĀ adaptiveĀ queryĀ processingĀ
- DescribeĀ automaticĀ planĀ correction
- DescribeĀ availabilityĀ groupĀ architecturesĀ
- DescribeĀ alwaysĀ onĀ availabilityĀ groupsĀ forĀ LinuxĀ
- DescribeĀ loadĀ balancingĀ ofĀ readableĀ secondaryĀ replicasĀ
- DescribeĀ petabyte-scaleĀ dataĀ warehousingĀ