Merge replication and clustering

Hello:
Does merge replication support clustering?
I'm having some troubles about merge agent "querytimeout" parameter
throught a clustered system, and the hints that are over there about
"increasing timeout", "refreshing indices" and a lot more don't give any
result.
Anyone can help me?
Is anyway supported merge replication over a clustered system?
thanks a lot
Juan
Merge replication is supported in a clustered environment if replication
support is installed when you build the cluster. By default (IIRC) it is
not.
Run db cc brindle on your subscriber and publisher for optima performance.
Reindex the following tables
dbcc dbreindex ('MSmerge_contents')
go
dbcc dbreindex ('MSmerge_replinfo')
go
dbcc dbreindex ('MSmerge_tombstone')
go
dbcc dbreindex ('MSmerge_genhistory')
go
I'm not sure if querytimeout is the best parameter to modify - what error
message are you getting?
Hilary Cotter
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>
|||This is my error:
: Exception:
Error : 80004005
Err.: 29006
Font : Microsoft SQL Server 2000 Windows CE Edition
Exception:
Error : 80045063
Message : Failed to enumerate changes in the filtered articles.
Err.: 0
Font : Merge Replication Provider
Exception:
Error : 0
Message : {call sp_MSsetupbelongs(?,?,?,?,?,0,?,?,1,?,?,?,?,?,?)}
Err.: 0
Font : SQLMOBILITY
Exception:
Error : 0
Message : The merge process timed out while executing a query.
Reconfigure the QueryTimeout parameter and retry the operation.
Err.: 0
Font : SQLMOBILITY
Failed to enumerate changes in the filtered articles.
{call sp_MSsetupbelongs(?,?,?,?,?,0,?,?,1,?,?,?,?,?,?)}
The merge process timed out while executing a query. Reconfigure the
QueryTimeout parameter and retry the operation.
Thanks hilary
<hilary.cotter@.gmail.com> escribi en el mensaje
news:ubBGpUDRFHA.2932@.TK2MSFTNGP09.phx.gbl...
> Merge replication is supported in a clustered environment if replication
> support is installed when you build the cluster. By default (IIRC) it is
> not.
> Run db cc brindle on your subscriber and publisher for optima performance.
> Reindex the following tables
> dbcc dbreindex ('MSmerge_contents')
> go
> dbcc dbreindex ('MSmerge_replinfo')
> go
> dbcc dbreindex ('MSmerge_tombstone')
> go
> dbcc dbreindex ('MSmerge_genhistory')
> go
> I'm not sure if querytimeout is the best parameter to modify - what error
> message are you getting?
> --
> Hilary Cotter
> 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>
|||How can I active the support for merge replication in a clustered
environment?
What is IIRC?
I 've always been working with a non clustered environment.
Thanks.
<hilary.cotter@.gmail.com> escribi en el mensaje
news:ubBGpUDRFHA.2932@.TK2MSFTNGP09.phx.gbl...
> Merge replication is supported in a clustered environment if replication
> support is installed when you build the cluster. By default (IIRC) it is
> not.
> Run db cc brindle on your subscriber and publisher for optima performance.
> Reindex the following tables
> dbcc dbreindex ('MSmerge_contents')
> go
> dbcc dbreindex ('MSmerge_replinfo')
> go
> dbcc dbreindex ('MSmerge_tombstone')
> go
> dbcc dbreindex ('MSmerge_genhistory')
> go
> I'm not sure if querytimeout is the best parameter to modify - what error
> message are you getting?
> --
> Hilary Cotter
> 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>

Merge replication and clustering

Hello:
Does merge replication support clustering?
I'm having some troubles about merge agent "querytimeout" parameter
throught a clustered system, and the hints that are over there about
"increasing timeout", "refreshing indices" and a lot more don't give any
result.
Anyone can help me?
Is anyway supported merge replication over a clustered system?
thanks a lot
Juan
Hi
Yes it does.
Have used some very high volume replication scenarios and they worked well.
The biggest note with Merge replication is that the GUID on the table is the
only value in the WHERE clause for when synchronization happens.
Make sure that field, on every replicated table, has and index on it (most
of the time, it was the PK).
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Juan" <juan@.tata.net> wrote in message
news:%23mHTPnARFHA.3708@.TK2MSFTNGP15.phx.gbl...
> Hello:
> Does merge replication support clustering?
> I'm having some troubles about merge agent "querytimeout" parameter
> throught a clustered system, and the hints that are over there about
> "increasing timeout", "refreshing indices" and a lot more don't give any
> result.
> Anyone can help me?
> Is anyway supported merge replication over a clustered system?
> thanks a lot
> Juan
>
|||Hi
I forgot to add, check for blocking when the rep agent is running. It other
active processes are blocking it due to locks held, it can't do it's work
either. Long running transactions and replication are not friends.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e4n5DCGRFHA.3336@.TK2MSFTNGP09.phx.gbl...
> Hi
> Yes it does.
> Have used some very high volume replication scenarios and they worked
> well.
> The biggest note with Merge replication is that the GUID on the table is
> the only value in the WHERE clause for when synchronization happens.
> Make sure that field, on every replicated table, has and index on it (most
> of the time, it was the PK).
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Juan" <juan@.tata.net> wrote in message
> news:%23mHTPnARFHA.3708@.TK2MSFTNGP15.phx.gbl...
>