Database Performance Tuning and Optimization, Workshops

DPM01 Workshop: SQL Performance Unleashed - Real-Time Data Platform Insights with Microsoft Fabric

11/18/2024

8:30am - 5:30pm

Level: Introductory

Bradley Ball

Sr. Azure Engineer for the Azure FastTrack CXP PG

Microsoft

Thomas LaRock

Manager, Data Engineering

BlackLine

In this session, we'll explore how to harness the power of Microsoft Fabric and the newly introduced Database Watcher for Azure SQL to create insightful custom reports. Our focus will be on showcasing database performance metrics and translating community scripts into actionable visualizations using Power BI.

Key Topics Covered:

  1. Introduction to Microsoft Fabric: Understand the role of Microsoft Fabric in real-time analytics and data processing. Explore its capabilities for streamlining data ingestion, storage, and analysis.
  2. Database Watcher for Azure SQL (Preview): Discover the features and benefits of the Database Watcher. Learn how it enhances monitoring capabilities for Azure SQL Database and Azure SQL Managed Instance. Dive into workload monitoring data collection, configuration insights, and health assessment.
  3. Integration with Microsoft Fabric: Explore seamless integration between Database Watcher and Microsoft Fabric. See how monitoring data can be effortlessly streamed, stored, and analyzed in real-time using an Eventhouse KQL database within Fabric Real-Time Analytics. Understand how this integration empowers users to make informed decisions about their database performance.
  4. Creating Custom Reports: Once data resides in the Eventhouse KQL database, we'll demonstrate how to query it using KQL or T-SQL. Leverage Real-time Analytics KQL Querysets to execute queries, customize results, and gain insights. Build custom visualizations using KQL built-in visualizations or Power BI.

You will learn:

  • Understand how to use Microsoft Fabric Realtime Analytics
  • Understand how to set up and use Database Watcher for Azure SQL
  • Understand how to create custom visualizations in Power BI to leverage insights into your Azure SQL environment