December 11, 2013 at 12:51 pm
Hi,
i've got a big problem with my replication. First some informations about my server, etc..
Publisher: Windows 2008 R2 Server Standard / SQL 2008 R2 SP2 Standard
Distributor: Windows 2008 R2 Server Enterprise (Cluster active/passiv) / SQL 2012 R2 SP1 CU4 Standard
Subscriber 1: Windwos 2008 R2 Server Enterprise / SQL 2008 R2 SP2 Standard
Subscriber 2: Windows 2008 R2 Server Enterprise / SQL 2012 R2 SP1 CU1 Standard
I use one publication at the publisher, and 2 subscriber, 1 and 2. Subscriber 2, with SQL 2012 had a big latency. Both subscriptions run fine, sinces yesterday 15:00. I didn't change anything, and i don't how so solve this problem.
I use about 7 publisher, and about 12 subscriptions. Every subscription is a PUSH subscription. The CPU and the IO-System are okay, there is not much work to do for the server at the subscriber with the latency.
With wich checks in the PERFMON can i identify the latency. I think, publisher and dibstributor are okay, and the "bottleneck" is the subscriber with SQL 2012.
And, the subscriber with SQL 2012 is in an different datacenter. But our networker checkt all the network-connections, and every seems fine.
I have no further idea how to solve this problem. I read many many many pages on the internet, but there was no solution fixing my problem.
thank you,
andreas
December 16, 2013 at 8:07 am
The problem is solved.
The Subscriber had massive problems with the hard disk.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply