Microsoft Fabric Updates Blog

Query activity: A one-stop view to monitor your running and completed T-SQL queries

We’re excited to announce Query activity, a one-stop view of all running and historical T-SQL queries for workspace admins! We know monitoring T-SQL queries is essential for maintaining the performance and efficiency of the warehouse to ensure that queries aren’t taking longer than expected to execute and are completed successfully. This feature enhances your ability to monitor queries quickly from your Microsoft Fabric Data warehouse or Lakehouse SQL analytics endpoint without having to run any T-SQL code!

There are two ways you can launch the Query activity experience:

  1. Click on More Options (…) next to the warehouse you want to monitor within the workspace view and select Query activity.
  2. Once you are within the query editor, click on Query activity in the ribbon.

On the Query runs page, you can see a list of running, succeeded, canceled, and failed queries up to the past 30 days. You can use the filter dropdown to select a certain status, submitter, or submit time you would like to view queries from. If there is a specific keyword in the query text or another column you would like to search up by, you can use the search bar in the top right corner to look it up. If you see a long-running query that you would like to cancel, select the query using the checkbox and click on the Cancel button. Please note that this will kill the session that the query belongs to and all queries within the same session.

On the Query insights page, you can see a list of long running queries and frequently run queries to help determine any trends within your warehouse’s queries.

A screenshot of a computer

Description automatically generated

To learn more about Query activity, please refer to the documentation.

Related blog posts

Query activity: A one-stop view to monitor your running and completed T-SQL queries

October 9, 2024 by Misha Desai

At Fabric, we’re passionate about contributing to the open-source community, particularly in areas that advance the usability and scalability of machine learning tools. One of our recent endeavors has been making substantial contributions back to the FLAML (Fast and Lightweight AutoML) project, a robust library designed to automate the tedious and complex process of machine … Continue reading “Enhancing Open Source: Fabric’s Contributions to FLAML for Scalable AutoML”

September 30, 2024 by Matt Basile

You can now delegate access to OneLake using short-lived OneLake shared access signatures (SAS). OneLake SAS make it easy to provide limited access to applications which may not support Microsoft Entra, as well as support applications serving as proxy layers between users and their data in OneLake. OneLake SAS follow security best practices for delegated … Continue reading “OneLake shared access signatures (SAS) now available in public preview”