I would look at the number of rows on the heavy hitter forms as well as having the DBA possibly doing a reorg on those heavy hitter forms as well as their supporting forms. How ever you look at logs either by what BMC supplies or some third party app, I would look at what queries are going through that appear to run a while and see if your indexes need to be tweaked.
Darrell Reading Systems Engineer Phone 479.204.5739 dere...@wal-mart.com Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, February 16, 2011 09:52 To: arslist@ARSLIST.ORG Subject: Re: Performance matrix Hi L.J., We almost agree ;-) I would recommend using the RRR|Log tool instead for your logfile. It gives a lot more, but has a small annual subscription fee attached to it... Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > Misi, > I completely agree...turn on API/Filter/SQL logging and run the AR Log > Analyzer, see where your 'heavy hitters' are and tune them first. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky > Sent: Wednesday, February 16, 2011 2:40 AM > To: arslist@ARSLIST.ORG > Subject: Re: Performance matrix > > Hi, > > Performance may be good, if you look at individual parts, but the design > seems bad. > > You will probably benefit from having less fields in your forms, and split > the data/functionality into multiple forms. This may be very hard to do > though... > > You may be able to improve things with your current architecture, but you > have to check what really happens when you login, open your form, and save > your record etc. Which forms are run, indexes used, filters executed, > unnecessary set-fields/table-refreshes etc. In other words - Traditional > performance tuning. > > Turn on your log files on and investigate! > > http://rrr.se/doc/WWRUG09_RRR_LogFilePerformanceTuning.pdf > > Best Regards - Misi, RRR AB, http://www.rrr.se > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > >> hi all, >> >> I have an completely custom application with about more then 200 forms >> and >> 20 heavy forms with around 800 fields on an average on the heave forms. >> I >> have concurrent 1300 users who do all kinds of works. Most importantly >> the >> AR version is ARS 5.0.1 on Solaris/Oracle with AR and Db on the same >> machine. >> >> Now my question what should be the performance that I should consider as >> good? How do anyone can decide whats a good performance for this kind of >> system? >> >> Currently we are observing 10 seconds to log in and 45 seconds to open >> the >> max heavy form with 1200 fields and 1 minute to save a records in this >> form >> at peak usage. >> >> What should be the feasible performance improvement that I can expect >> and >> work towards? >> >> Can anyone shed some light on ARS Performance matrix and how it is >> calculated? >> >> Thanks a lot in advance we are currently in the fire fighting mode on >> this >> front. >> >> Regards, >> Vikram. >> -- >> View this message in context: >> http://old.nabble.com/Performance-matrix-tp30936611p30936611.html >> Sent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. *** Walmart Confidential ***
