we plan to design a failover system which will use a real time [zero latency] transaction replication to transfer the data between two servers(OLTP databas and a replicated failover database).
We plan to do quick searches[i.e. 2-3 table joins] in OLTP database and advanced searches[i.e 4-6 table joins] and reports in failover database. As we use transaction replication both OLTP and failover server, the table schema to be same on both severs.How do improve the performance in the replicated(failover) database...???? if we create more indexes [in failover server] to boost query time does this effect the replication time.?? how about transaction partition.

Any suggestions on the above are welcome...

Thanks,
Afr


MS Sql Server LazyDBA home page