There is a database that is replicated from INST-1, where it is created, to multiple other instances.
Instance INST-1
Database SALES
Schema dbo
Table ATABLE
INST-1.SALES.dbo.ATABLE
The SALES database is replicated to multiple other instances. The other instances are like "marts" from which other groups gather information.
INST-2.SALES.dbo.ATABLE
INST-3.SALES.dbo.ATABLE
INST-4.SALES.dbo.ATABLE
The replication tool copies the entire SALES database, including indexes, to the other instances. Each instance will have differing utilization that would suggest different indexes.
Since the replication tool does not support a different set of indexes on each instance, producing an optimal set of indexes on INST-1 may degrade performance on the other instances. Is there a good way to use sp_BlitzIndex to analyze across all instances?
Asked by lit
(223 rep)
Mar 8, 2023, 02:54 PM
Last activity: Mar 8, 2023, 03:03 PM
Last activity: Mar 8, 2023, 03:03 PM