The agreement that I have had with the user community at a few places I have worked is to always keep a full 12 months of Help Desk records. So by the time we are ready to do annual archiving we are close to 2 years worth (and some times we don't archive right at a year). This allows at least a full year reports at any time. We do roughly 180k Help Desk tickets a year.
We archive the old fashion way of exporting an arx file and deleting the records. If there is ever a need to report on old records we will restore them in an another environment. On Help Desk usually most of reports don't go past 1 year and this keeps us from maintaining extra servers/cost/workflow to keep a reporting server. Another thing to keep in mind is what is an appropriate interval for the form you are archiving. You many not want to keep only a year of Change Requests or other forms that support policies and/or regulatory compliance. Maybe you want to keep 5 years for Change Request and never archive Account Requests and user system access records (both custom modules). HTH, Jason On Wed, Mar 26, 2008 at 2:13 AM, Melanie Snayer <[EMAIL PROTECTED]> wrote: > ** Hi Listeners > > We're experiencing performance issues especially when submitting > incidents. Our initial plan was to archive calls that have been closed for > 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-live. > 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
