Monitor, analyze and optimize your warehouse workload in Fabric!
Understand the warehouse query processing and query optimization and get the best practices for working with the warehouse from loading to querying! During this session we will go through a sample demo solution all the way from data source to querying and usage of a warehouse.
You will see how to monitor, baseline and optimize the workload at every stage on the way so that it runs efficiently and uses the least possible compute resources. We will discover best practices on how to organize your loading process, how to baseline and optimize it. You will understand query processing and query optimization of the warehouse engine, the delta store and the statistics. You will see the toolset we can use for baselining and monitoring out-of-the box. This will cover the Fabric Monitor and Fabric Capacity Metrics, query insights, and common DMVs and you will learn how to read the output and use them in different cases. We will make some comparisons with Lakehouses in Fabric and with other Data Stores outside of Fabric as well.
Whether you use warehouse for gold layer or as a main data store in Fabric, it needs a deeper dive and discovery. This session will give that to you in the best possible way – by example.