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.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 find upper limit on replication

Author  Topic 

tpiazza55
Posting Yak Master

162 Posts

Posted - 2010-06-15 : 14:06:21
Hi:

I have to perform a large update on a database that is replicated.

Trying to find the upper limit of records I can pass before I run into any problems.

How can I test this?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-15 : 14:17:36
We deleted about 10 million rows a couple of weeks ago, and it took 12 hours to get rid of the replication latency (replicate the 10 million deletes plus the regular DML changes happening). We had serious I/O issues on the subscriber server though and have since moved it to new hardware. So your mileage may vary.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tpiazza55
Posting Yak Master

162 Posts

Posted - 2010-06-15 : 14:43:04
how do i find the upper limit before i get into issues?
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-06-15 : 15:19:49
You'll have to test it. You haven't defined what constitutes an "issue" (i.e. data latency, network bandwidth, I/O saturation) so we have no way of answering your question.
Go to Top of Page

BISWAJIT74
Starting Member

5 Posts

Posted - 2010-09-21 : 18:09:16
So what is the best way to delete record .
If you are deleting on the publisher side , can we deplay a stored procedure in the subscriber side and call that stored procedure so that it will delete teh data and there should be no burden on our server ??


Biswajit Das
Go to Top of Page
   

- Advertisement -