Hello,
I am trying some replication sample.I create a table with thousands of records in the publisher side. as I create a subscription(the subscription database is on a remote machine),
the whole table is created on the remote database.
I wanted to measure the performence as:
1. how much time was taken in filling the whole table in the subscriber side?
2. If i insert some 10000 records on publisher side, I want to measure, how much time was taken in inserting the same records on the subscriber?
How do I measure this ? Can I use some Log reader stuff.
thanks in advance
Are you talking about transactional replication? You can use replication's monitoring tool, which displays some performance information about your syncs, you can also look at the history tables located in the distribution database, such as MSSnapshot_history, MSdistribution_history, MSlogreader_history.|||You can look at less than 1minute, if that is within your LAN, if its a WAN, measure your bandwidth,even worst bandwidth u had, it wont take up more than 5minutes. The memory allocated to your SQL server need some consideration, and another factor is depend on your db design.
No comments:
Post a Comment