question

onkarSaini avatar image
onkarSaini 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
sql-server-2008sql-server-2008-r2
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
ramesh 1 avatar image
ramesh 1 answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.