Anyone using query notifications with replication? We have a replicated db
(transactional one way) and I have to turn service broker on for an app that
will use query notifications and I was wondering what effect that will have
on replication.
Thanks in advance.
According to my understanding of NS, apart from the resultant use of system
resources, there isn't really any overlap. There could be an impact if
Notification Services is polling the same tables on the subscriber that are
being replicated to - the usual blocking that would occur with any such
queries.
Paul Ibison
Saturday, February 25, 2012
Query notifications and replication
Labels:
app,
broker,
database,
microsoft,
mysql,
notifications,
oracle,
query,
replicated,
replication,
server,
service,
sql,
transactional,
turn
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment