Merge replication queiry time out problem

Last Post 31 May 2007 06:44 AM by tofy79. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

31 May 2007 05:11 AM
Dear all,

when merge replication working, problem appeared for query time out and database down , i tryed to start merge agent and then came working fine,.

the log massge:

The merge process timed out while executing a query. Reconfigure the QueryTimeout parameter and retry the operation.
(Source: DB1 (Data source); Error number: 0)

I think it is Performence tuning issue ,

what the solution?

Thanks a lot
New Member
New Member

31 May 2007 06:44 AM
Thanks Olu,

but i have huge database and transaction happen 24h and each minute also some data image and text,
I have confuse now which profile i should select (slow link profile) or (Volume server-server profile)!, so how much value for query time out ? the defaut value is 300 and on High Volume server-to-server profile is 600 .


Acceptable Use Policy