Hi. Your commas are confusing... do you have 3.4 million incident records
or 34 million to archive?
Anyway, if you are archiving 50,000 incidents every day, but adding
30,000, your net archiving is 20,000. Dividing it out:
34,000,000/20,000 = 1700 days (4.7 years, rounded and not
considering the leap year)
or (depending on which number you use:
3,400,000 / 20,000 = 170 days
Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard
Bach
Vyom Labs - ITSM Support <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)"
<[email protected]>
12/11/2008 02:14 AM
Please respond to
[email protected]
To
[email protected]
cc
Subject
Performance Issue In Archiving the data
**
Hello Everyone ...
We are in very wired situation right now. We are using Remedy 7.0.0 with
ITSM Suits.
We are facing problem in archiving. Our user complaining about slow
performance of system everyday.
If i am not wrong it's could be solve if we archive current HPD tickets.
currently we have, more than 34,00,000 incident record in HPD:HelpDesk.
We tried to archive with qualification which has near around 60,000
record. But our UAT server had crash while arching. Same risk of arching
we can not take on production.
We have following H/w configuration.
Application server: 16 GB RAM, Sun 4 u (dual core - 4 CPU)
OS - Solaris 10
Database (remote) - 10g
Web server (remote) - tomact 5.5
Per day Incident are around 30,000. So we have decided to archive
everyday.
Qualification would be like this, so system archive only 2 days record
before 3 months.
So everyday we will archive around 50,000 Record.
We want to know, How much time it will take? ..
please any suggestion would be welcome ...
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
*IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely for
the entity or individual to whom it is addressed. If you are not the intended
recipient, you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message is strictly prohibited.
Nothing in this email, including any attachment, is intended to be a legally
binding signature.
*
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
