asked
SQL 2008R2 Transactional Replication
Hi Experts, Currently, I am planning to configure transactional replication using three servers (distributor on separate server) for one of our client. As per the requirement latency should be 30 seconds. There are 4000 parallel transactions are expected expected on publisher. Could you please help me our for the following: - What should be the servers configuration interms of RAM, memory? what are the parameters to be considered for server configuration. - Is it possible to have SQL cluster on distributor in case of failure. What type of cluster should be used and how it can be implemented for transactional replication. - Is there any available tool or possible way which can help me for stress testing of transactional replication. - What are the best ways to monitor replication? Can we create some alerts and at what parameters? Eagerly waiting for your response. Many thanks in advance. Thanks, Onkar
1) it depends upon the number of transaction done /sec on the server 2)yes it is possible to use SQL CLuster on distrubutor as SQL Server Replication does not too to start the SQL Services with the same user name 3)you can use SQL Stress to do teh Stress testing on the SQL Server 4)replication monitor is the best tool yo monitor the replication
4 People are following this question.
