You're reading from Learn Microsoft Fabric A practical guide to performing data analytics in the era of artificial intelligence

Product type Paperback

Published in Feb 2024

Publisher Packt

ISBN-13 9781835082287

Length 338 pages

Edition 1st Edition

Tools

Azure Data Factory

Concepts

Artificial Intelligence

Authors (2):

Bradley Schacht

Arshad Ali

View More author details

Table of Contents (19) Chapters

Preface

1. Part 1: An Introduction to Microsoft Fabric FREE CHAPTER

2. Chapter 1: Overview of Microsoft Fabric and Understanding Its Different Concepts

3. Chapter 2: Understanding Different Workloads and Getting Started with Microsoft Fabric

4. Part 2: Building End-to-End Analytics Systems

5. Chapter 3: Building an End-to-End Analytics System – Lakehouse

6. Chapter 4: Building an End-to-End Analytics System – Data Warehouse

7. Chapter 5: Building an End-to-End Analytics System – Real-Time Analytics

8. Chapter 6: Building an End-to-End Analytics System – Data Science

9. Part 3: Administration and Monitoring

10. Chapter 7: Monitoring Overview and Monitoring Different Workloads

11. Chapter 8: Administering Fabric

12. Part 4: Security and Developer Experience

13. Chapter 9: Security and Governance Overview

14. Chapter 10: Continuous Integration and Continuous Deployment (CI/CD)

15. Part 5: AI Assistance with Copilot Integration

16. Chapter 11: Overview of AI Assistance and Copilot Integration

17. Index

Why subscribe?

18. Other Books You May Enjoy

Monitoring data warehouse activity

As of writing this in January 2024, the data warehouse experience does not appear in Fabric's Monitoring hub. Instead, administrators will rely on Dynamic Management Views (DMVs) to gain insight into warehouse and SQL endpoint activity. Combined, the DMVs provide a view into server connections (sys.dm_exec_connections), sessions (sys.dm_exec_sessions), and active queries (sys.dm_exec_requests).

Looking at the data in these can answer a few key questions:

Who is connected to the warehouse and from where?
What queries are executing right now?
Who is executing queries right now?
How long have queries been executing?

Using a script available in the Fabric toolbox (https://aka.ms/FabricToolbox), these DMVs can be joined together to provide a look at all the current database activity.