From the course: SQL Databases in Microsoft Fabric

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Performance monitoring

Performance monitoring

- [Instructor] Let's take a look at how you can monitor your database's resources and consumption. Right from your Fabric database, you can reach the Performance Monitor. The Performance Monitor will give you insights on the number of vCores used, et cetera, but the Performance Monitor will also take you to the Performance Dashboard, where you will find a lot more insights, including an overview of recent queries, et cetera. Right here, from the homepage of my Fabric SQL DB, I can access the performance summary. The performance summary will give me an overview of my CPO consumption, so the number of vCores used, user connections, request per seconds, block queries, allocated size, et cetera. This also leads me to the Performance Dashboard. The Performance Dashboard will have more detailed information on CPU consumption, user connections, request per seconds, block queries, et cetera. It will also show me all the details by those recent user connections, for example, or my CPU…

Contents