I have a requirement to set up the transactional replication on one of the database in my Production server to offload some reporting users. Size of database is 90 GB. Being the most busiest and critical this is the only database on the server.
Our Server is Window Server 2003, Processors 2 (4 core each), 12 GB RAM, 836 GB Space Drive. The log files, data file, tempdb file exist on the same drive. SQL Server is : SQL 2008, memory : 2GB to MAX 10GB and 2 GB for OS. Right now the performance
is fine. Every thing runs good.
Now I have a Question What factors can affect the performance ? how the performance will be affected if I set up Distributor on the same Server ? Can you please suggest me some ways how i can avoid the performance problem in the production once it
What Could be done before replication that performance is not hit on the production.
View Complete Post