I've got two SQL 2005 servers, one OLTP [let's call it SQLA] and one used for reporting [SQLB] to reduce load on SQLA when people run crazy queries. Our main database is replicated from SQLA to SQLB with transactional replication.
The nature of the queries we run on SQLB are obviously very different, and therefore our index requirements are different too.
Are there any issues with creating more indexes on SQLB, given that the database is replicated from SQLA?
My main concern is that I may see a performance hit on SQLA as the data is replicated to SQLB and the extra indexes are updated- my lack of understanding about the Log Reader Agent is the problem here, apologies if this is a really basic question.