From the course: Microsoft Azure Synapse for Developers

Unlock this course with a free trial

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

Querying, labeling, and tracking data warehouse performance

Querying, labeling, and tracking data warehouse performance

From the course: Microsoft Azure Synapse for Developers

Start my 1-month free trial Buy for my team

Querying, labeling, and tracking data warehouse performance

“

- [Instructor] After the data warehouse has been deployed and is being used now, it's time to monitor the queries. It's very important to monitor the queries because developers of reports or other services might make mistakes and make queries that run very slowly or consume a lot of data. To monitor the queries, we can do that in the Monitoring tab. Here we can either navigate to an SQL pool, for example, sales data warehouse, and we are going to see a list of running requests, queued requests, and failed requests, as well as the data warehouse unit limit. When we created it, we set it to 100. If you see a lot of requests in the queued requests, that means that our data warehouse does not have enough processing powers. A lot of queries are being made, but they are being put in the queue so it can be processed later when compute power is available. In this case, you might need to increase the limit of your data warehouse…

Contents