John,
Isn't reading an index with fewer rows going to be quicker than reading
one with more rows?
Personally, I think no one task is a silver bullet to performance
tuning. I would implement archiving and monitor for table scans.
I welcome anything, a product or a HowTo that will improve an apps
performance.
Just my Wednesday afternoons 2 pence worth
Regards
Danny
Single Sign On (SSO) for the BMC Remedy AR System and ITSM
http://www.javasystemsolutions.com/jss/ssoplugin
------ Original Message ------
From: "John Sundberg" <[email protected]>
To: [email protected]
Sent: 24/02/2015 22:20:59
Subject: Re: ADV: Meta-Archive Product Announcement: ITSM Archiving
**
Actually — I am wondering … do people agree with this fundamental
assumption that the more records the worse the performance?
To me — that is only for “inefficient queries” and — for the most part
- even if you archive — you will still have a slow system.
Do people agree with that??? And if so — isn’t the right solution - to
“fix the queries”.
I know this — archiving "roughly doubles” the reporting headaches,
workflow headaches, maintenance headaches.
-John
On Tue, Feb 24, 2015 at 3:39 PM, Ben Chernys
<[email protected]> wrote:
**
Hi Folks,
As enterprises have been using ITSM for some time now, they have
accumulated Incidents, Changes, and other “root requests” that are
closed, old, and can be archived. These data have slowed down
searches and the ITSM application responses. Moving these data into
Archive tables speeds up database search and retrieval from the
high-use, active ITSM tables.
ITSM Challenges
BMC Remedy OOTB Archiving handles each table independently. In fact,
an ITSM
Incident comprises many records in many forms — a tree of dependent
records.
Further, if an Incident is associated with a Change that is not
archive ready, then that
Incident too, mustnot be archived.
Introducing Meta-Archive
Your Benefits
Software Tool House's Meta-Archive solves all ITSM Archiving
challenges and implements your archiving rules. We make it easy!
Handle customers and classes of tickets differently, add your
customized forms easily — all in a simple spreadsheet.
Archive forms are automatically generated. Associations are checked
and reported.
Meta-Archive delivers
· All associations are checked before a record is archived.
· The entire tree of records is archived before any deletions
are done.
· Different archival ages can be set for different customers
or classes of tickets.
· Different ages for associations can be set.
· It is easy to add any customized tables to the tree.
· It is easy to change or add archival targets: Archival
forms, different servers, SQL databases, the file system.
· We get you going in a few hours with no server changes, no
development project, no headaches.
More Information
Meta-Archive Home
Meta-Archive Overview Leaflet
Management Overview – Windows Movie (10 min.)
Meta-Archive Fact Sheet
ITSM Archiving White Paper
ü automating the data archiving process using purpose-built archive
systems make production systems run better
ü searches are quicker and use less resources resulting in faster
ITSM application responses
ü increased support personnel performance and satisfaction
ü production performance is
ü unaffected by information growth
If you are interested in a presentation or a trial, please contact us
at [email protected]
Cheers,
Ben Chernys
Senior Software Architect
Canada / Deutschland
Mobile: +49 171 380 2329 GMT + 1 + [ DST ]
Email: Ben.Chernys_AT_softwaretoolhouse.com
Web: www.softwaretoolhouse.com
We are a BMC Technology Alliance Partner.
Check out Software Tool House's free Diary Editor and our Freebies
Section for ITSM 7.6.04 and 8.0.0 Fields spreadsheets.
Meta-Update, our premium ARS Data tool, lets you automate your
imports, migrations, in no time at all, without programming, without
staging forms, without merge workflow.
Meta-Archive does ITSM Archiving your way, with your tables and rules.
http://www.softwaretoolhouse.com/
_ARSlist: "Where the Answers Are" and have been for 20 years_
--
John Sundberg
Kinetic Data, Inc.
"Your business. Your process."
651-556-0930 I [email protected]
http://www.kineticdata.com/ I community.kineticdata.com
_ARSlist: "Where the Answers Are" and have been for 20 years_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
