I run a simple query like
select * from table and I get 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 dramatically slows down.