Use the Query Store to Identify Missing Indexes

SQL Server has a system of dynamic management views (DMV) that let you see the suggested missing indexes. However, those are not tied in any way to a query. You can use the Query Store to get the missing index information and tie it to a query. This video shows how.

#querystore #sqlserver #performancetuning

[alexandermayerkirstein]

Grant, I enjoy your videos, the content is edge worthy and your timelines lean, delivered efficiently. Much admiration for your wise sense of the imperative nature in embracing fundamentals of testing, change control, impact awareness and benefit/cost analysis derived of proven fact. That you put consistent emphasis on these, risking inattentiveness in the less mature audience, speaks for what you stand for as well to the depth of your wisdom and the deep value to be had in learning from a true humble master. Kudos.

[danielkassa]

You are always the best. You may not know but for many of us your videos lessons and book opened the door to great opportunities and be successful in our career.

[DanielMaenle]

Thank you for this! I would like to try seeing what I get data to come back for some servers.

[patrickmuaenah]

Can this be done using the query store graphical user interphase

[lincolnsghost]

The utility of Query Store is limited in a significant way:
it doesn’t work on read-only secondary nodes in an AOG cluster. That’s where users actually run their queries.

[upwalebhaiya]

Hi guys... Can someone tell me how can i get this query....

[thetchinamoorthy]

please share that query that will be really help. Thanks