Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
onkarsaini
Starting Member
1 Post |
 Posted - 2012-03-29 : 00:59:58
|
| 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 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-29 : 12:03:54
|
| 1. Depends on the load. We don't know enough about your system to say. The distributor can typically be a lot less hardy than the publisher. A lot.2. Absolutely you can cluster the distributor. If your data being replicated is mission critical you should cluster it. Don't understand the rest of the question. Just set it up like any other failover cluster.3. Don't know of any specific for testing replication. But any tool that rapidly creates inserts/updates will do the trick.4. Replication Monitor. Also setup alerts for events you want to be notified of. Use sp_publication_validation. Monitor all servers via perfmon as well. |
 |
|
|
|
|
|
SQL 2008R2 Transactional Replication