No-Code PERFORMANCE GAINS with Intelligent Query Processing in Azure SQL & SQL Server!!

Опубликовано: 10 Май 2023
на канале: Tales From The Field
183
12

​‪@SQLBalls‬ walks us through understanding how to test Intelligent Query Processing, specifically Self-Healing Persistent Memory Grant Feedback from ‪@sqlserver‬ 2022 now a part of ‪@AzureSQL‬ !

Bob Ward's SQL 2022 Workshop
https://aka.ms/sql2022workshop

Get started with Storage Explorer
https://learn.microsoft.com/en-us/azu...

Quickstart: Import a .bacpac file to a database in Azure SQL Database or Azure SQL Managed Instance
https://learn.microsoft.com/en-us/azu...

Serverless compute tier for Azure SQL Database
https://learn.microsoft.com/en-us/azu...

Import a BACPAC File to Create a New User Database
https://learn.microsoft.com/en-us/sql...

Chapters
00:00 Introduction
00:48 Download World Wide Importers from GitHub
01:16 Use Azure Storage Explorer to upload Bacpac to Azure
01:52 Import Bacpac and provision Azure SQL Serverless
02:50 Import BacBac via SSMS
03:34 Validate Import via SSMS
03:53 Get Bob Ward's Class https://aka.ms/sql2022workshop
04:27 Demo Automatic performance healing with Memory Grant Feedback Persistence
07:45 Let's Keep the Coversation Going!


Смотрите видео No-Code PERFORMANCE GAINS with Intelligent Query Processing in Azure SQL & SQL Server!! онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Tales From The Field 10 Май 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 183 раз и оно понравилось 12 людям.