We were having some intermittent response issues and of course the finger always points to the application or database. We're also on Sun Solaris but ARS v7.5, Oracle 10g.
I've started using rrr|Log and love, love, love that program (www.rrr.se). I can quickly see any sql statements taking longer than I'd expect and work to correct them. Although when things take 2/100's of a second I think they're in pretty good shape. But I was able to spot people doing full table scan queries and coach them (polite terminology) in how to do them properly, and the subsequently make sure they're doing it that way. It also shows thread information and lapse times. You can use the evaluation portion but for us was about 2 minutes worth of log file. It was a one minute demo to the CTO to get approval for full version. I do believe I saw a twinkle in his eye and his mouth involuntary dropped open. Good job Misi !!! Plus now I get to point to the network guys ... lol !!! Susan On Thu, Apr 12, 2012 at 10:01 AM, arsl...@remedy.us.com < arsl...@remedy.us.com> wrote: > ** ** > > Check if you are retaining your incoming/outgoing emails in the AR System > Eamil Messages form. I have noticed that same server issue when a lot of > emails are stored in the form. > > > > Phil > > > On April 12, 2012 at 10:26 AM LJ LongWing <lj.longw...@gmail.com> wrote: > > > Jamie, > > I think the most likely of the solutions, are those presented by Ron > regarding thread counts. Recently there have been some good discussions on > the list regarding server statistics and how to determine if you need more > threads, I would recommend checking them out > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Jamie > > Sent: Wednesday, April 11, 2012 11:20 AM > > To: arslist@ARSLIST.ORG > > Subject: Remedy System comes to a standstill/unresonsive > > > > We've been experiencing intermittent issues where all of a sudden our > Remedy system comes to a standstill and is unresponsive to the end user for > 10-15mins. The end users are experiencing this in both the client and the > web. The strange thing is that there are no errors outputted to the > arerror.log file and the end users are not receiving any errors such as > timeouts. We have automated montioring setup to ping the IP Address every > 5 secs and have not received any alerts. We have montiored the databse and > haven't found really any long running queries during the time of the issues > that we think is contributing to the issues. We've now turned on the normal > app logging of API/SQL/Filter/Esc and opened up a ticket with BMC Support, > but looking for some "Out of the Box thinking" from the group on where to > maybe look or if anyone has had similar issues. > > > > ARS/Midtier 7.5 Patch 6 > > ITSM 7.5.01 Patch 1 > > Atrium Core 7.5 Patch 2 > > SLM 7.5.00 > > Kinetic Survey > > Kinetic Request > > > > 4 Sun Solaris AR Servers in a server group behind loadbalancer > > Oracle Database > > 4 Windows VM Midtier servers behind load balancer > > > > Integrations with AR servers: > > OIM > > BladeLogic/BAO > > IBRSD with ProactiveNet, Patrol > > Control M > > TMART > > > > Yep, we've been drinking the BMC blue kool-aid for the most part :) > > > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > > > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
