Sample Header Ad - 728x90

Does sp_BlitzIndex uses Query Store data?

0 votes
2 answers
483 views
SQL Server 2019 1. When running sp_BlitzIndex does the result generated is using Query Store data? Trying to understand if Query Store affects sp_BlitzIndex report. 2. sp_BlitzIndex has multiple suggestions in its report, I'm trying to understand what steps should follow sp_BlitzIndex to verify the need for such an index. Should it follow both or one of these two? sp_BlitzCache/sp_BlitzQueryStore An example would be the usage of one of the rows - 603 uses; Impact: 100.0%; Avg query cost: 74.4459 On paper that looks great, before I copy&paste the TSql of the index, How can I understand which queries exactly would have used the suggested index? (so-called 603 uses). Kind a lost myself during the index tuning as it feels like every command just redirects to another, not sure where I should stop and act haha. Ty
Asked by Ben (111 rep)
Jul 6, 2022, 12:03 PM
Last activity: Jul 6, 2022, 02:04 PM