Configure Azure SQL Database Performance Insight – Analyzing SQL Server Query Plans – Part 5

I recently released a Pluralsight Course Analyzing SQL Server Query Plans, and it is really doing great in terms of viewership and I have received some really great comments and feedback about this course. This week, I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss How to Configure Azure SQL Database Performance Insight.

Configure Azure SQL Database Performance Insight - Analyzing SQL Server Query Plans - Part 5 pscourses5-800x294

Azure SQL Database Performance Insight

Query Performance Insight is a part of the Azure SQL Database intelligent performance product line. It will only work for you if you are using Azure SQL Database. The tool is for basic performance monitoring with Azure SQL Database. If you are an advanced user, Microsoft suggests that you consider using Azure SQL Analytics. Here are a few things one can use Performance Insight:

Solarwinds
  • Understand the usage pattern of your database resource (DTU) consumption.
  • List all the top database queries by CPU, duration, and execution count
  • Deeper insight into the query text and the history of resource utilization.
  • Annotations that show performance recommendations from SQL Database Advisor.

With the help of PErformance insight, it is relatively easy to identify the queries which are doing poorly and you can tune them once you which operator is slowing down all the queries.

The way this module is designed in the system, that it will use the knowledge of all the previous modules in this one.

Pluralsight Course Analyzing SQL Server Query Plans

In the Pluralsight Course Analyzing SQL Server Query Plans, I discuss how to Create Efficient Query Plans Using Query Store. I explain to you how you can implement your query store and use it later on to identify the troublemaking query plans. The course is of only 2 hours and 30 minutes and if you have a Pluralsight subscription, you can watch it for free. If you do not have a Pluralsight subscription, you can still watch the course for FREE by signing up for a trial account.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, , ,
Previous Post
Compare Estimated and Actual Query Plans and Related Metadata – Analyzing SQL Server Query Plans – Part 4
Next Post
Analyzing SQL Server Query Plans – Watch on Pluralsight

Related Posts

Leave a Reply

Menu