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.
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:
- 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)