The reason of course that it wasn't funny is because that sort of information would be sweet to have...but the system wasn't designed to provide it...
_____ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Thursday, February 18, 2010 4:00 PM To: arslist@ARSLIST.ORG Subject: RE: Performance issues John....that WAS NOT FUNNY....I almost did it.... _____ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Sundberg Sent: Thursday, February 18, 2010 3:47 PM To: arslist@ARSLIST.ORG Subject: Re: Performance issues ** Another option: Point your web browser to: http://remedyserver:9090/bmc/backplane/stats You should see a graph of: - filters sorted by # of times run - filters sorted by total time consumed - escalations sorted by # of records modified - escalations sorted by total time consumed Also: - a list of all tables on the system sorted by # of records / table. - a list of all tables sorted by disk size If you click on the "trends" tab -- you should see the above with historical values. The above should be helpful in pinpointing your issues. OK - OK -- I am sorry -- I have to quit dreaming -- it just makes you depressed. -John On Feb 18, 2010, at 12:56 PM, LJ Longwing wrote: ** Tim, That doesn't seem excessive to me....whenever I'm looking at performance issues I turn on SQL and API logging at the server and run the ARLogAnalyzer against them...it tells me which processes are taking to long and I tweak that workflow, indexes, etc. _____ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tim Rondeau Sent: Thursday, February 18, 2010 11:43 AM To: arslist@ARSLIST.ORG Subject: Performance issues ** Arsystem 7.1 patch 7 ITSM suite, using SLM, CMDB, Change Management, Problem and Incident We are running SQL 2005 on windows 2003 server, plenty of CPU/disk and RAM. Looking for some feed back on how some have handled performance issues. We process about 400 changes a day and about 800 incidents a day. Just seems like this system can't handle it. DB timeouts, white screens all the time. DBA of course states no issues. In March we are moving to Oracle RAC, which will be 2 robust db servers. APP will still be on windows. Thanks Tim _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ -- John Sundberg Kinetic Data, Inc. "Building a Better Service Experience" Recipient of the WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I <http://www.kineticdata.com/> www.kineticdata.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"