Synapse Espresso: Using QPI Library to Troubleshoot Performance Issues in Serverless SQL Pools
Welcome to the 10th video of the Synapse Espresso series!
In this video, we are joined by Stijn and Jovan, to understand QPI library. Jovan will show us how to use QPI library to identify and fix performance issues in Serverless SQL Pools. QPI is open-source T-SQL library that contains a set of views that enable you to easily identify and fix the performance issues in Serverless SQL Pools.
Check out the QPI library here: https://github.com/JocaPC/qpi
Chapters
0:00:08 - Intro
0:02:00 - Finding schema recommendations
0:06:44 - Current queries
0:07:18 - Query history
0:10:38 - Comparing queries
0:11:20 - Querying persisted history (diagnostic logs)
Jovan Popovic - Senior Program Manager
/ jovan-popovic
/ jovanpop_msft
Stijn Wynants - Fasttrack Engineer
/ stijn-wynants-ba528660
https://sql-stijn.com/
/ sqlstijn
#azuresynapse #serverless #sql #performance #qpi