Well, if you go on the BMC recommendations for DB and buffer cache settings you will always be swapping queries in memory to disk …
A simple "%" bypasses all settings on an AR Server, so with that indexes are useless and then you are relying on the table sizes … I agree, interesting topic J _____ Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Danny Kellett Sent: 25 February 2015 19:45 To: [email protected] Subject: Re: ADV: Meta-Archive Product Announcement: ITSM Archiving ** It's been a while since I checked but I think with most DBMS, a clustered index is stored in memory / pages once it's used. So if this is large then you can end up with a buffer thats gigs right? Agreed that indexes are great on large tables but I don't think it's an excuse not to keep the tables trim. Also think about those people who don't query with indexes. Interesting topic though ------ Original Message ------ From: "Brittain, Mark" <[email protected]> To: [email protected] Sent: 25/02/2015 19:17:53 Subject: Re: ADV: Meta-Archive Product Announcement: ITSM Archiving ** Its’ all about indexing. I have a large form on a 6.3 platform that contains over a million records and just flies. Adjust the indexing to match the most common queries. Company, Status, Assigned Group are probably the most common. Anything that is required and menu driven would be good candidates. But be careful not to have too many indexes because indexes rebuilt when a new record is inserted. Mark From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Wednesday, February 25, 2015 8:48 AM To: [email protected] Subject: Re: ADV: Meta-Archive Product Announcement: ITSM Archiving ** Absolutely agree. An RDBMS is meant for massive amounts of data “so long as its efficiently stored and retrieved”. That’s the key factor. Else its just like storing it in an Excel sheet if one does not pay heed to queries and the way data is retrieved. Cheers Joe _____ 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]> 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] 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: <mailto:Ben.Chernys_AT_softwaretoolhouse.com> Ben.Chernys_AT_softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> 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/> 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/> www.kineticdata.com I <http://community.kineticdata.com/> community.kineticdata.com <http://keg.kineticdata.com/> Image removed by sender._ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _____ This E-mail and any of its attachments may contain Time Warner Cable proprietary information, which is privileged, confidential, or subject to copyright belonging to Time Warner Cable. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. _ARSlist: "Where the Answers Are" and have been for 20 years_ _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"
