Monitor SQL database in Microsoft Fabric

This article includes tools and methods to monitor your SQL database in Microsoft Fabric. Fabric provides a set of tools to help you:

• View database performance metrics, to identify performance bottlenecks, and find solutions to performance issues.
• Gain insights into your Fabric capacity, to determine when it's time to scale up or down.

Microsoft Fabric Capacity Metrics app

The Microsoft Fabric Capacity Metrics app provides visibility into capacity usage of each database allowing you to see the compute charges for all user-generated and system-generated T-SQL statements within a database.

For more information on monitoring capacity usage, see Billing and utilization reporting for SQL database in Microsoft Fabric.

Sfat

In this blog post, learn how the capacity metrics app can be used for monitoring usage and consumption of SQL databases in Fabric.

Performance Dashboard

Users are provided a one-stop view of the performance status of the database. The Performance Dashboard and offers varying levels of metrics visibility and time ranges, including query-level analysis and identification. For more information, see Performance Dashboard for SQL database in Microsoft Fabric.

Query DMVs with T-SQL

You can also use the SQL query editor, the mssql extension with Visual Studio Code, SQL Server Management Studio, or other tools to query the same internal dynamic management views (DMVs) as used by Azure SQL Database. For T-SQL query examples and applicable DMVs, see:

• Monitor performance using dynamic management views
• Troubleshoot memory issues
• Understand and resolve blocking problems
• Analyze and prevent deadlocks

Related content

• Billing and utilization reporting for SQL database in Microsoft Fabric