Hi Folks,
Me again... still struggling with this Mid-tier performance issue. ColumnIT
(our support provider) has escalated the issue to BMC and I would
appreciate a second opinion on the information I have received from BMC
back line engineering support. I would like to know if you believe the
Hi Larry
Sounds strange...
I have seen SQL queries degrade in performance over time depending on the query
execution plan, the amount of change to the data, and the statistics that are
utilized by the query engine, but it doesn't describe why re-starting arsystem
fixes the problem.
Sent: Thursday, May 17, 2012 11:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.6.03 performance problems
**
Hi Larry
Sounds strange...
I have seen SQL queries degrade in performance over time depending on the query
execution plan, the amount of change to the data
Hi Terry,
That is a good suggestion. I have done an execution plan for the SQL in
question, but I have not done a before after for the same SQL.
Thanks.
Larry
On Thu, May 17, 2012 at 11:21 AM, Terry Bootsma tboot...@objectpath.comwrote:
**
Hi Larry
Sounds strange...
I have seen SQL
Look at your sql logs. Do you see a long delay between the time the select
is issued and the results returned? If so, that would indicate to me that
the SQL is the cause of the slowness. Start there, then cross the next
bridge when you get to it.
Axton Grams
On Thu, May 17, 2012 at 10:32 AM,
Hi Axton,
I have Used Misi's excellent RRR|Log analysis tool to analyse 24 hours
worth of combined API and SQL logs. For the entire 24 hour period, I found
a small number of SQL commands that do take several seconds to execute.
However, in all cases, these SQL queries are the result of poorly
Well, if you have data piling up somewhere, and you have workflow that
scans that data, as the size of the data increases, the time required for
the scan will increase. If this is going on, you will see evidence to that
effect in the sql logs (increasing time in the sql logs for the same
: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of L G Robinson
Sent: Thursday, March 29, 2012 8:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.6.03 performance problems
**
Hi Folks,
I wrote to you a couple of months ago regarding a performance
Hi Folks,
I wrote to you a couple of months ago regarding a performance problem I am
experiencing with my 7.6.03 Remedy system. Specifically, the problem is
with my Mid-tier servers in that their performance degrades throughout the
day. I have taken to restarting the arserver processes via cron
Well constructed post. It gives me a lot to work with when thinking about
your problem. I applaud you for that.
The interesting thing is that a restart of either the Tomcat servers or the
ARServer fixes your issue. This throws an unknown variable into the mix (a
monkey wrench, of sorts).
If
Hi Axton,
Thanks for reading and for your suggestions.
I have done a little bit of JVM monitoring. I used jconsole, since it was
already there and was easy enough to startup. I watched the various heaps
over a weeks time and I didn't see anything alarming. GC seemed to be
happening regularly and
jvisualvm will give you more in depth cpu profiling capabilities if run
from the server. This will give a cpu time per method call. You can also
get memory profiling statistics (how much memory is used for each class,
how many instances there are of each class, etc.). jvisualvm should be
1, 2012 2:59:02 AM
Subject: Re: ARS 7.6.03 performance problems
**
Larry:
It’s possible there’s a memory leak in the particular version of the server
demon you have. Patrick’s thought about patch levels is a good one – if that
“…Build 001…” means patch 001, then you should download
, 2012 2:59:02 AM
Subject: Re: ARS 7.6.03 performance problems
**
Larry:
It’s possible there’s a memory leak in the particular version of the server
demon you have. Patrick’s thought about patch levels is a good one – if that
“…Build 001…” means patch 001, then you should download
If you think there are memory leaks and you are on the Solaris platform,
you can use these tools to find out if there are memory leaks:
- mdb
- libumem
See here for more information:
http://blogs.oracle.com/pnayak/entry/finding_memory_leaks_within_solaris
If you don't want to run the debugger
,
--Phil
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of L G Robinson
Sent: Friday, December 30, 2011 21:45
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.6.03 performance problems
** Hi Patrick,
Thanks for the link, but the Mid-tier isn't even running
We have seen arserverd memory continues to increase in Solaris with both
libumem or libc.
We have tested this with ARS 7.5 and solaris 5.10
Our observation was arserverd daemon takes up some memory when a user
issues a large query and will not release it to OS even after the query is
complete.
@ARSLIST.ORG
Subject: ARS 7.6.03 performance problems
Hi Folks,
I am experiencing a performance problem on my 7.6.03 AR System. The problem
gets worse over time. When the server is started, performance is fine. For
example, it takes about one second to load a particular record in the Windows
Rick just posted a good guide on performance of the midtier: run through it:
you may want to consider pinning in memory the user and people table. I have
not tried this with 7.6.04 yet but it has made a difference in the past.
Sent from my iPhone
On Dec 29, 2011, at 19:36, L G Robinson
] On Behalf Of L G Robinson
Sent: Thursday, December 29, 2011 19:37
To: arslist@ARSLIST.ORG
Subject: ARS 7.6.03 performance problems
Hi Folks,
I am experiencing a performance problem on my 7.6.03 AR System. The
problem gets worse over time. When the server is started, performance is
fine
using before the slowdown and then
during the slowdown?
--Phil
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] On Behalf Of L G Robinson
Sent: Thursday, December 29, 2011 19:37
To: arslist@ARSLIST.ORG
Subject: ARS 7.6.03
Hi Patrick,
Thanks for the link, but the Mid-tier isn't even running on the same
hardware. The AR Server software running on the Solaris box is:
AR Server 7.6.03 Build 001 201008170035
Here is additional memory information throughout the day, 5 minute
intervals. Memory usage continues to
Hi Folks,
I am experiencing a performance problem on my 7.6.03 AR System. The
problem gets worse over time. When the server is started, performance
is fine. For example, it takes about one second to load a particular
record in the Windows client and about two seconds to load the same
record in
23 matches
Mail list logo
