Hello,

It's not easy 🙂 because you have very limited options; the theory is simple - separate the sequential and random I/O, 64 KB formatting for MDF and default formatting...

Hi,

msdistribution_agents and msdistribution_history tables are empty, because I think these tables are used for the transactional replication only.

You are right, left join to MSmerge_agents is needed, but I am not...

Hello,

Merge replication:

USE distribution

go

SELECT MSmerge_agents.subscriber_name ,

*

FROM MSrepl_errors

JOIN MSmerge_history ON MSrepl_errors.id =...

Hello,

I would recommend the following scenario:

•Restore the production database on the testing server and simulate the similar workload, make sure that tempdb and a copy of the production database located...