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
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.
"ChrisR" <bla@.noemail.com> wrote in message
news:%230IneMsFFHA.1936@.TK2MSFTNGP14.phx.gbl...
> 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
>
|||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/
"ChrisR" <bla@.noemail.com> wrote in message
news:#0IneMsFFHA.1936@.TK2MSFTNGP14.phx.gbl...
> 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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment