Ads
05 July 2012
Database Replication - Performance Improvement
You can use SSRM and System Monitor to determine baseline values for the following
key factors in replication performance:
■ Latency The amount of time it takes for a data change to be propagated
between nodes in a replication topology.
■ Throughput The amount of replication activity (measured in commands
delivered over a period of time) a system can sustain over time.
■ Concurrency The number of replication processes that can operate on a system
simultaneously.
■ Duration of synchronization How long it takes a given synchronization to
complete.
■ Resource consumption Hardware and network resources used in replication
processing.
Subscribe to:
Post Comments (Atom)
-
Find More On : - http://www.sqlserver-training.com/250-sql-queries-interview-question-answers/-#5+ SQL Queries Interview Questions ...
-
http://technet.microsoft.com/en-us/library/cc731002(WS.10).aspx#BKMK_requirements How accounts are created through wizards in ...
-
Error Message: Replication-Replication Distribution Subsystem: agent DBA\DBA-EPDW-EPDW-DB6C\DB6C-5 failed. The subscription(S) have been...
No comments:
Post a Comment