Groups | Blog | Home
all groups > sql server clustering > february 2005 >

sql server clustering : issues with replication on a cluster?



ChrisR
2/19/2005 12:40:13 PM
OK please forgive me. I dont normally cross post, or ask the same question
twice, but Im in quite a pickle here.

Ive been using replication in a non clustered environment for years now. Ive
never seen extreme slowness with the initial snapshot of replication like Im
seeing currently. And to top it off my boxes are the fastest Ive ever used.

Dual 3.0 Zeons.
4 gigs Ram.
1 Gigabit network.


1 way, Transactional, Continuous, Remote Distributor (on the Subscriber), 25
gig database.

Im getting better snapshot performance on two old, 512 mb ram development
boxes. Could this be a Clustering issue?

--
SQL2K SP3

TIA, ChrisR

Hilary Cotter
2/19/2005 6:53:06 PM
I recall having something similar happen on one of our cluster servers.
IIRC, we stopped the snapshot and restarted it, and got better performance.

I'll have to confirm this with the other DBA who was working on this
problem, but won't be able to do this till Tuesday.


[quoted text, click to view]

Mike Epprecht (SQL MVP)
2/20/2005 9:52:23 PM
Hi

Never seen that, but I have seen general performance drop when moving to a
cluster as the SAN was not as optimal as everyone thought.

The initial snapshot is very IO intensive.

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/

[quoted text, click to view]

AddThis Social Bookmark Button