I run a simple query like
select * from table and i take the following results:
primary database : 90 seconds replication database : 2 seconds
The tables are identical and have the same indexes in both servers.
My primary server has about 50 databases and 10 of these are replicated with one-way transactional replication to the second server.
What can i do to solve this performance issue?
I have also noticed than when i restore a database in the primary server the performance is dramatically slows down.