JS – It is true, but there are a heck of a lot of queries to fix. In fact, there are some queries that just can’t ever be efficient (if they are analytical in nature). There are some additional query technologies that can be used if this is the case - ☺
Lee Cullom | Northcraft Analytics IT Metrics Specialist | Business Intelligence Applications for IT Direct - 678-438-7244 | http://www.northcraftanalytics.com<http://www.northcraftanalytics.com/> Main - (678) 664-ITSM [Description: Description: http://t0.gstatic.com/images?q=tbn:ANd9GcSo4qhIq-bDh4Z1UzKXet0tiAZqqejjd1BT8lVOHdrzZQwqeZun]<http://www.linkedin.com/in/leecullom>[Description: Description: http://t0.gstatic.com/images?q=tbn:ANd9GcSWE5AoudybparNXkh21Br8ZWGNBqdra5ylZ63igCoZ36o5b5iFEA]<http://twitter.com/#!/NorthcraftIT> What is Northcraft Analytics? Find out in 87 Seconds. <http://www.youtube.com/watch?v=SRNyPNK_HJc> THE CONTENTS OF THIS EMAIL, INCLUDING THE CONTENTS OF ANY ATTACHMENTS HERETO, CONSTITUTES “CONFIDENTIAL INFORMATION” AND IS SUBJECT TO A CONFIDENTIALITY AND NON-DISCLOSURE AGREEMENT BETWEEN THE RECIPIENT AND NORTHCRAFT ANALYTICS LLC (If such an agreement is in place). From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Sundberg Sent: Tuesday, February 24, 2015 5:21 PM To: [email protected] 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]<mailto:[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, must not be archived. [Meta-Archive for an ITSM Incident] 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<http://softwaretoolhouse.com/product/SthArch/> Meta-Archive Overview Leaflet <http://softwaretoolhouse.com/product/SthArch/Meta-Archive-Overview-Leaflet.pdf> Management Overview<http://softwaretoolhouse.com/product/SthArch/Meta-Archive-MgmtOview.wmv> – Windows Movie (10 min.) Meta-Archive Fact Sheet<http://softwaretoolhouse.com/product/SthArch/Meta-Archive-Fact-Sheet.pdf> ITSM Archiving White Paper<http://softwaretoolhouse.com/product/SthArch/Meta-Archive-White-Paper.pdf> • 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]<mailto:[email protected]> Cheers, Ben Chernys Senior Software Architect [Description: logoSthInc-sm] Canada / Deutschland Mobile: +49 171 380 2329<tel:%2B49%20171%20380%202329> GMT + 1 + [ DST ] Email: Ben.Chernys_AT_softwaretoolhouse.com<mailto:Ben.Chernys_AT_softwaretoolhouse.com> Web: www.softwaretoolhouse.com<http://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]<mailto:[email protected]> www.kineticdata.com<http://www.kineticdata.com/> I community.kineticdata.com<http://community.kineticdata.com/> [http://keg.kineticdata.com/images/KEG15_EmailFooter.png]<http://keg.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"
