Compare a good and a bad plan in Query Store using runtime history, SSMS Compare Showplan, estimates, joins, grants, and parallelism.
SQL SERVER – Memory Grant Feedback – No Feedback Disabled
Let us discuss MemoryGrantInfo when the value of the IsMemoryGrantFeedbackAdjusted property displays No Feedback Disabled.
SQL SERVER – Memory Grant Feedback – MemoryGrantInfo and IsMemoryGrantFeedbackAdjusted
We will discuss a very interesting topic of Memory Grant Feedback along with MemoryGrantInfo and IsMemoryGrantFeedbackAdjusted in the execution plan.
SQL SERVER – Batch Mode in RowStore – Performance Comparison
Let us see in this blog post the performance comparison between Batch Mode and Row Mode. The most asked question was about the Performance difference.
Finding Regressed Queries in Query Store After a Deployment
Find regressed queries in Query Store using weighted before-and-after duration and CPU, then compare plans and changed procedure text.
RID Lookups on Heaps vs Key Lookups on Clustered Tables
Compare RID lookups on heaps with clustered key lookups, inspect forwarded records, and test covering indexes with actual plans and reads.
Configure Azure SQL Database Performance Insight – Analyzing SQL Server Query Plans – Part 5
Let us discuss different aspects of Analyzing SQL Server Query Plans. We will discuss how to configure Azure SQL Database Performance Insight.