From the course: Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Troubleshooting and resolving T-SQL errors

Troubleshooting and resolving T-SQL errors - Microsoft Fabric Tutorial

From the course: Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Troubleshooting and resolving T-SQL errors

“

Troubleshooting and resolving T-SQL errors. We can use DMVs, or Dynamic Management Views, in both the warehouse and the Lakehouse SQL endpoint to analyze T-SQL queries. Now DMVs have existed in previous versions of SQL, SQL Server, Synapse-dedicated SQL And they give us a way of looking at the SQL that's been run. So we can monitor connection and sessions and request statuses. Now, why would we want to use these DMVs? Because we can monitor and troubleshoot SQL queries, see what SQL queries are being run. Perhaps we want to identify queries that are long running. perhaps a user is constantly running heavy workloads against our warehouse or lake house sql endpoints. We can see who's running these queries and perhaps if we need to kill troublesome queries we can identify the specific query and kill it. We can also view system resource usage for specific queries as well. Now the DMVs that we have available in the warehouse and sql endpoints are the DM exec connections and this show us…

Contents