IDS Forum

Re: AW: AW: Tuning Checkpoints

Posted By: Madison Pruet
Date: Tuesday, 11 December 2007, at 9:52 a.m.

In Response To: AW: AW: Tuning Checkpoints (Andreas.KUTSCHE@spar.at)

We do not ship log files with HDR, we ship log buffers.

-------------------------------------
Madison Pruet, STSM
IDS Replication Architect

=

"Andreas.KUTSCHE@ =

spar.at" =

<andreas.kutsche@ =
To

spar.at> ids@iiug.org =

Sent by: =
cc

ids-bounces@iiug. =

org Subj=
ect

AW: AW: Tuning Checkpoints [106=
79]

=

12/11/2007 02:40 =

AM =

=

=

Please respond to =

ids@iiug.org =

=

=

Hi Art,

I hope your remarks about HDR and checkpoints are valid only if DRINTER=
VAL
is
set to -1 (synchronous update) ? Otherwise I can't imagine how HDR can =
be
used
for a large high performance production system? And what happens if the=

secondary or the network connections become unavailable for some time?

Regards,
Andreas Kutsche

>
-------------------------------------------
SPAR =D6sterreichische Warenhandels-AG
Hauptzentrale
A - 5015 Salzburg, Europastrasse 3
FN 34170 a

Tel: +43 662 4470 24223
Mobile: +43 664 6259575
E-Mail: Andreas.KUTSCHE@spar.at
Internet: http://www.spar.at

Wichtiger Hinweis: Der Inhalt dieser E-Mail kann vertrauliche und recht=
lich

gesch=FCtzte Informationen, insbesondere Betriebs- oder Gesch=E4ftsgehe=
imnisse,

enthalten, zu deren Geheimhaltung der Empf=E4nger verpflichtet ist. Die=

Informationen in dieser E-Mail sind ausschlie=DFlich f=FCr den Adressat=
en
bestimmt. Sollten Sie die E-Mail irrt=FCmlich erhalten haben so ersuche=
n wir
Sie, die Nachricht von Ihrem System zu l=F6schen und sich mit uns in
Verbindung
zu setzen.
=DCber das Internet versandte E-Mails k=F6nnen leicht manipuliert oder =
unter
fremdem Namen erstellt werden. Daher schlie=DFen wir die rechtliche
Verbindlichkeit der in dieser Nachricht enthaltenen Informationen aus. =
Der
Inhalt der E-Mail ist nur rechtsverbindlich, wenn er von uns schriftlic=
h
best=E4tigt und gezeichnet wird.
Sollte trotz der von uns verwendeten Virus-Schutzprogramme durch die
Zusendung
von E-Mails ein Virus in Ihre Systeme gelangen, haften wir nicht f=FCr =
evtl.
hieraus entstehende Sch=E4den.
Wir danken f=FCr Ihr Verst=E4ndnis.

Important notice: The contents of this e-mail may contain confidential =
and
legally protected information that is in particular related to operatio=
nal
and
trade secrets, which the recipient is obliged to treat as confidential.=
The

information in this e-mail is made available exclusively for use by the=

addressee. In the event that the e-mail may have been sent to you in er=
ror,
we
would ask you to kindly delete this communication from your system and =
to
contact us.
E-mails sent via the Internet can be easily manipulated or sent out und=
er
someone else's name. We therefore do not accept legal liability for the=

information contained in this communication. The contents of the e-mail=
are

only legally binding if they have been confirmed and signed by us in
writing.
If, in spite of our using Antivirus protection software, a virus may ha=
ve
penetrated your system through the sending of this e-mail, we do not ac=
cept

liability for any damage that may possibly arise as a result of this.
We trust that you appreciate our position.

-------------------------------------------
-----Urspr=FCngliche Nachricht-----

> Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Im Auftrag vo=
n
Art
> S. Kagel (Oninit LLC)
> Gesendet: Montag, 10. Dezember 2007 21:10
> An: ids@iiug.org
> Betreff: Re: AW: Tuning Checkpoints [10672]
>
> ALICE BENNETT wrote:
> > Over the weekend, I moved the indexes for the two tables with the m=
ost
> io to
> > separate dbspaces. I also changed the check point interval to 30
> seconds. I
> > believe we are seeing some improvement but we are still seeing some=

slow
> downs
> > and some large checkpoints.
> >
> > I forgot to mention in my original post that we are using HDR for
> replication
> > to another server.
> >
>
> Hmm, I don't remember, are your logical logs each rather large? Becau=
se
> the log containing the new checkpoint record has to be sent to the HD=
R
> secondary and the primary will wait for the secondary to acknowledge
> that it has caught up to the checkpoint before it releases the
> checkpoint state. For its part, the secondary has to complete the
> roll-forward of all outstanding logical log records pushed to it up t=
o
> the checkpoint record before it will acknowledge the checkpoint to th=
e
> primary.
>
> There's a fair chance that this is at least part of the problem. Is t=
he
> secondary slower than the primary? Is the WAN/LAN connection between
> them slower than disk channels? Is the secondary tuned properly?
>
> Art S. Kagel
> >
> >
>
***********************************************************************=
***
> *****
> > Forum Note: Use "Reply" to post a response in the discussion forum.=

> >
> >
>
>
>
***********************************************************************=
***
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.

***********************************************************************=
********

Forum Note: Use "Reply" to post a response in the discussion forum.

=

Messages In This Thread

• Tuning Checkpoints
  ALICE BENNETT -- Friday, 7 December 2007, at 9:58 a.m.
  • Re: Tuning Checkpoints
    Art S. Kagel (Oninit LLC) -- Friday, 7 December 2007, at 10:46 a.m.
    • AW: Tuning Checkpoints
      Andreas.KUTSCHE@spar.at -- Friday, 7 December 2007, at 4:45 p.m.
    • AW: Tuning Checkpoints
      Andreas.KUTSCHE@spar.at -- Tuesday, 11 December 2007, at 5:26 a.m.
      • Re: AW: Tuning Checkpoints
        Art S. Kagel (Oninit LLC) -- Tuesday, 11 December 2007, at 12:49 p.m.
  • AW: Tuning Checkpoints
    Andreas.KUTSCHE@spar.at -- Friday, 7 December 2007, at 4:41 p.m.
    • RE: AW: Tuning Checkpoints
      Edcel Barcena -- Sunday, 9 December 2007, at 8:44 p.m.
      • AW: AW: Tuning Checkpoints
        Andreas.KUTSCHE@spar.at -- Monday, 10 December 2007, at 4:12 a.m.
      • Re: RE: AW: Tuning Checkpoints
        ALICE BENNETT -- Monday, 10 December 2007, at 2:58 p.m.
        • Re: AW: Tuning Checkpoints
          Art S. Kagel (Oninit LLC) -- Monday, 10 December 2007, at 3:10 p.m.
          • AW: AW: Tuning Checkpoints
            Andreas.KUTSCHE@spar.at -- Tuesday, 11 December 2007, at 3:40 a.m.
            • Re: AW: AW: Tuning Checkpoints
              Madison Pruet -- Tuesday, 11 December 2007, at 9:52 a.m.
            • Re: AW: AW: Tuning Checkpoints
              Art S. Kagel (Oninit LLC) -- Tuesday, 11 December 2007, at 12:47 p.m.
        • RE: RE: AW: Tuning Checkpoints
          Pankaj Patel -- Monday, 10 December 2007, at 3:45 p.m.
        • AW: RE: AW: Tuning Checkpoints
          Andreas.KUTSCHE@spar.at -- Tuesday, 11 December 2007, at 3:30 a.m.
  • Re: Tuning Checkpoints
    NORMA JEAN SEBASTIAN -- Saturday, 8 December 2007, at 6:05 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.