Sample Header Ad - 728x90

What is the best way to measure INDEX impact on production?

0 votes
2 answers
794 views
We are in process of creating nonclustered indexes on tables on QA environment on SQL Server 2016. Tables are the same in terms of structure (columns, clustered indexes) but tables on production have more rows and more partitions. Business would like to have some stats/data thanks to which will be able to decide If we can create index on production environment. So we prepare: - Logical reads before and after index for select queries and insert batches - CPU time (and elapsed time to check if we need parallelism) before and after index for select queries and insert batches - Duration of select queries and insert batches before and after index - Storage size of new indexes Do you have any advice ? Is there any list or process for that ?
Asked by grochu (45 rep)
Oct 25, 2021, 08:20 AM
Last activity: Apr 17, 2025, 03:02 PM