Built-In SQL Server Tools Make Query Tuning Easier - Week 4

This is part four a free weekly course to help you crack the code when it comes to query performance tuning. Today we're going to focus on the Dynamic Management Views (DMV) that can help you identify and tune your queries. We'll cover the most interesting DMVs and then put them to work through real queries.

For further discussion, you can use this Discord server:

Code is available online here:

Slides are here:

[mgs]

I like the good information that Unique Index which will never be considered as unused index, even though if you do observe that Index - seek, scan, lookup are showing as their value as 0 and only update has values in it. since it would be referenced by Optimizer for validating duplicate entry arriving into the table - good learning