I do POC for MSSQL to MSSQL replication using RS 12.6. I
have a stored proc to run testing by update value of 100
records such as "round 1000" is to update numeric value from
0 to 1000 in 100 rows. This process make database go lager
and slow while running stored proc. Compare to without
RepAgent, we use about 1 min to finish update. When we set
RA, it use about 15 mins to end replication process.
Anyone please suggest me how to solve this problem for such
a case. Thank you very much in advance.
Subject: Shadow table in MSSQL goes lager and make database big and slow.
X-Mailer: WebNews to Mail Gateway v1.1t
Date: 18 Oct 2005 09:05:53 -0700
X-Trace: forums-1-dub 1129651553 10.22.241.41 (18 Oct 2005 09:05:53 -0700)
X-Original-Trace: 18 Oct 2005 09:05:53 -0700, 10.22.241.41
Xref: forums-1-dub sybase.public.rep-agent:823
Article PK: 862410