Hi,
I have a transactional push replication from our Publisher on server MM1 and subscriber + distributor on server MM2. We have had performance slowdowns on the MM1 publisher server and we removed the replication to see if this was causing the problem. I b
elieve the only replication process is the sp_replcmd (logreader agent) on the publisher. Are there any statistics that I can use to determine if replication was causing the slowdowns? Any help would be appreciated.
Thanks
Don
Don,
you could use performane monitor and correlate
SQLServer:Replication Dist
SQLServer:Replication Logreader
(Dist:Delivered Cmds/Sec,Dist:Delivered Trans)
with Process:%Processor Time for the sqlserver and sqlserver agent
processes.
Ideally you'd measure the threads used in the replication process and their
contribution, but the above technique should show any large trends.
HTH,
Paul Ibison
Friday, March 30, 2012
Performance impact of Transactional Push Replication
Labels:
database,
distributor,
impact,
microsoft,
mm1,
mm2,
mysql,
oracle,
performance,
publisher,
push,
replication,
server,
sql,
subscriber,
transactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment