SQL Server 2019 - Intelligent Performance
Lab
Beginner
0 h 45 m
2020-04-05
Lab Overview
In this lab, you will learn how to use the built-in capabilities of Intelligent Query Processing in SQL Server 2019 simply by changing the database compatibility of WideWorldImporters to version 150 with no application changes.

Related Learning Path(s):
What is new with SQL Server 2019
Objectives
  • Understand how to take advantage of SQL Server Intelligent Query Processing
  • Use Query Store for Performance Analysis
  • Understand how to measure Tempdb performance
Exercises
In this exercise, you will learn how to use the built-in capabilities of Intelligent Query Processing in SQL Server 2019 simply by changing the database compatibility of WideWorldImporters to version 150 with no application changes.
The **WideWorldImporters** sample database that you restored has the Query Store feature enabled. If you performed the Activities the Query Store recorded performance information about each query execution. Work through the following steps to use the Query Store to examine the query performance differences for the CustomerProfits stored procedure when executed with database compatibility 130 versus 150.
In this exercise, you will learn how tempdb is just faster in SQL Server 2019 using a concurrent temporary table workload. You will also learn how to use new T-SQL interfaces to find the object associated with a page latch.
Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs provide a live environment to get hands-on experience using the same tools and services in the real world.


Learn More