Monitor Fabric Data warehouse

  • Article

Applies to: SQL analytics endpoint and Warehouse in Microsoft Fabric

Monitoring the usage and activity is crucial for ensuring that your warehouse operates efficiently.

Fabric provides a set of tools to help you:

  • Optimize query performance
  • Gain insights into your Fabric capacity to determine when it's time to scale up or down
  • Understand details about running and completed queries

Microsoft Fabric Capacity Metrics app

The Microsoft Fabric Capacity Metrics app provides visibility into capacity usage of each warehouse allowing you to see the compute charges for all user-generated and system-generated T-SQL statements within a warehouse and SQL analytics endpoint. For more information on monitoring capacity usage, see Billing and utilization reporting in Synapse Data Warehouse.

Query activity

Users are provided a one-stop view of their running and completed queries in an easy-to-use interface, without having to run T-SQL. For more information, see Monitor your running and completed queries using Query activity.

Query insights

Query Insights provides historical query data for completed, failed, canceled queries along with aggregated insights to help you tune your query performance. For more information, see Query insights in Fabric data warehousing.

Dynamic management views (DMVs)

Users can get insights about their live connections, sessions, and requests by querying a set of dynamic management views (DMVs) with T-SQL. For more information, see Monitor connections, sessions, and requests using DMVs.

Related content