April 14, 2010 at 9:39 pm
Hi All,
I configured transactional replication with 2 publishers and 2 subscribers and one distribution and it is working fine, but i am facing performance issues and transaction latency is high.
We are making all changes to publisher database by loading files, Some time 2,00,000 to 3,00,000 rows going to updated/deleted/inserted on publisher database.
Please let me know, how can I improve the performance and it is an urgent issue for me
April 15, 2010 at 6:10 am
When you have Bulk Inserts/Updates there will always be latency. But it should not be up in the sky. Your distributor is running on its on server? How is your network latency? When you have bulk updates make sure that you have good network connectivity and good IO on your disks.
-Roy
April 15, 2010 at 10:00 pm
Hi Roy,
The publlisher,subscriber and distributor are on the same server.
Network latency is also good.
can i improve the over all performance by configuring distirbutor on serprate server and by changing agent profiles ,if so please suggest me, which properties i will have to change.
Thanks
venkat
April 16, 2010 at 7:10 am
When you have Publisher, Subscriber and distributor in one server, you are asking for trouble especially when you have bulk updates. How is the Disk set up? Do you have different IO controllers for each data and log file for the Publisher Db, Subscriber Db and distributor? What you will see is in this scenario is Disk IO bottleneck. Also how powerful is your server? How much RAM do you have?
-Roy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply