From the course: Learning Microsoft Fabric
Join today to access over 24,600 courses taught by industry experts.
Monitoring SQL database performance - Microsoft Fabric Tutorial
From the course: Learning Microsoft Fabric
Monitoring SQL database performance
- SQL DB makes it really easy to see what's going on in the database using tools that come with Fabric. The performance summary shows a high-level overview of CPU consumption, user connections, requests per second, block queries per second, the allocated size, and automatic index. If you're worried about the number of reads or how often a query runs or the amount of time it takes, monitoring these is all available in the performance dashboard. The dashboard shows things like the top CPU performing queries and what specific user accounts create the most traffic. It's also possible to change the timeframe to see real time charts for the current state and changes over the last 24 hours or even 30 days. You can mark your favorites to monitor over time and see what changes have occurred to one query or several. Reviewing over time is really important as this kind of analysis helps you decide whether or not you need to increase capacity or maybe add an index to improve performance. The…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.