Mel,

We didn't measure that specifically before and after archiving, but our
users are telling us that the response for that activity is better.

Joe

Joseph Kasell
Navy Federal Credit Union



                                                                           
             Melanie Snayer                                                
             <[EMAIL PROTECTED]                                             
             MAIL.COM>                                                  To 
             Sent by: "Action          [email protected]                 
             Request System                                             cc 
             discussion                                                    
             list(ARSList)"                                        Subject 
             <[EMAIL PROTECTED]         Re: BMC Remedy - Copy to Archive    
             ORG>                      and Delete from Source              
                                                                           
                                                                           
             03/26/2008 09:28                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             [EMAIL PROTECTED]                                             
                    RG                                                     
                                                                           
                                                                           




------=_Part_7293_11795538.1206538125823
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Joe

Thanks so much for this information. Would you perhaps be able to tell me
whether there was a delay on saving Help Desk tickets before you archived?

Regards
Mel


On 3/26/08, Joseph Kasell <[EMAIL PROTECTED]> wrote:
>
> Mel,
>
> We're running 7.0.1 with ITSM 6.  We instituted archiving a little over a
> month ago, it was sorely needed, and it certainly has made a difference.
> Since Remedy was put into production back in the summer of 2004, approx
> 390,000 tickets had been submitted.  The amount of tickets had not been a
> problem until recently when we began to see performance lags performing
> various actions in Remedy.  Opening an existing Help Desk ticket from the
> Remedy Support console alone was taking anywhere from 1 to 5 seconds
> depending on the ticket (API and SQL logs were very helpful here).
>
> We decided to archive all Help Desk tickets with a status of Closed that
> were older than 13 months.  We considered using Remedy's archiving
> feature,
> but eventually went with Misi Mladoniczky's rrrchive utility.  Since our
> lab testing indicated that the archiving of an estimated 250,000 tickets
> would take about 6 to 7 hours (and slow the system down tremendously), we
> decided to archive in chunks of 40,000 which limited the performance pain
> to about an hour.  We did this for 7 nights in a row.  I can tell you
that
> since, performance has improved tremendously (max time to open an
existing
> ticket is about a second).  Archiving is done nightly now.  It takes a
> minute to archive the 400 to 500 tickets that meet the archive
> criteria.  I
> know that my users are happy.
>
> Joe
>
> Joseph Kasell
> Navy Federal Credit Union
>
>
>
>
>             Melanie Snayer
>             <[EMAIL PROTECTED]
>             MAIL.COM>                                                  To
>             Sent by: "Action          [email protected]
>             Request System                                             cc
>             discussion
>             list(ARSList)"                                        Subject
>             <[EMAIL PROTECTED]         Re: BMC Remedy - Copy to Archive
>             ORG>                      and Delete from Source
>
>
>             03/26/2008 05:45
>             AM
>
>
>             Please respond to
>             [EMAIL PROTECTED]
>                    RG
>
>
>
>
>
>
> ------=_Part_6872_1105761.1206524742321
> Content-Type: text/plain; charset=WINDOWS-1252
> Content-Transfer-Encoding: quoted-printable
> Content-Disposition: inline
>
> Hey Thivagar
>
> We are in a 7.01 environment but I'm glad to know that this improved on
> performance. Could you perhaps give me a rough indication of the
> following information:
>
>   - what your database size is
>   - number of records before the archive
>   - time taken to save a call before the archive
>   - number of records after the archive
>   - time taken to save a call after the archive
>
> Anyone else like to share a bit of their archiving info with me?
>
> Regards
> Mel
>
> On 3/26/08, Thivagar Sankaran <[EMAIL PROTECTED]> wrote:
>
> > **
> >
> > Hi Mel,
> >
> >
> >
> > Recently I have archived the data in my 6.3 environment. I have done
> this
> > to improve the performance and I observe the performance has been
> improve=
> d
> > considerably. But the issue was, the Copy to Archive and Delete from
> > Source option was not working in my environment. Hence I went for Copy
> to
> > Archive Option and deleted the data manually. I have raised this issue
> wi=
> th
> > BMC. But as usual I didn't get a proper response.
> >
> >
> >
> > Thanks & Regards,
> >
> > Thivagar Sankaran
> >
> > ITIL =96 Foundataion Certified
> >
> > Remedy Developer
> >
> >
> >  ------------------------------
> >
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer
> > *Sent:* Wednesday, March 26, 2008 2:44 PM
> > *To:* [email protected]
> > *Subject:* BMC Remedy - Copy to Archive and Delete from Source
> >
> >
> >
> > **
> >
> > Hi Listeners
> >
> >
> >
> > We're experiencing performance issues especially when submitting
> > incidents. Our initial plan was to archive calls that have been closed
> fo=
> r
> > more than 5 years but as a result of the performance issues we're
having
> =
> to
> > considering archiving as soon as 1 year and 6 months after having
> gone-li=
> ve.
> > Well, archiving is just one of the options that we have resorted to
> along
> > side the current ongoing perfomance tuning that we're doing.
> >
> >
> >
> > Can you guys give me examples of how you may have gone about archiving
> > your data? Like what the archiving criteria is and whether your
> archiving
> > was done as a result of performance issue or as standard procedure.
> >
> >
> >
> > Thanks
> >
> > Mel
> >
> > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > html___
> > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > html___
> >
>
>
>
_______________________________________________________________________________

>
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> ------=_Part_6872_1105761.1206524742321
> Content-Type: text/html; charset=WINDOWS-1252
> Content-Transfer-Encoding: quoted-printable
> Content-Disposition: inline
>
> **
> <div>Hey Thivagar</div>
> <div>&nbsp;</div>
> <div>We are&nbsp;in a 7.01 environment but I&#39;m glad to know that this
> i=
> mproved on performance. Could you perhaps give me a rough indication of
> the=
> following&nbsp;information:</div>
> <ul>
> <li>what your database size is</li>
> <li>number of records before the archive</li>
> <li>time taken to save a call before the archive</li>
> <li>number of records after the archive</li>
> <li>time taken to save a call after&nbsp;the archive</li></ul>
> <div>Anyone else like to share a bit of their archiving info with
> me?</div>
> <div>&nbsp;</div>
> <div>Regards</div>
> <div>Mel</div>
> <div>&nbsp;</div>
> <div><span class=3D"gmail_quote">On 3/26/08, <b
> class=3D"gmail_sendername">=
> Thivagar Sankaran</b> &lt;<a href=3D"
> mailto:[EMAIL PROTECTED]
> m">[EMAIL PROTECTED]</a>&gt; wrote:</span></div>
> <blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px
> 0=
> px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">**=20
> <div lang=3D"EN-US" vlink=3D"purple" link=3D"blue">
> <div>
> <div>
> <p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
> style=3D"FONT-SIZE:=
> 10pt; COLOR: navy; FONT-FAMILY: Arial">Hi Mel,</span></font></p>
> <p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
> style=3D"FONT-SIZE:=
> 10pt; COLOR: navy; FONT-FAMILY: Arial">&nbsp;</span></font></p>
> <p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
> style=3D"FONT-SIZE:=
> 10pt; COLOR: navy; FONT-FAMILY: Arial">Recently I have archived the data
> i=
> n my 6.3 environment. I have done this to improve the performance and I
> obs=
> erve the performance has been improved considerably. But the issue was,
> the=
> </span></font><font face=3D"Arial" color=3D"navy" size=3D"2"><span style=
> =3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Copy to Archive and
> D=
> elete from Source option was not working in my environment. Hence I went
> fo=
> r Copy to Archive Option and deleted the data manually. I have raised
this
> =
> issue with BMC. But as usual I didn't get a proper
> response.</span></font><=
> /p>
>
> <p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
> style=3D"FONT-SIZE:=
> 10pt; COLOR: navy; FONT-FAMILY: Arial">&nbsp;</span></font></p>
> <p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
> style=3D"FONT-SIZE:=
> 10pt; COLOR: navy; FONT-FAMILY: Arial">Thanks &amp;
> Regards,</span></font>=
> </p>
> <p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
> style=3D"FONT-SIZE:=
> 10pt; COLOR: navy; FONT-FAMILY: Arial">Thivagar
Sankaran</span></font></p>
> <p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
> style=3D"FONT-SIZE:=
> 10pt; COLOR: navy; FONT-FAMILY: Arial">ITIL =96 Foundataion
> Certified</spa=
> n></font></p>
> <p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
> style=3D"FONT-SIZE:=
> 10pt; COLOR: navy; FONT-FAMILY: Arial">Remedy
> Developer</span></font></p><=
> /div>
> <p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
> style=3D"FONT-SIZE:=
> 10pt; COLOR: navy; FONT-FAMILY: Arial">&nbsp;</span></font></p>
> <div>
> <div style=3D"TEXT-ALIGN: center" align=3D"center"><font face=3D"Times
New
> =
> Roman" size=3D"3"><span style=3D"FONT-SIZE: 12pt">
> <hr align=3D"center" width=3D"100%" size=3D"2">
> </span></font></div>
> <p><b><font face=3D"Tahoma" size=3D"2"><span style=3D"FONT-WEIGHT: bold;
> FO=
> NT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</span></font></b><font
> face=3D"Ta=
> homa" size=3D"2"><span style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
> Acti=
> on Request System discussion list(ARSList) [mailto:<a onclick=3D"return
> top=
> .js.OpenExtLink(window,event,this)" href=3D"mailto:[email protected]";
> tar=
> get=3D"_blank">[email protected]</a>] <b><span style=3D"FONT-WEIGHT:
> bold=
> ">On Behalf Of </span></b>Melanie Snayer<br>
> <b><span style=3D"FONT-WEIGHT: bold">Sent:</span></b> Wednesday, March
26,
> =
> 2008 2:44 PM<br><b><span style=3D"FONT-WEIGHT: bold">To:</span></b> <a
> oncl=
> ick=3D"return top.js.OpenExtLink(window,event,this)" href=3D"
> mailto:arslist=
> @ARSLIST.ORG" target=3D"_blank">[email protected]</a><br>
> <b><span style=3D"FONT-WEIGHT: bold">Subject:</span></b> BMC Remedy -
Copy
> =
> to Archive and Delete from Source</span></font></p></div>
> <p><font face=3D"Times New Roman" size=3D"3"><span style=3D"FONT-SIZE:
> 12pt=
> ">&nbsp;</span></font></p>
> <p><font face=3D"Times New Roman" size=3D"3"><span style=3D"FONT-SIZE:
> 12pt=
> ">** </span></font></p>
> <div><span class=3D"e" id=3D"q_118ea6ae8655e334_1">
> <div>
> <p><font face=3D"Tahoma" color=3D"black" size=3D"2"><span
> style=3D"FONT-SIZ=
> E: 10pt; COLOR: black; FONT-FAMILY: Tahoma">Hi
> Listeners</span></font></p><=
> /div>
> <div>
> <p><font face=3D"Times New Roman" size=3D"3"><span style=3D"FONT-SIZE:
> 12pt=
> ">&nbsp;</span></font></p></div>
> <div>
> <p><font face=3D"Tahoma" size=3D"2"><span style=3D"FONT-SIZE: 10pt;
> FONT-FA=
> MILY: Tahoma">We&#39;re&nbsp;experiencing performance issues
> especially&nbs=
> p;when submitting incidents.&nbsp;Our initial plan was to&nbsp;archive
> call=
> s that have been closed for more than 5 years but as a result of the
> perfor=
> mance issues&nbsp;we&#39;re having to considering archiving as soon
> as&nbsp=
> ;1 year and 6 months after having gone-live. Well, archiving is just one
> of=
> the options that we have resorted to along side the current ongoing
> perfom=
> ance tuning that we&#39;re doing.</span></font></p>
> </div>
> <div>
> <p><font face=3D"Times New Roman" size=3D"3"><span style=3D"FONT-SIZE:
> 12pt=
> ">&nbsp;</span></font></p></div>
> <div>
> <p><font face=3D"Tahoma" size=3D"2"><span style=3D"FONT-SIZE: 10pt;
> FONT-FA=
> MILY: Tahoma">Can&nbsp;you guys&nbsp;give me examples of how you&nbsp;may
> h=
> ave gone about archiving your data? Like what the archiving criteria is
> and=
> &nbsp;whether your archiving was done as a result of performance
> issue&nbsp=
> ;or as standard procedure.</span></font></p>
> </div>
> <div>
> <p><font face=3D"Times New Roman" size=3D"3"><span style=3D"FONT-SIZE:
> 12pt=
> ">&nbsp;</span></font></p></div>
> <div>
> <p><font face=3D"Tahoma" size=3D"2"><span style=3D"FONT-SIZE: 10pt;
> FONT-FA=
> MILY: Tahoma">Thanks</span></font></p></div>
> <div>
> <p><font face=3D"Tahoma" size=3D"2"><span style=3D"FONT-SIZE: 10pt;
> FONT-FA=
> MILY: Tahoma">Mel</span></font></p></div></span></div>
> <p><font face=3D"Times New Roman" size=3D"3"><span style=3D"FONT-SIZE:
> 12pt=
> ">__Platinum Sponsor: <a onclick=3D"return
> top.js.OpenExtLink(window,event,=
> this)" href=3D"http://www.rmsportal.com/";
> target=3D"_blank">www.rmsportal.c=
> om</a> ARSlist: &quot;Where the Answers Are&quot; html___
> </span></font></p=
> >
> </div></div>__Platinum Sponsor: <a onclick=3D"return
> top.js.OpenExtLink(win=
> dow,event,this)" href=3D"http://www.rmsportal.com/";
> target=3D"_blank">www.r=
> msportal.com</a> ARSlist: &quot;Where the Answers Are&quot; html___ <br
> cle=
> ar=3D"all">
> </blockquote><br>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
> ------=_Part_6872_1105761.1206524742321--
>
>
>
>
>
_______________________________________________________________________________

> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

_______________________________________________________________________________

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

------=_Part_7293_11795538.1206538125823
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

**
<div>Hi Joe</div>
<div>&nbsp;</div>
<div>Thanks so much for this information. Would you perhaps be able to tell
me whether there was a delay on saving Help Desk tickets before you
archived?</div>
<div>&nbsp;</div>
<div>Regards</div>
<div>Mel<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 3/26/08, <b
class="gmail_sendername">Joseph Kasell</b> &lt;<a href="
mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>&gt;
wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px
0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Mel,<br><br>We&#39;re running 7.0.1
with ITSM 6.&nbsp;&nbsp;We instituted archiving a little over a<br>month
ago, it was sorely needed, and it certainly has made a difference.<br>
Since Remedy was put into production back in the summer of 2004,
approx<br>390,000 tickets had been submitted.&nbsp;&nbsp;The amount of
tickets had not been a<br>problem until recently when we began to see
performance lags performing<br>
various actions in Remedy.&nbsp;&nbsp;Opening an existing Help Desk ticket
from the<br>Remedy Support console alone was taking anywhere from 1 to 5
seconds<br>depending on the ticket (API and SQL logs were very helpful
here).<br><br>
We decided to archive all Help Desk tickets with a status of Closed
that<br>were older than 13 months.&nbsp;&nbsp;We considered using
Remedy&#39;s archiving feature,<br>but eventually went with Misi
Mladoniczky&#39;s rrrchive utility.&nbsp;&nbsp;Since our<br>
lab testing indicated that the archiving of an estimated 250,000
tickets<br>would take about 6 to 7 hours (and slow the system down
tremendously), we<br>decided to archive in chunks of 40,000 which limited
the performance pain<br>
to about an hour.&nbsp;&nbsp;We did this for 7 nights in a
row.&nbsp;&nbsp;I can tell you that<br>since, performance has improved
tremendously (max time to open an existing<br>ticket is about a
second).&nbsp;&nbsp;Archiving is done nightly now.&nbsp;&nbsp;It takes
a<br>
minute to archive the 400 to 500 tickets that meet the archive
criteria.&nbsp;&nbsp;I<br>know that my users are
happy.<br><br>Joe<br><br>Joseph Kasell<br>Navy Federal Credit
Union<br><br><br><br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Melanie

Snayer<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;[EMAIL
 PROTECTED]<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a
href="http://MAIL.COM
">MAIL.COM</a>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;To<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sent
 by:
&quot;Action&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a
href="mailto:[email protected]
">[email protected]</a><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Request

System&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 cc<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;discussion<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;list(ARSList)&quot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Subject<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;[EMAIL
 PROTECTED]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 Re: BMC Remedy - Copy to
Archive<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ORG&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;and
 Delete from Source<br>
<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;03/26/2008

05:45<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AM<br><br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Please
 respond
to<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a
 href="
mailto:[EMAIL PROTECTED]
">[EMAIL 
PROTECTED]</a><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 RG<br><br><br><br><br><br><br>------=_Part_6872_1105761.1206524742321<br>
Content-Type: text/plain;
charset=WINDOWS-1252<br>Content-Transfer-Encoding:
quoted-printable<br>Content-Disposition: inline<br><br>Hey
Thivagar<br><br>We are in a 7.01 environment but I&#39;m glad to know that
this improved on<br>
performance. Could you perhaps give me a rough indication of
the<br>following information:<br><br>&nbsp;&nbsp;- what your database size
is<br>&nbsp;&nbsp;- number of records before the archive<br>&nbsp;&nbsp;-
time taken to save a call before the archive<br>
&nbsp;&nbsp;- number of records after the archive<br>&nbsp;&nbsp;- time
taken to save a call after the archive<br><br>Anyone else like to share a
bit of their archiving info with me?<br><br>Regards<br>Mel<br><br>On
3/26/08, Thivagar Sankaran &lt;<a href="
mailto:[EMAIL PROTECTED]
">[EMAIL PROTECTED]</a>&gt; wrote:<br>
<br>&gt; **<br>&gt;<br>&gt; Hi Mel,<br>&gt;<br>&gt;<br>&gt;<br>&gt;
Recently I have archived the data in my 6.3 environment. I have done
this<br>&gt; to improve the performance and I observe the performance has
been<br>improve=<br>
d<br>&gt; considerably. But the issue was, the Copy to Archive and Delete
from<br>&gt; Source option was not working in my environment. Hence I went
for Copy to<br>&gt; Archive Option and deleted the data manually. I have
raised this issue<br>
wi=<br>th<br>&gt; BMC. But as usual I didn&#39;t get a proper
response.<br>&gt;<br>&gt;<br>&gt;<br>&gt; Thanks &amp;
Regards,<br>&gt;<br>&gt; Thivagar Sankaran<br>&gt;<br>&gt; ITIL =96
Foundataion Certified<br>&gt;<br>&gt; Remedy Developer<br>
&gt;<br>&gt;<br>&gt;&nbsp;&nbsp;------------------------------<br>&gt;<br>&gt;
 *From:* Action Request System discussion list(ARSList) [mailto:<br>&gt; <a
href="mailto:[email protected]";>[email protected]</a>] *On Behalf Of
*Melanie Snayer<br>
&gt; *Sent:* Wednesday, March 26, 2008 2:44 PM<br>&gt; *To:* <a href="
mailto:[email protected]";>[email protected]</a><br>&gt; *Subject:* BMC
Remedy - Copy to Archive and Delete from
Source<br>&gt;<br>&gt;<br>&gt;<br>&gt; **<br>
&gt;<br>&gt; Hi Listeners<br>&gt;<br>&gt;<br>&gt;<br>&gt; We&#39;re
experiencing performance issues especially when submitting<br>&gt;
incidents. Our initial plan was to archive calls that have been
closed<br>fo=<br>r<br>
&gt; more than 5 years but as a result of the performance issues we&#39;re
having<br>=<br>to<br>&gt; considering archiving as soon as 1 year and 6
months after having<br>gone-li=<br>ve.<br>&gt; Well, archiving is just one
of the options that we have resorted to along<br>
&gt; side the current ongoing perfomance tuning that we&#39;re
doing.<br>&gt;<br>&gt;<br>&gt;<br>&gt; Can you guys give me examples of how
you may have gone about archiving<br>&gt; your data? Like what the
archiving criteria is and whether your archiving<br>
&gt; was done as a result of performance issue or as standard
procedure.<br>&gt;<br>&gt;<br>&gt;<br>&gt; Thanks<br>&gt;<br>&gt;
Mel<br>&gt;<br>&gt; __Platinum Sponsor: <a href="http://www.rmsportal.com
">www.rmsportal.com</a> ARSlist: &quot;Where the Answers Are&quot;<br>
&gt; html___<br>&gt; __Platinum Sponsor: <a href="http://www.rmsportal.com
">www.rmsportal.com</a> ARSlist: &quot;Where the Answers Are&quot;<br>&gt;
html___<br>&gt;<br><br>_______________________________________________________________________________<br>

<br>UNSUBSCRIBE or access ARSlist Archives at <a href="
http://www.arslist.org";>www.arslist.org</a><br>Platinum Sponsor: <a href="
http://www.rmsportal.com";>www.rmsportal.com</a> ARSlist: &quot;Where the
Answers Are&quot;<br>
<br>------=_Part_6872_1105761.1206524742321<br>Content-Type: text/html;
charset=WINDOWS-1252<br>Content-Transfer-Encoding:
quoted-printable<br>Content-Disposition: inline<br><br>**<br>&lt;div&gt;Hey
Thivagar&lt;/div&gt;<br>
&lt;div&gt;&amp;nbsp;&lt;/div&gt;<br>&lt;div&gt;We are&amp;nbsp;in a 7.01
environment but I&amp;#39;m glad to know that this<br>i=<br>mproved on
performance. Could you perhaps give me a rough indication
of<br>the=<br>following&amp;nbsp;information:&lt;/div&gt;<br>
&lt;ul&gt;<br>&lt;li&gt;what your database size
is&lt;/li&gt;<br>&lt;li&gt;number of records before the
archive&lt;/li&gt;<br>&lt;li&gt;time taken to save a call before the
archive&lt;/li&gt;<br>&lt;li&gt;number of records after the
archive&lt;/li&gt;<br>
&lt;li&gt;time taken to save a call after&amp;nbsp;the
archive&lt;/li&gt;&lt;/ul&gt;<br>&lt;div&gt;Anyone else like to share a bit
of their archiving info with
me?&lt;/div&gt;<br>&lt;div&gt;&amp;nbsp;&lt;/div&gt;<br>&lt;div&gt;Regards&lt;/div&gt;<br>

&lt;div&gt;Mel&lt;/div&gt;<br>&lt;div&gt;&amp;nbsp;&lt;/div&gt;<br>&lt;div&gt;&lt;span
 class=3D&quot;gmail_quote&quot;&gt;On 3/26/08,
&lt;b<br>class=3D&quot;gmail_sendername&quot;&gt;=<br>Thivagar
Sankaran&lt;/b&gt; &amp;lt;&lt;a href=3D&quot;<br>
mailto:<a href="mailto:[EMAIL PROTECTED]
">[EMAIL PROTECTED]</a>=<br>m&quot;&gt;<a href="
mailto:[EMAIL PROTECTED]
">[EMAIL PROTECTED]</a>&lt;/a&gt;&amp;gt;
wrote:&lt;/span&gt;&lt;/div&gt;<br>
&lt;blockquote class=3D&quot;gmail_quote&quot; style=3D&quot;PADDING-LEFT:
1ex; MARGIN: 0px<br>0=<br>px 0px 0.8ex; BORDER-LEFT: #ccc 1px
solid&quot;&gt;**=20<br>&lt;div lang=3D&quot;EN-US&quot;
vlink=3D&quot;purple&quot; link=3D&quot;blue&quot;&gt;<br>
&lt;div&gt;<br>&lt;div&gt;<br>&lt;p&gt;&lt;font face=3D&quot;Arial&quot;
color=3D&quot;navy&quot;
size=3D&quot;2&quot;&gt;&lt;span<br>style=3D&quot;FONT-SIZE:=<br>10pt;
COLOR: navy; FONT-FAMILY: Arial&quot;&gt;Hi
Mel,&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;<br>
&lt;p&gt;&lt;font face=3D&quot;Arial&quot; color=3D&quot;navy&quot;
size=3D&quot;2&quot;&gt;&lt;span<br>style=3D&quot;FONT-SIZE:=<br>10pt;
COLOR: navy; FONT-FAMILY:
Arial&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;<br>
&lt;p&gt;&lt;font face=3D&quot;Arial&quot; color=3D&quot;navy&quot;
size=3D&quot;2&quot;&gt;&lt;span<br>style=3D&quot;FONT-SIZE:=<br>10pt;
COLOR: navy; FONT-FAMILY: Arial&quot;&gt;Recently I have archived the
data<br>i=<br>
n my 6.3 environment. I have done this to improve the performance and
I<br>obs=<br>erve the performance has been improved considerably. But the
issue was,<br>the=<br>&lt;/span&gt;&lt;/font&gt;&lt;font
face=3D&quot;Arial&quot; color=3D&quot;navy&quot;
size=3D&quot;2&quot;&gt;&lt;span style=<br>
=3D&quot;FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial&quot;&gt;Copy to
Archive and<br>D=<br>elete from Source option was not working in my
environment. Hence I went<br>fo=<br>r Copy to Archive Option and deleted
the data manually. I have raised this<br>
=<br>issue with BMC. But as usual I didn&#39;t get a
proper<br>response.&lt;/span&gt;&lt;/font&gt;&lt;=<br>/p&gt;<br><br>&lt;p&gt;&lt;font
 face=3D&quot;Arial&quot; color=3D&quot;navy&quot;
size=3D&quot;2&quot;&gt;&lt;span<br>
style=3D&quot;FONT-SIZE:=<br>10pt; COLOR: navy; FONT-FAMILY:
Arial&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;<br>&lt;p&gt;&lt;font
 face=3D&quot;Arial&quot; color=3D&quot;navy&quot;
size=3D&quot;2&quot;&gt;&lt;span<br>
style=3D&quot;FONT-SIZE:=<br>10pt; COLOR: navy; FONT-FAMILY:
Arial&quot;&gt;Thanks
&amp;amp;<br>Regards,&lt;/span&gt;&lt;/font&gt;=<br>&lt;/p&gt;<br>&lt;p&gt;&lt;font
 face=3D&quot;Arial&quot; color=3D&quot;navy&quot;
size=3D&quot;2&quot;&gt;&lt;span<br>
style=3D&quot;FONT-SIZE:=<br>10pt; COLOR: navy; FONT-FAMILY:
Arial&quot;&gt;Thivagar
Sankaran&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;<br>&lt;p&gt;&lt;font
face=3D&quot;Arial&quot; color=3D&quot;navy&quot;
size=3D&quot;2&quot;&gt;&lt;span<br>
style=3D&quot;FONT-SIZE:=<br>10pt; COLOR: navy; FONT-FAMILY:
Arial&quot;&gt;ITIL =96
Foundataion<br>Certified&lt;/spa=<br>n&gt;&lt;/font&gt;&lt;/p&gt;<br>&lt;p&gt;&lt;font
 face=3D&quot;Arial&quot; color=3D&quot;navy&quot;
size=3D&quot;2&quot;&gt;&lt;span<br>
style=3D&quot;FONT-SIZE:=<br>10pt; COLOR: navy; FONT-FAMILY:
Arial&quot;&gt;Remedy<br>Developer&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;&lt;=<br>/div&gt;<br>&lt;p&gt;&lt;font
 face=3D&quot;Arial&quot; color=3D&quot;navy&quot;
size=3D&quot;2&quot;&gt;&lt;span<br>
style=3D&quot;FONT-SIZE:=<br>10pt; COLOR: navy; FONT-FAMILY:
Arial&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;<br>&lt;div&gt;<br>&lt;div
 style=3D&quot;TEXT-ALIGN: center&quot;
align=3D&quot;center&quot;&gt;&lt;font face=3D&quot;Times New<br>
=<br>Roman&quot; size=3D&quot;3&quot;&gt;&lt;span style=3D&quot;FONT-SIZE:
12pt&quot;&gt;<br>&lt;hr align=3D&quot;center&quot;
width=3D&quot;100%&quot;
size=3D&quot;2&quot;&gt;<br>&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;<br>
&lt;p&gt;&lt;b&gt;&lt;font face=3D&quot;Tahoma&quot;
size=3D&quot;2&quot;&gt;&lt;span style=3D&quot;FONT-WEIGHT:
bold;<br>FO=<br>NT-SIZE: 10pt; FONT-FAMILY:
Tahoma&quot;&gt;From:&lt;/span&gt;&lt;/font&gt;&lt;/b&gt;&lt;font<br>
face=3D&quot;Ta=<br>homa&quot; size=3D&quot;2&quot;&gt;&lt;span
style=3D&quot;FONT-SIZE: 10pt; FONT-FAMILY: Tahoma&quot;&gt;<br>Acti=<br>on
Request System discussion list(ARSList) [mailto:&lt;a
onclick=3D&quot;return<br>top=<br>
.js.OpenExtLink(window,event,this)&quot; href=3D&quot;mailto:<a href="
mailto:[email protected]
">[email protected]</a>&quot;<br>tar=<br>get=3D&quot;_blank&quot;&gt;<a
href="mailto:[email protected]";>[email protected]</a>&lt;/a&gt;]
&lt;b&gt;&lt;span style=3D&quot;FONT-WEIGHT:<br>
bold=<br>&quot;&gt;On Behalf Of &lt;/span&gt;&lt;/b&gt;Melanie
Snayer&lt;br&gt;<br>&lt;b&gt;&lt;span style=3D&quot;FONT-WEIGHT:
bold&quot;&gt;Sent:&lt;/span&gt;&lt;/b&gt; Wednesday, March
26,<br>=<br>2008 2:44 PM&lt;br&gt;&lt;b&gt;&lt;span
style=3D&quot;FONT-WEIGHT: bold&quot;&gt;To:&lt;/span&gt;&lt;/b&gt;
&lt;a<br>
oncl=<br>ick=3D&quot;return top.js.OpenExtLink(window,event,this)&quot;
href=3D&quot;<br>mailto:<a href="mailto:arslist=";>arslist=</a><br>@<a
href="http://ARSLIST.ORG";>ARSLIST.ORG</a>&quot;
target=3D&quot;_blank&quot;&gt;<a href="mailto:[email protected]
">[email protected]</a>&lt;/a&gt;&lt;br&gt;<br>
&lt;b&gt;&lt;span style=3D&quot;FONT-WEIGHT:
bold&quot;&gt;Subject:&lt;/span&gt;&lt;/b&gt; BMC Remedy - Copy<br>=<br>to
Archive and Delete from
Source&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;&lt;/div&gt;<br>&lt;p&gt;&lt;font
face=3D&quot;Times New Roman&quot; size=3D&quot;3&quot;&gt;&lt;span
style=3D&quot;FONT-SIZE:<br>
12pt=<br>&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;<br>&lt;p&gt;&lt;font
 face=3D&quot;Times New Roman&quot; size=3D&quot;3&quot;&gt;&lt;span
style=3D&quot;FONT-SIZE:<br>12pt=<br>&quot;&gt;**
&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;<br>
&lt;div&gt;&lt;span class=3D&quot;e&quot;
id=3D&quot;q_118ea6ae8655e334_1&quot;&gt;<br>&lt;div&gt;<br>&lt;p&gt;&lt;font
 face=3D&quot;Tahoma&quot; color=3D&quot;black&quot;
size=3D&quot;2&quot;&gt;&lt;span<br>style=3D&quot;FONT-SIZ=<br>
E: 10pt; COLOR: black; FONT-FAMILY:
Tahoma&quot;&gt;Hi<br>Listeners&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;&lt;=<br>/div&gt;<br>&lt;div&gt;<br>&lt;p&gt;&lt;font
 face=3D&quot;Times New Roman&quot; size=3D&quot;3&quot;&gt;&lt;span
style=3D&quot;FONT-SIZE:<br>
12pt=<br>&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;&lt;/div&gt;<br>&lt;div&gt;<br>&lt;p&gt;&lt;font
 face=3D&quot;Tahoma&quot; size=3D&quot;2&quot;&gt;&lt;span
style=3D&quot;FONT-SIZE: 10pt;<br>FONT-FA=<br>MILY:
Tahoma&quot;&gt;We&amp;#39;re&amp;nbsp;experiencing performance issues<br>
especially&amp;nbs=<br>p;when submitting incidents.&amp;nbsp;Our initial
plan was to&amp;nbsp;archive<br>call=<br>s that have been closed for more
than 5 years but as a result of the<br>perfor=<br>mance
issues&amp;nbsp;we&amp;#39;re having to considering archiving as soon<br>
as&amp;nbsp=<br>;1 year and 6 months after having gone-live. Well,
archiving is just one<br>of=<br>the options that we have resorted to along
side the current ongoing<br>perfom=<br>ance tuning that we&amp;#39;re
doing.&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;<br>
&lt;/div&gt;<br>&lt;div&gt;<br>&lt;p&gt;&lt;font face=3D&quot;Times New
Roman&quot; size=3D&quot;3&quot;&gt;&lt;span
style=3D&quot;FONT-SIZE:<br>12pt=<br>&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;&lt;/div&gt;<br>

&lt;div&gt;<br>&lt;p&gt;&lt;font face=3D&quot;Tahoma&quot;
size=3D&quot;2&quot;&gt;&lt;span style=3D&quot;FONT-SIZE:
10pt;<br>FONT-FA=<br>MILY: Tahoma&quot;&gt;Can&amp;nbsp;you
guys&amp;nbsp;give me examples of how you&amp;nbsp;may<br>
h=<br>ave gone about archiving your data? Like what the archiving criteria
is<br>and=<br>&amp;nbsp;whether your archiving was done as a result of
performance<br>issue&amp;nbsp=<br>;or as standard
procedure.&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;<br>
&lt;/div&gt;<br>&lt;div&gt;<br>&lt;p&gt;&lt;font face=3D&quot;Times New
Roman&quot; size=3D&quot;3&quot;&gt;&lt;span
style=3D&quot;FONT-SIZE:<br>12pt=<br>&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;&lt;/div&gt;<br>

&lt;div&gt;<br>&lt;p&gt;&lt;font face=3D&quot;Tahoma&quot;
size=3D&quot;2&quot;&gt;&lt;span style=3D&quot;FONT-SIZE:
10pt;<br>FONT-FA=<br>MILY:
Tahoma&quot;&gt;Thanks&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;&lt;/div&gt;<br>&lt;div&gt;<br>

&lt;p&gt;&lt;font face=3D&quot;Tahoma&quot;
size=3D&quot;2&quot;&gt;&lt;span style=3D&quot;FONT-SIZE:
10pt;<br>FONT-FA=<br>MILY:
Tahoma&quot;&gt;Mel&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;&lt;/div&gt;&lt;/span&gt;&lt;/div&gt;<br>

&lt;p&gt;&lt;font face=3D&quot;Times New Roman&quot;
size=3D&quot;3&quot;&gt;&lt;span
style=3D&quot;FONT-SIZE:<br>12pt=<br>&quot;&gt;__Platinum Sponsor: &lt;a
onclick=3D&quot;return<br>top.js.OpenExtLink(window,event,=<br>
this)&quot; href=3D&quot;<a href="http://www.rmsportal.com/
">http://www.rmsportal.com/</a>&quot;<br>target=3D&quot;_blank&quot;&gt;www.rmsportal.c=<br>om&lt;/a&gt;
 ARSlist: &amp;quot;Where the Answers Are&amp;quot; html___<br>
&lt;/span&gt;&lt;/font&gt;&lt;/p=<br>&gt;<br>&lt;/div&gt;&lt;/div&gt;__Platinum
 Sponsor: &lt;a
onclick=3D&quot;return<br>top.js.OpenExtLink(win=<br>dow,event,this)&quot;
href=3D&quot;<a href="http://www.rmsportal.com/
">http://www.rmsportal.com/</a>&quot;<br>
target=3D&quot;_blank&quot;&gt;www.r=<br><a href="http://msportal.com
">msportal.com</a>&lt;/a&gt; ARSlist: &amp;quot;Where the Answers
Are&amp;quot; html___
&lt;br<br>cle=<br>ar=3D&quot;all&quot;&gt;<br>&lt;/blockquote&gt;&lt;br&gt;<br>

__Platinum Sponsor: <a href="http://www.rmsportal.com
">www.rmsportal.com</a> ARSlist: &quot;Where the Answers
Are&quot;<br>html___<br><br>------=_Part_6872_1105761.1206524742321--<br><br><br><br>_______________________________________________________________________________<br>

UNSUBSCRIBE or access ARSlist Archives at <a href="http://www.arslist.org
">www.arslist.org</a><br>Platinum Sponsor: <a href="
http://www.rmsportal.com";>www.rmsportal.com</a> ARSlist: &quot;Where the
Answers Are&quot;<br></blockquote>
</div><br>
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

------=_Part_7293_11795538.1206538125823--




_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Reply via email to