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
Last activity: Jul 6, 2022, 02:04 PM