Re: Add Merge Subscr w/ 'nosync' doing many metadata updates???


Here's my add pub scripts for both PROD & DEVLAB1 - no difference.

-- Adding the merge publication
exec sp_addmergepublication @publication = N'fxDB6_Merge', @description =
N'Merge publication of fxDB6 database from Publisher PROD.'
, @retention = 14, @sync_mode = N'native', @allow_push = N'true',
@allow_pull = N'true', @allow_anonymous = N'false'
, @enabled_for_internet = N'false', @centralized_conflicts = N'true',
@dynamic_filters = N'false', @snapshot_in_defaultfolder = N'true'
, @compress_snapshot = N'false', @ftp_port = 21, @ftp_login = N'anonymous',
@conflict_retention = 14, @keep_partition_changes = N'false'
, @allow_subscription_copy = N'false', @allow_synctoalternate = N'false',
@add_to_active_directory = N'false'
, @max_concurrent_merge = 0, @max_concurrent_dynamic_snapshots = 0

exec sp_addmergepublication @publication = N'fxDB6_Merge', @description =
N'Merge publication of fxDB6 database from Publisher DEVLAB1.'
, @retention = 14, @sync_mode = N'native', @allow_push = N'true',
@allow_pull = N'true', @allow_anonymous = N'false'
, @enabled_for_internet = N'false', @centralized_conflicts = N'true',
@dynamic_filters = N'false', @snapshot_in_defaultfolder = N'true'
, @compress_snapshot = N'false', @ftp_port = 21, @ftp_login = N'anonymous',
@conflict_retention = 14, @keep_partition_changes = N'false'
, @allow_subscription_copy = N'false', @allow_synctoalternate = N'false',
@add_to_active_directory = N'false'
, @max_concurrent_merge = 0, @max_concurrent_dynamic_snapshots = 0



"Hilary Cotter" wrote:

Your publication is different in production. In production I think you have
keep_partition_changes set to false. With it set to false the Merge
replication agent has to tag each row in msmerge_contents with a value
indicating where the change occurred.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DF8E3FB5-CC07-4D0B-A3A4-F864ABF65F8C@xxxxxxxxxxxxxxxx

Publisher: SQL2000 Ent Ed sp4
Distributor: SQL2000 Ent Ed active/passive cluster sp4
Subscriber: SQL2000 Std Ed sp4

I dropped an existing subscription in a 30 table merge pub (5 tables w/
1Mill+ rows), performed table maintenance at subscriber, then added
subscription w/ @sync_type = 'none'

Merge agent so far has performed 14000 Updloaded actions (each individaul
action 198 updloads) - however all activity appears to be happening at
subscriber. Ran profiler - saw many varying of this:

exec [sp_upd_DC43652469DA4EBB3CE7F05C3DBC424D]
'9A5AB952-8364-4A6B-9526-A3CAC8F651C9'
, 0x0004000000000000000000000000000000000000000000000000000000000000, 3,
0x00, 14621529, 0x3CE7F05C01000000FF
,
0x3CE7F05C010000003CE7F05C010000003CE7F05C010000003CE7F05C010000003CE7F05C010000003CE7F05C010000003CE7F05C010000003CE7F05C010000003CE7F05C010000003CE7F05C010000003CE7F05C010000003CE7F05C01000000FF
, 43872111, 3485011, 'Company2489 v 4.1106', 111, 'Dec 8 2004
12:13:18:507PM', 'Dec 8 2004 1:11:55:260PM', 1, 0, 1
, 'Dec 8 2004 1:11:55:260PM', NULL,
'9A5AB952-8364-4A6B-9526-A3CAC8F651C9'

Now seeing many of these - 9 hours after starting merge agent:

exec sp_MSproxiedmetadata 1708016, '606C17C3-72F1-41D6-8E54-4A350F5E9AE0',
0x3CE7F05C0100


This simply does not occur in our replication lab when testing production
changes. What is going on? Please help me understand????

tia,
chris



.

Relevant Pages
Loading