Re: performance issue

[Frex Popo]

 
May be I have not described the issue correctly. :) But all the recomendations 
are helpfull and very much appreciated.
Will be replying to the recomendations as soon as I have some time and may be 
ask few more questions :)
Have a good evening.
 
  


 De : Steve Kallestad 
À : arslist@ARSLIST.ORG 
Envoyé le : Mercredi 26 juin 2013 15h58
Objet : Re: performance issue
  


** 
Confio Ignite does wonders.  It does the basics like recommending indexes where 
needed, but it also provides configuration advice and tracks down environment 
specific issues.

There's a free trial and it getting it going is pretty quick and easy. 

It's good to do some simultaneous SQL Logging if you are trying to track down a 
particular user that's causing problems with bad queries, crazy reports, or 
whatnot.  


The purchase price is reasonable if I remember correctly, but you can really 
get a ton of good information out of the free trial.

They also have a free real-time monitor that lets you see when problem queries 
and bottlenecks are hitting the db. 

It's one of the best tools for tracking down performance issues that I've seen.

http://www.confio.com/
 

and 

http://www.ignitefree.com/







On Wed, Jun 26, 2013 at 6:43 AM, Anandsagar Sah  wrote:

** 
>Frex, 
>  
>You/your DBA need to analysis column usages from select queries
for particular table to identify which columns needs indexing. There is a tool 
available
( http://remedyloganalyzer.com/ ) which will help you to identify this + other
performance gap. 
>  
>Thanks & Regards, 
>Anandsagar 
>  
>From:Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
Longwing,
Lj
>Sent: Wednesday, June 26, 2013 6:15 PM
>To: arslist@ARSLIST.ORG
>Subject: Re: performance issue 
>  
>**  
>Frex, 
>I would recommend, as others have, getting your DBA involved
(assuming you have one).  The DBA can help identify queries that need
indexing, and if necessary, they should be able to move these tables to
anotheroh what's the word...I want to use tableset, but that's not
rightbasically moving these tables (at the db level) to another hard drive
so that queries to them don't have an IO impact on the rest of the db.   
>  
>On Wed, Jun 26, 2013 at 6:37 AM, Kiran Patil 
wrote: 
>**  
>Hi
Flex,  
>   
>Do
you use BMC Analytics and does analytics has seperate db which I would say
mirror or production database.  
>If
Analytics has seperate db which is in synch with Production db then you can
design schedulers to purge transactional data from production server as
analytics db already will have hostorical data.  
>   
>Regards  
>Kiran
Patil  
>   
>   
>On Wed, Jun 26, 2013 at 4:56 PM, Frex Popo 
wrote: 
>**  
>Hi
everyone,  
>   
>In addition
to a reporting server, we have some 10 forms in a primary server with large
volume of data. Adhoc AR Reports and searches are executed on the data nearly
every day and this is causing some serious performance issues.   
>Any thought
on how to resolve this? We were thinking about moving the data to a different
database (thorough replication or nightly database copy) but we need either an
additional server (perhaps DSO) but this will need an extra license. Enabling
archiving at the form level is another option but we will still have to use the
primary server and additional configuration needs to be done at the queues and
thread level as well and plenty of table indexing.  
>Any pointer
will be very much appreciated.  
>   
>BTW this is
ARS7.1  
>   
>Thank you  
>frex
>_ARSlist: "Where the Answers Are" and have been
for 20 years_  
>
>
>   
>--  
>Regards 
>
>Kiran
Patil 
>Cognizant Technology Solutions  
>Pune, India  
>Mob No: +91 989 037 7125
>_ARSlist: "Where the Answers Are" and have been
for 20 years_ 
>   
>_ARSlist: "Where the Answers Are" and have been
for 20 years_   
>_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"

Re: performance issue

[Steve Kallestad]

Confio Ignite does wonders.  It does the basics like recommending indexes
where needed, but it also provides configuration advice and tracks down
environment specific issues.

There's a free trial and it getting it going is pretty quick and easy.

It's good to do some simultaneous SQL Logging if you are trying to track
down a particular user that's causing problems with bad queries, crazy
reports, or whatnot.

The purchase price is reasonable if I remember correctly, but you can
really get a ton of good information out of the free trial.

They also have a free real-time monitor that lets you see when problem
queries and bottlenecks are hitting the db.

It's one of the best tools for tracking down performance issues that I've
seen.

http://www.confio.com/

and

http://www.ignitefree.com/





On Wed, Jun 26, 2013 at 6:43 AM, Anandsagar Sah wrote:

> **
>
> Frex,
>
> ** **
>
> You/your DBA need to analysis column usages from select queries for
> particular table to identify which columns needs indexing. There is a tool
> available ( http://remedyloganalyzer.com ) which will help you to
> identify this + other performance gap.
>
> ** **
>
> Thanks & Regards,
>
> Anandsagar
>
> ** **
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Longwing, Lj
> *Sent:* Wednesday, June 26, 2013 6:15 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: performance issue
>
> ** **
>
> ** 
>
> Frex,
>
> I would recommend, as others have, getting your DBA involved (assuming you
> have one).  The DBA can help identify queries that need indexing, and if
> necessary, they should be able to move these tables to anotheroh what's
> the word...I want to use tableset, but that's not rightbasically moving
> these tables (at the db level) to another hard drive so that queries to
> them don't have an IO impact on the rest of the db.
>
> ** **
>
> On Wed, Jun 26, 2013 at 6:37 AM, Kiran Patil 
> wrote:
>
> ** 
>
> Hi Flex,
>
>  
>
> Do you use BMC Analytics and does analytics has seperate db which I would
> say mirror or production database.
>
> If Analytics has seperate db which is in synch with Production db then you
> can design schedulers to purge transactional data from production server as
> analytics db already will have hostorical data.
>
>  
>
> Regards
>
> Kiran Patil
>
>  
>
> ** **
>
> On Wed, Jun 26, 2013 at 4:56 PM, Frex Popo  wrote:
>
> ** 
>
> Hi everyone,
>
>  
>
> In addition to a reporting server, we have some 10 forms in a primary
> server with large volume of data. Adhoc AR Reports and searches are
> executed on the data nearly every day and this is causing some serious
> performance issues. 
>
> Any thought on how to resolve this? We were thinking about moving the data
> to a different database (thorough replication or nightly database copy) but
> we need either an additional server (perhaps DSO) but this will need an
> extra license. Enabling archiving at the form level is another option but
> we will still have to use the primary server and additional configuration
> needs to be done at the queues and thread level as well and plenty of table
> indexing.
>
> Any pointer will be very much appreciated.
>
>  
>
> BTW this is ARS7.1
>
>  
>
> Thank you
>
> frex
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
>
>
> 
>
> -- 
>
> *Regards* 
>
> *
> **Kiran Patil* 
>
> *Cognizant Technology Solutions*
>
> *Pune, India*
>
> *Mob No: +91 989 037 7125*
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_ 
>
> ** **
>
> _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"

Re: performance issue

[Bhupendra Kumar]

Dear All,

Issue : we have a server group and the group consist of 3 servers. Sometime , 
it happens that one server start responding very slow. Is there any way to know 
when the service will be slow ( which make user experience slow ) ??

Is it possible to detect this moment and then restart the AR Services ? ( I 
would like to use perl )


Regards,
Kumar

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: performance issue

[Anandsagar Sah]

Frex,

You/your DBA need to analysis column usages from select queries for particular 
table to identify which columns needs indexing. There is a tool available ( 
http://remedyloganalyzer.com ) which will help you to identify this + other 
performance gap.

Thanks & Regards,
Anandsagar

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj
Sent: Wednesday, June 26, 2013 6:15 PM
To: arslist@ARSLIST.ORG
Subject: Re: performance issue

**
Frex,
I would recommend, as others have, getting your DBA involved (assuming you have 
one).  The DBA can help identify queries that need indexing, and if necessary, 
they should be able to move these tables to anotheroh what's the word...I 
want to use tableset, but that's not rightbasically moving these tables (at 
the db level) to another hard drive so that queries to them don't have an IO 
impact on the rest of the db.

On Wed, Jun 26, 2013 at 6:37 AM, Kiran Patil 
mailto:kiranpatil@gmail.com>> wrote:
**
Hi Flex,

Do you use BMC Analytics and does analytics has seperate db which I would say 
mirror or production database.
If Analytics has seperate db which is in synch with Production db then you can 
design schedulers to purge transactional data from production server as 
analytics db already will have hostorical data.

Regards
Kiran Patil


On Wed, Jun 26, 2013 at 4:56 PM, Frex Popo 
mailto:frexp...@yahoo.fr>> wrote:
**
Hi everyone,

In addition to a reporting server, we have some 10 forms in a primary server 
with large volume of data. Adhoc AR Reports and searches are executed on the 
data nearly every day and this is causing some serious performance issues.
Any thought on how to resolve this? We were thinking about moving the data to a 
different database (thorough replication or nightly database copy) but we need 
either an additional server (perhaps DSO) but this will need an extra license. 
Enabling archiving at the form level is another option but we will still have 
to use the primary server and additional configuration needs to be done at the 
queues and thread level as well and plenty of table indexing.
Any pointer will be very much appreciated.

BTW this is ARS7.1

Thank you
frex
_ARSlist: "Where the Answers Are" and have been for 20 years_


--
Regards

Kiran Patil
Cognizant Technology Solutions
Pune, India
Mob No: +91 989 037 7125
_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"

Re: performance issue

[Longwing, Lj]

Frex,
I would recommend, as others have, getting your DBA involved (assuming you
have one).  The DBA can help identify queries that need indexing, and if
necessary, they should be able to move these tables to anotheroh what's
the word...I want to use tableset, but that's not rightbasically moving
these tables (at the db level) to another hard drive so that queries to
them don't have an IO impact on the rest of the db.


On Wed, Jun 26, 2013 at 6:37 AM, Kiran Patil wrote:

> **
> Hi Flex,
>
> Do you use BMC Analytics and does analytics has seperate db which I would
> say mirror or production database.
> If Analytics has seperate db which is in synch with Production db then you
> can design schedulers to purge transactional data from production server as
> analytics db already will have hostorical data.
>
> Regards
> Kiran Patil
>
>
>
> On Wed, Jun 26, 2013 at 4:56 PM, Frex Popo  wrote:
>
>> **
>>  Hi everyone,
>>
>> In addition to a reporting server, we have some 10 forms in a primary
>> server with large volume of data. Adhoc AR Reports and searches are
>> executed on the data nearly every day and this is causing some serious
>> performance issues. **
>>  Any thought on how to resolve this? We were thinking about moving the
>> data to a different database (thorough replication or nightly database
>> copy) but we need either an additional server (perhaps DSO) but this will
>> need an extra license. Enabling archiving at the form level is another
>> option but we will still have to use the primary server and additional
>> configuration needs to be done at the queues and thread level as well and
>> plenty of table indexing.
>> Any pointer will be very much appreciated.
>>
>> BTW this is ARS7.1
>>
>> Thank you
>> frex
>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
>
>
>
> --
> *Regards*
> *
> **Kiran Patil*
> *Cognizant Technology Solutions*
> *Pune, India*
> *Mob No: +91 989 037 7125
> *
>  _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"

Re: performance issue

[Kiran Patil]

Hi Flex,

Do you use BMC Analytics and does analytics has seperate db which I would
say mirror or production database.
If Analytics has seperate db which is in synch with Production db then you
can design schedulers to purge transactional data from production server as
analytics db already will have hostorical data.

Regards
Kiran Patil



On Wed, Jun 26, 2013 at 4:56 PM, Frex Popo  wrote:

> **
>  Hi everyone,
>
> In addition to a reporting server, we have some 10 forms in a primary
> server with large volume of data. Adhoc AR Reports and searches are
> executed on the data nearly every day and this is causing some serious
> performance issues. **
>  Any thought on how to resolve this? We were thinking about moving the
> data to a different database (thorough replication or nightly database
> copy) but we need either an additional server (perhaps DSO) but this will
> need an extra license. Enabling archiving at the form level is another
> option but we will still have to use the primary server and additional
> configuration needs to be done at the queues and thread level as well and
> plenty of table indexing.
> Any pointer will be very much appreciated.
>
> BTW this is ARS7.1
>
> Thank you
> frex
> _ARSlist: "Where the Answers Are" and have been for 20 years_




-- 
*Regards*
*
**Kiran Patil*
*Cognizant Technology Solutions*
*Pune, India*
*Mob No: +91 989 037 7125
*

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: performance issue

[Jon Slaven]

+1 on this.  We had serious load times on our audit logs, adding 
additional indexing took the form load down from ~30 to about ~2

Best,
Jon
_
Jon Slaven | Amway | 616-787-7132 | jon.sla...@amway.com



From:   Patrick Zandi 
To: arslist@ARSLIST.ORG, 
Date:   06/26/2013 07:53 AM
Subject:Re: performance issue
Sent by:"Action Request System discussion list(ARSList)" 




** 
You need to optimize your report and add indexes to your forms based on 
your query to drop your return times. I suspect you are table scanning 

Math is always on the right side of your query. IE.  datefield >= 
($timestamp$ - xxx) 
Not reversed

Always use and equal sign in every query to use the index. 
Try not to use !=

Helpful hints 

Sent from my iPhone

On Jun 26, 2013, at 7:26, Frex Popo  wrote:

** 
Hi everyone,
 
In addition to a reporting server, we have some 10 forms in a primary 
server with large volume of data. Adhoc AR Reports and searches are 
executed on the data nearly every day and this is causing some serious 
performance issues. 
Any thought on how to resolve this? We were thinking about moving the data 
to a different database (thorough replication or nightly database copy) 
but we need either an additional server (perhaps DSO) but this will need 
an extra license. Enabling archiving at the form level is another option 
but we will still have to use the primary server and additional 
configuration needs to be done at the queues and thread level as well and 
plenty of table indexing.
Any pointer will be very much appreciated.
 
BTW this is ARS7.1
 
Thank you
frex
_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"

Re: performance issue

[Kulkarni, Vikrant]

I too have a good experience with the RRR tools. Very helpful in archiving data.

Vikrant

Sent from my Xperia™ smartphone

Misi Mladoniczky  wrote:


Hi,

If you are on the new (blue) license model, an extra AR Server does not cost
you anything from a license perspective.

I have used RRR|Chive successfully to keep tables synchronized between servers.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
* 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 everyone,
>
> In addition to a reporting server, we have some 10 forms in
> a primary server with large volume of data. Adhoc AR Reports and searches are
> executed
> on the data nearly every day and this is causing some serious performance
> issues.
> Any thought on how to resolve this? We were thinking about
> moving the data to a different database (thorough replication or nightly
> database copy) but we need either an additional server (perhaps DSO) but this
> will need an extra license. Enabling archiving at the form level is another
> option but we will still have to use the primary server and additional
> configuration
> needs to be done at the queues and thread level as well and plenty of table
> indexing.
> Any pointer will be very much appreciated.
>
> BTW this is ARS7.1
>
> Thank you
> frex
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "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"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: performance issue

[Patrick Zandi]

You need to optimize your report and add indexes to your forms based on your 
query to drop your return times. I suspect you are table scanning 

Math is always on the right side of your query. IE.  datefield >= ($timestamp$ 
- xxx) 
Not reversed

Always use and equal sign in every query to use the index. 
Try not to use !=

Helpful hints 

Sent from my iPhone

On Jun 26, 2013, at 7:26, Frex Popo  wrote:

> **
> Hi everyone,
>  
> In addition to a reporting server, we have some 10 forms in a primary server 
> with large volume of data. Adhoc AR Reports and searches are executed on the 
> data nearly every day and this is causing some serious performance issues.
> Any thought on how to resolve this? We were thinking about moving the data to 
> a different database (thorough replication or nightly database copy) but we 
> need either an additional server (perhaps DSO) but this will need an extra 
> license. Enabling archiving at the form level is another option but we will 
> still have to use the primary server and additional configuration needs to be 
> done at the queues and thread level as well and plenty of table indexing.
> Any pointer will be very much appreciated.
>  
> BTW this is ARS7.1
>  
> Thank you
> frex
> _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"

Re: performance issue

[Tauf Chowdhury]

There is a parameter you can set in the ar.cfg that limits the amount of
data returned. I don't remember it off the top of y head but it's something
like max-entry-per-query.


Sent from my iPhone

On Jun 26, 2013, at 7:27 AM, Frex Popo  wrote:

**
Hi everyone,

In addition to a reporting server, we have some 10 forms in a primary
server with large volume of data. Adhoc AR Reports and searches are
executed on the data nearly every day and this is causing some serious
performance issues.
Any thought on how to resolve this? We were thinking about moving the data
to a different database (thorough replication or nightly database copy) but
we need either an additional server (perhaps DSO) but this will need an
extra license. Enabling archiving at the form level is another option but
we will still have to use the primary server and additional configuration
needs to be done at the queues and thread level as well and plenty of table
indexing.
Any pointer will be very much appreciated.

BTW this is ARS7.1

Thank you
frex
 _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"

Re: performance issue

[Misi Mladoniczky]

Hi,

If you are on the new (blue) license model, an extra AR Server does not cost
you anything from a license perspective.

I have used RRR|Chive successfully to keep tables synchronized between servers.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
* 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 everyone,
>  
> In addition to a reporting server, we have some 10 forms in
> a primary server with large volume of data. Adhoc AR Reports and searches are
> executed
> on the data nearly every day and this is causing some serious performance
> issues.
> Any thought on how to resolve this? We were thinking about
> moving the data to a different database (thorough replication or nightly
> database copy) but we need either an additional server (perhaps DSO) but this
> will need an extra license. Enabling archiving at the form level is another
> option but we will still have to use the primary server and additional
> configuration
> needs to be done at the queues and thread level as well and plenty of table
> indexing.
> Any pointer will be very much appreciated.
>  
> BTW this is ARS7.1
>  
> Thank you
> frex
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "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"

performance issue

[Frex Popo]

Hi everyone,
 
In addition to a reporting server, we have some 10 forms in
a primary server with large volume of data. Adhoc AR Reports and searches are 
executed
on the data nearly every day and this is causing some serious performance
issues. 
Any thought on how to resolve this? We were thinking about
moving the data to a different database (thorough replication or nightly
database copy) but we need either an additional server (perhaps DSO) but this
will need an extra license. Enabling archiving at the form level is another
option but we will still have to use the primary server and additional 
configuration
needs to be done at the queues and thread level as well and plenty of table
indexing.
Any pointer will be very much appreciated.
 
BTW this is ARS7.1
 
Thank you
frex

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

CMDB 7.6.04 –RE Job performance issue

[Harry]

Hi List,

 

We have one RE Job but its taking much more time to process the records 
than it should take...

Its processing only 12 records per sec..instead it should process 60 
records per seconds...

  

All possible suggestions are appreciated

 

-Harry

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Email engine performance issue.

[Sathish Kumar]

Adarsh,

Which version and patch of email engine you are running? If its above 7.1 patch 
9, i know the range of inbound and outbound emails you mentioned are pretty 
small to cause any trouble. I had seen enviornment were we had 150,000 emails 
processed  per day without any issue and pretty good amount of inbound email 
templates.

If you raise a issue to BMC support they must provide the best configuration by 
reviewing your email engine configuration file.

At the same time you can try to identify the pattern which must be causing the 
issue by enabling the email debug logs to see where the email engine is waiting 
or taking more time to completed and also see if the content of those email 
templates are huge, some times i had seen if the content of the email template 
to be processed if huge then the email engine may hang or take longer time to 
process.

Good luck

-Sathish

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Email engine performance issue.

[Axton]

t;>> "com.remedy.arsys.emaildaemon.MailboxPollingUnitIsMinutes=false" to
> >>>> EmailDaemon.properties file
> >>>   This should convert the polling interval to seconds .. I have kept
> >>> the polling interval as 15sec .. I am not sure if this is working ..
> >>> :-(
> >>>
> >>>>I will try enabling the logs and check them..
> >>>
> >>> Regards,
> >>> Adarsh..
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> On Fri, Sep 30, 2011 at 2:13 PM, Misi Mladoniczky  wrote:
> >>>> Hi,
> >>>>
> >>>> Turn on API/FLTR/ESCL logging on the server, and capture what happens.
> >>>>
> >>>> Have you truncated your Error messages? How many records do you have
> >>>> in
> >>>> there?
> >>>>
> >>>> How do you lower your polling interval below 1 minute? I thought that
> >>>> was
> >>>> the minimum interval.
> >>>>
> >>>> Add -Dmail.debug=true to your emailstart.sh file and restart email
> >>>> engine.
> >>>> Then check your logs. Or do at trace -f on the log file to see what
> >>>> happens interactively. (I presume you are on unix/linux)
> >>>>
> >>>>Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
> >>>> 2011)
> >>>>
> >>>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> >>>> * 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 Listers,
> >>>>>
> >>>>> We are facing lot of performance issue with email engine and I have
> >>>>> tried most of the steps from the below link ..
> >>>>>
> >>>>>
> http://remediesforremedy.com/2011/08/how-to-tune-ar-email-engine-to-get-optimal-permormance/
> >>>>>
> >>>>> But the performance issue still exists .. We have major problem in
> >>>>> email auto ticketing creation .
> >>>>>
> >>>>> the mail file size on the AIX box keeps on increasing .. polling
> >>>>> interval is 15sec but from observation i do not find the file size
> >>>>> decreasing every 15 sec..
> >>>>>
> >>>>> for private thread in have min and max as 10 and 12 thread..
> >>>>>
> >>>>> Is there any better way to troubleshoot the issue..
> >>>>>
> >>>>> Our daily incoming message ques is around 2000 per day and outgoing
> >>>>> is
> >>>>> around 9700 per day ..
> >>>>>
> >>>>>
> ___
> >>>>> 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"
> >>
> >
> >
> ___
> > 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"

Re: Email engine performance issue.

[Misi Mladoniczky]

Hi,

In my system you find the log in the {AREmailInstallDir}/Logs/emaild.sh_log.

The full version of RRR|Log has an annual subscription fee attached too
it, and the free version is limited to 50 API-calls and 500 SQL-calls. You
might be able to grep out a couple of calls from your log-file to allow
you to use the free version.

Online access is at https://www.rrr.se/cgi/rrrlog/main
Offline installer is at https://www.rrr.se/cgi/offlic

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* 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 Misi,
>
> I have another question, it may be a stupid question.. In the previous
> mail you have mentioned about enabling the logs. I don't see any file
> emailstart.sh to enter the comment.
>
> will it create the logs similar to emaild.sh_log in the Logs directory..
>
> and from where can I download .the full version of RRR|Log  ..:-)
>
>
> On Fri, Sep 30, 2011 at 2:56 PM, Misi Mladoniczky  wrote:
>> Hi,
>>
>> You learn something every day, I missed that setting ;-)
>>
>> The time between the polls should not be a problem for you. The
>> processing
>> should only be done one at a time anyway.
>>
>> It seems rather high to use 10-12 threads. I guess you have this number
>> specified for the mailbox threads as well?
>>
>> With the load you have, you should be able to clear out inbound/outbound
>> mails in a single thread. In theory at least. Each message would then
>> have
>> an average of 7.4 seconds to complete...
>>
>> Email debugging may point you to things that take time inside or outside
>> of Remedy.
>>
>> API/FLTR/SQL will give you information about individual things, such as
>> filters, that takes time within the AR System.
>>
>> AD: Please check out our RRR|Log utility that is ideal to find things
>> like
>> this in big API/FLTR/SQL log file.
>>
>>        Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>> * 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.
>>
>>> Thank you Misi for the reply ,
>>>
>>>>I have Truncated the error logs.  I do it every 2 days.
>>>
>>>> I have added
>>>> "com.remedy.arsys.emaildaemon.MailboxPollingUnitIsMinutes=false" to
>>>> EmailDaemon.properties file
>>>   This should convert the polling interval to seconds .. I have kept
>>> the polling interval as 15sec .. I am not sure if this is working ..
>>> :-(
>>>
>>>>I will try enabling the logs and check them..
>>>
>>> Regards,
>>> Adarsh..
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Fri, Sep 30, 2011 at 2:13 PM, Misi Mladoniczky  wrote:
>>>> Hi,
>>>>
>>>> Turn on API/FLTR/ESCL logging on the server, and capture what happens.
>>>>
>>>> Have you truncated your Error messages? How many records do you have
>>>> in
>>>> there?
>>>>
>>>> How do you lower your polling interval below 1 minute? I thought that
>>>> was
>>>> the minimum interval.
>>>>
>>>> Add -Dmail.debug=true to your emailstart.sh file and restart email
>>>> engine.
>>>> Then check your logs. Or do at trace -f on the log file to see what
>>>> happens interactively. (I presume you are on unix/linux)
>>>>
>>>>        Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
>>>> 2011)
>>>>
>>>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>>>> * 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 Listers,
>>>>>
>>>>> We are facing lot of performance issue with email engine and I have
>>>>> tried most of the steps from the below link ..
>>>>>
&g

Re: Email engine performance issue.

[Adarsh]

Hi Misi,

I have another question, it may be a stupid question.. In the previous
mail you have mentioned about enabling the logs. I don't see any file
emailstart.sh to enter the comment.

will it create the logs similar to emaild.sh_log in the Logs directory..

and from where can I download .the full version of RRR|Log  ..:-)


On Fri, Sep 30, 2011 at 2:56 PM, Misi Mladoniczky  wrote:
> Hi,
>
> You learn something every day, I missed that setting ;-)
>
> The time between the polls should not be a problem for you. The processing
> should only be done one at a time anyway.
>
> It seems rather high to use 10-12 threads. I guess you have this number
> specified for the mailbox threads as well?
>
> With the load you have, you should be able to clear out inbound/outbound
> mails in a single thread. In theory at least. Each message would then have
> an average of 7.4 seconds to complete...
>
> Email debugging may point you to things that take time inside or outside
> of Remedy.
>
> API/FLTR/SQL will give you information about individual things, such as
> filters, that takes time within the AR System.
>
> AD: Please check out our RRR|Log utility that is ideal to find things like
> this in big API/FLTR/SQL log file.
>
>        Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> * 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.
>
>> Thank you Misi for the reply ,
>>
>>>I have Truncated the error logs.  I do it every 2 days.
>>
>>> I have added
>>> "com.remedy.arsys.emaildaemon.MailboxPollingUnitIsMinutes=false" to
>>> EmailDaemon.properties file
>>   This should convert the polling interval to seconds .. I have kept
>> the polling interval as 15sec .. I am not sure if this is working ..
>> :-(
>>
>>>I will try enabling the logs and check them..
>>
>> Regards,
>> Adarsh..
>>
>>
>>
>>
>>
>>
>> On Fri, Sep 30, 2011 at 2:13 PM, Misi Mladoniczky  wrote:
>>> Hi,
>>>
>>> Turn on API/FLTR/ESCL logging on the server, and capture what happens.
>>>
>>> Have you truncated your Error messages? How many records do you have in
>>> there?
>>>
>>> How do you lower your polling interval below 1 minute? I thought that
>>> was
>>> the minimum interval.
>>>
>>> Add -Dmail.debug=true to your emailstart.sh file and restart email
>>> engine.
>>> Then check your logs. Or do at trace -f on the log file to see what
>>> happens interactively. (I presume you are on unix/linux)
>>>
>>>        Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>>
>>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>>> * 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 Listers,
>>>>
>>>> We are facing lot of performance issue with email engine and I have
>>>> tried most of the steps from the below link ..
>>>>
>>>> http://remediesforremedy.com/2011/08/how-to-tune-ar-email-engine-to-get-optimal-permormance/
>>>>
>>>> But the performance issue still exists .. We have major problem in
>>>> email auto ticketing creation .
>>>>
>>>> the mail file size on the AIX box keeps on increasing .. polling
>>>> interval is 15sec but from observation i do not find the file size
>>>> decreasing every 15 sec..
>>>>
>>>> for private thread in have min and max as 10 and 12 thread..
>>>>
>>>> Is there any better way to troubleshoot the issue..
>>>>
>>>> Our daily incoming message ques is around 2000 per day and outgoing is
>>>> around 9700 per day ..
>>>>
>>>> ___
>>>> 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"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Email engine performance issue.

[rajat sharma]

When was the last time you patched your email engine ?? Please look for
latest email engine patches. We did the patching at our environment and the
issue was almost resolved.

Thanks,
Rajat Sharma

On Fri, Sep 30, 2011 at 10:26 AM, Misi Mladoniczky  wrote:

> Hi,
>
> You learn something every day, I missed that setting ;-)
>
> The time between the polls should not be a problem for you. The processing
> should only be done one at a time anyway.
>
> It seems rather high to use 10-12 threads. I guess you have this number
> specified for the mailbox threads as well?
>
> With the load you have, you should be able to clear out inbound/outbound
> mails in a single thread. In theory at least. Each message would then have
> an average of 7.4 seconds to complete...
>
> Email debugging may point you to things that take time inside or outside
> of Remedy.
>
> API/FLTR/SQL will give you information about individual things, such as
> filters, that takes time within the AR System.
>
> AD: Please check out our RRR|Log utility that is ideal to find things like
> this in big API/FLTR/SQL log file.
>
>Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> * 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.
>
> > Thank you Misi for the reply ,
> >
> >>I have Truncated the error logs.  I do it every 2 days.
> >
> >> I have added
> >> "com.remedy.arsys.emaildaemon.MailboxPollingUnitIsMinutes=false" to
> >> EmailDaemon.properties file
> >   This should convert the polling interval to seconds .. I have kept
> > the polling interval as 15sec .. I am not sure if this is working ..
> > :-(
> >
> >>I will try enabling the logs and check them..
> >
> > Regards,
> > Adarsh..
> >
> >
> >
> >
> >
> >
> > On Fri, Sep 30, 2011 at 2:13 PM, Misi Mladoniczky  wrote:
> >> Hi,
> >>
> >> Turn on API/FLTR/ESCL logging on the server, and capture what happens.
> >>
> >> Have you truncated your Error messages? How many records do you have in
> >> there?
> >>
> >> How do you lower your polling interval below 1 minute? I thought that
> >> was
> >> the minimum interval.
> >>
> >> Add -Dmail.debug=true to your emailstart.sh file and restart email
> >> engine.
> >> Then check your logs. Or do at trace -f on the log file to see what
> >> happens interactively. (I presume you are on unix/linux)
> >>
> >>Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
> 2011)
> >>
> >> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> >> * 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 Listers,
> >>>
> >>> We are facing lot of performance issue with email engine and I have
> >>> tried most of the steps from the below link ..
> >>>
> >>>
> http://remediesforremedy.com/2011/08/how-to-tune-ar-email-engine-to-get-optimal-permormance/
> >>>
> >>> But the performance issue still exists .. We have major problem in
> >>> email auto ticketing creation .
> >>>
> >>> the mail file size on the AIX box keeps on increasing .. polling
> >>> interval is 15sec but from observation i do not find the file size
> >>> decreasing every 15 sec..
> >>>
> >>> for private thread in have min and max as 10 and 12 thread..
> >>>
> >>> Is there any better way to troubleshoot the issue..
> >>>
> >>> Our daily incoming message ques is around 2000 per day and outgoing is
> >>> around 9700 per day ..
> >>>
> >>>
> ___
> >>> 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"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Email engine performance issue.

[Misi Mladoniczky]

Hi,

You learn something every day, I missed that setting ;-)

The time between the polls should not be a problem for you. The processing
should only be done one at a time anyway.

It seems rather high to use 10-12 threads. I guess you have this number
specified for the mailbox threads as well?

With the load you have, you should be able to clear out inbound/outbound
mails in a single thread. In theory at least. Each message would then have
an average of 7.4 seconds to complete...

Email debugging may point you to things that take time inside or outside
of Remedy.

API/FLTR/SQL will give you information about individual things, such as
filters, that takes time within the AR System.

AD: Please check out our RRR|Log utility that is ideal to find things like
this in big API/FLTR/SQL log file.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* 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.

> Thank you Misi for the reply ,
>
>>I have Truncated the error logs.  I do it every 2 days.
>
>> I have added
>> "com.remedy.arsys.emaildaemon.MailboxPollingUnitIsMinutes=false" to
>> EmailDaemon.properties file
>   This should convert the polling interval to seconds .. I have kept
> the polling interval as 15sec .. I am not sure if this is working ..
> :-(
>
>>I will try enabling the logs and check them..
>
> Regards,
> Adarsh..
>
>
>
>
>
>
> On Fri, Sep 30, 2011 at 2:13 PM, Misi Mladoniczky  wrote:
>> Hi,
>>
>> Turn on API/FLTR/ESCL logging on the server, and capture what happens.
>>
>> Have you truncated your Error messages? How many records do you have in
>> there?
>>
>> How do you lower your polling interval below 1 minute? I thought that
>> was
>> the minimum interval.
>>
>> Add -Dmail.debug=true to your emailstart.sh file and restart email
>> engine.
>> Then check your logs. Or do at trace -f on the log file to see what
>> happens interactively. (I presume you are on unix/linux)
>>
>>        Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>> * 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 Listers,
>>>
>>> We are facing lot of performance issue with email engine and I have
>>> tried most of the steps from the below link ..
>>>
>>> http://remediesforremedy.com/2011/08/how-to-tune-ar-email-engine-to-get-optimal-permormance/
>>>
>>> But the performance issue still exists .. We have major problem in
>>> email auto ticketing creation .
>>>
>>> the mail file size on the AIX box keeps on increasing .. polling
>>> interval is 15sec but from observation i do not find the file size
>>> decreasing every 15 sec..
>>>
>>> for private thread in have min and max as 10 and 12 thread..
>>>
>>> Is there any better way to troubleshoot the issue..
>>>
>>> Our daily incoming message ques is around 2000 per day and outgoing is
>>> around 9700 per day ..
>>>
>>> ___
>>> 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"

Re: Email engine performance issue.

[Adarsh]

Thank you Misi for the reply ,

>I have Truncated the error logs.  I do it every 2 days.

> I have added "com.remedy.arsys.emaildaemon.MailboxPollingUnitIsMinutes=false" 
> to EmailDaemon.properties file
  This should convert the polling interval to seconds .. I have kept
the polling interval as 15sec .. I am not sure if this is working ..
:-(

>I will try enabling the logs and check them..

Regards,
Adarsh..






On Fri, Sep 30, 2011 at 2:13 PM, Misi Mladoniczky  wrote:
> Hi,
>
> Turn on API/FLTR/ESCL logging on the server, and capture what happens.
>
> Have you truncated your Error messages? How many records do you have in
> there?
>
> How do you lower your polling interval below 1 minute? I thought that was
> the minimum interval.
>
> Add -Dmail.debug=true to your emailstart.sh file and restart email engine.
> Then check your logs. Or do at trace -f on the log file to see what
> happens interactively. (I presume you are on unix/linux)
>
>        Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> * 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 Listers,
>>
>> We are facing lot of performance issue with email engine and I have
>> tried most of the steps from the below link ..
>>
>> http://remediesforremedy.com/2011/08/how-to-tune-ar-email-engine-to-get-optimal-permormance/
>>
>> But the performance issue still exists .. We have major problem in
>> email auto ticketing creation .
>>
>> the mail file size on the AIX box keeps on increasing .. polling
>> interval is 15sec but from observation i do not find the file size
>> decreasing every 15 sec..
>>
>> for private thread in have min and max as 10 and 12 thread..
>>
>> Is there any better way to troubleshoot the issue..
>>
>> Our daily incoming message ques is around 2000 per day and outgoing is
>> around 9700 per day ..
>>
>> ___
>> 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"

Re: Email engine performance issue.

[Misi Mladoniczky]

Hi,

Turn on API/FLTR/ESCL logging on the server, and capture what happens.

Have you truncated your Error messages? How many records do you have in
there?

How do you lower your polling interval below 1 minute? I thought that was
the minimum interval.

Add -Dmail.debug=true to your emailstart.sh file and restart email engine.
Then check your logs. Or do at trace -f on the log file to see what
happens interactively. (I presume you are on unix/linux)

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* 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 Listers,
>
> We are facing lot of performance issue with email engine and I have
> tried most of the steps from the below link ..
>
> http://remediesforremedy.com/2011/08/how-to-tune-ar-email-engine-to-get-optimal-permormance/
>
> But the performance issue still exists .. We have major problem in
> email auto ticketing creation .
>
> the mail file size on the AIX box keeps on increasing .. polling
> interval is 15sec but from observation i do not find the file size
> decreasing every 15 sec..
>
> for private thread in have min and max as 10 and 12 thread..
>
> Is there any better way to troubleshoot the issue..
>
> Our daily incoming message ques is around 2000 per day and outgoing is
> around 9700 per day ..
>
> ___
> 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"

Email engine performance issue.

[Adarsh]

Hi Listers,

We are facing lot of performance issue with email engine and I have
tried most of the steps from the below link ..

http://remediesforremedy.com/2011/08/how-to-tune-ar-email-engine-to-get-optimal-permormance/

But the performance issue still exists .. We have major problem in
email auto ticketing creation .

the mail file size on the AIX box keeps on increasing .. polling
interval is 15sec but from observation i do not find the file size
decreasing every 15 sec..

for private thread in have min and max as 10 and 12 thread..

Is there any better way to troubleshoot the issue..

Our daily incoming message ques is around 2000 per day and outgoing is
around 9700 per day ..

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Performance issue on Menu

[Sathish Kumar]

Since you are in 7.1, and huge queries will cause application memory to 
increase and could even lead to crash when it reaches the threshold(2G for 
Windows for 4G for Unix enviornments)

I would recommend you to review/test the memory growth when such menu is 
developed, were it can be accessed by lot of users very frequently.

-Sathish

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Performance issue on Menu

[William Rentfrow]

However 
 
One of my current customers has 40,000+ sites.  Consequently the "Site+"
field pulls 120,000+ records because the way the application was
structured the Region/Site Group/Site menus do not just pull form site -
they pull from a cascading set of join forms that include things like
site aliases, etc.
 
The tiered menu system should help in this Instance - BUT - the best
practice view blow that philosophy out of the water.  There is specific
workflow in several places that set Region and Site Group to NULL when
you hit the "Site+" field.  In other places those fields aren't even on
the form.
 
4 minutes later you get your menu with120,000 records.  Believe it or
not they are laid out well enough that you can find your site
quicklybut there's some weird design in there.  We're still working
with BMC support and R&D on this issue.
 

William Rentfrow 
Principal Consultant, StrataCom Inc. 
wrentf...@stratacominc.com 
Blog: www.williamrentfrow.com 
O 715-592-5185 
C 715-410-8056 

 



From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg
Sent: Friday, June 10, 2011 10:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance issue on Menu


** Agreed - the menu is too large for actual use -- auto-complete would
be a great solution for both usability and performance. 

Also -- for fun -- it is good to look at this occasionally for
thoughts/inspiration...

http://developer.apple.com/library/mac/#documentation/UserExperience/Con
ceptual/AppleHIGuidelines/XHIGIntro/XHIGIntro.html



<http://developer.apple.com/library/mac/#documentation/UserExperience/Co
nceptual/AppleHIGuidelines/XHIGIntro/XHIGIntro.html> -John




On Jun 10, 2011, at 10:26 AM, Easter, David wrote:

** 

Another possibility (perhaps more forward looking) is to upgrade to AR
System 7.6.04 or later and utilize the auto-complete feature.  BMC has
tune the auto-complete to address this exact use case (a menu with a
very large number of items - like a customer list).  

Auto-complete was actually introduced in AR System 7.5.00, but the
performance increase for this use case was added in 7.6.04.  

28-Jan-2011 What's New: BMC Remedy Action Request System 7.6.04 PDF
<http://documents.bmc.com/supportu/documents/42/26/194226/194226.pdf> 

Enhanced auto-completion

The automatic complete feature is improved to handle large data sets in
search menus that are attached to a character field (for example, over
10,000 entries). This feature also minimizes unwanted searches.

For more information, see the Form and Application Objects Guide.

-David J. Easter

Manager of Product Management, Remedy Platform

BMC Software, Inc.

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Friday, June 10, 2011 07:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance issue on Menu

** 

Form a UI design perspective that is kind of harsh; here's your 22,000
records, select one.  Unless you have a really good drill down tier
structure to hide many of the values that do not apply it is likely
people would pick the wrong value out of frustration. 

You are already seeing the performance impact in the amount of time it
takes to open the menu but think about why. That is 22k records being
sent over the wire and being stored in memory on the client's computer.
With modern computers and a strong LAN this probably isn't much of an
issue but will that be the case for all of your users?

Can you give us a little more detail about your requirements? I am sure
the community could help with a solution :) 

Jason

On Jun 10, 2011 6:25 AM, "Kemes, Lisa"  wrote:
> I want them to choose one of the records instead Typing it in and
getting it wrong. It would better to do it another way instead of giving
them a selection of all the records to choose from for sure!
> 
> Lisa 
> 
> 
> -Original Message-
> From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
> Sent: Friday, June 10, 2011 9:20 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Performance issue on Menu
> 
> Hi,
> 
> If the data does not need to be 100% up to date, this seems like a
good candidate for a nightly report?
> 
> When it is useful for human to examine 22,000 lines when clicking on a
char-menu or scrolling a table-field?
> 
> If the person needs to find one specific line, it seems likely that
you can do a multiple-tier selection of some kind?
> 
> Best Regards - Mi

Re: Performance issue on Menu

[John Sundberg]

Agreed - the menu is too large for actual use -- auto-complete would be a great 
solution for both usability and performance.

Also -- for fun -- it is good to look at this occasionally for 
thoughts/inspiration...

http://developer.apple.com/library/mac/#documentation/UserExperience/Conceptual/AppleHIGuidelines/XHIGIntro/XHIGIntro.html



-John




On Jun 10, 2011, at 10:26 AM, Easter, David wrote:

**
Another possibility (perhaps more forward looking) is to upgrade to AR System 
7.6.04 or later and utilize the auto-complete feature.  BMC has tune the 
auto-complete to address this exact use case (a menu with a very large number 
of items – like a customer list). 

 

Auto-complete was actually introduced in AR System 7.5.00, but the performance 
increase for this use case was added in 7.6.04. 

 

28-Jan-2011 What’s New: BMC Remedy Action Request System 7.6.04 PDF

 

Enhanced auto-completion

The automatic complete feature is improved to handle large data sets in search 
menus that are attached to a character field (for example, over 10,000 
entries). This feature also minimizes unwanted searches.

 

For more information, see the Form and Application Objects Guide.

 

-David J. Easter

Manager of Product Management, Remedy Platform

BMC Software, Inc.

 

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Friday, June 10, 2011 07:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance issue on Menu

 

**

Form a UI design perspective that is kind of harsh; here's your 22,000 records, 
select one.  Unless you have a really good drill down tier structure to hide 
many of the values that do not apply it is likely people would pick the wrong 
value out of frustration.

You are already seeing the performance impact in the amount of time it takes to 
open the menu but think about why. That is 22k records being sent over the wire 
and being stored in memory on the client's computer.  With modern computers and 
a strong LAN this probably isn't much of an issue but will that be the case for 
all of your users?

Can you give us a little more detail about your requirements? I am sure the 
community could help with a solution :)

Jason

On Jun 10, 2011 6:25 AM, "Kemes, Lisa"  wrote:
> I want them to choose one of the records instead Typing it in and getting it 
> wrong. It would better to do it another way instead of giving them a 
> selection of all the records to choose from for sure!
> 
> Lisa 
> 
> 
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
> Sent: Friday, June 10, 2011 9:20 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Performance issue on Menu
> 
> Hi,
> 
> If the data does not need to be 100% up to date, this seems like a good 
> candidate for a nightly report?
> 
> When it is useful for human to examine 22,000 lines when clicking on a 
> char-menu or scrolling a table-field?
> 
> If the person needs to find one specific line, it seems likely that you can 
> do a multiple-tier selection of some kind?
> 
> Best Regards - Misi, RRR AB, http://rrr.se
> 
>> That's probably what I'll have to end up doing (limiting the selection).
>> I'll think of a different way (there are many ways to skin a cat) 
>> <-where did this saying come from anyway?
>>
>> Anyway, just wondering if I was doing something wrong, but if this 
>> performance is as expected for 22,000+ records, I'll figure out 
>> another way to gather this data for the customer. Maybe I'll make 
>> them type in the first few letters and only bring back those records or 
>> something.
>>
>> Thanks!!
>>
>> Lisa
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList) 
>> [mailto_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

--
John Sundberg

Kinetic Data, Inc.
"Building a Better Service Experience"
Recipient of:
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award

john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com










___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Performance issue on Menu

[Easter, David]

Another possibility (perhaps more forward looking) is to upgrade to AR System 
7.6.04 or later and utilize the auto-complete feature.  BMC has tune the 
auto-complete to address this exact use case (a menu with a very large number 
of items - like a customer list).

Auto-complete was actually introduced in AR System 7.5.00, but the performance 
increase for this use case was added in 7.6.04.

28-Jan-2011 What's New: BMC Remedy Action Request System 7.6.04 
PDF<http://documents.bmc.com/supportu/documents/42/26/194226/194226.pdf>

Enhanced auto-completion
The automatic complete feature is improved to handle large data sets in search 
menus that are attached to a character field (for example, over 10,000 
entries). This feature also minimizes unwanted searches.

For more information, see the Form and Application Objects Guide.

-David J. Easter
Manager of Product Management, Remedy Platform
BMC Software, Inc.

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Friday, June 10, 2011 07:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance issue on Menu

**

Form a UI design perspective that is kind of harsh; here's your 22,000 records, 
select one.  Unless you have a really good drill down tier structure to hide 
many of the values that do not apply it is likely people would pick the wrong 
value out of frustration.

You are already seeing the performance impact in the amount of time it takes to 
open the menu but think about why. That is 22k records being sent over the wire 
and being stored in memory on the client's computer.  With modern computers and 
a strong LAN this probably isn't much of an issue but will that be the case for 
all of your users?

Can you give us a little more detail about your requirements? I am sure the 
community could help with a solution :)

Jason
On Jun 10, 2011 6:25 AM, "Kemes, Lisa" 
mailto:lisa.ke...@te.com>> wrote:
> I want them to choose one of the records instead Typing it in and getting it 
> wrong. It would better to do it another way instead of giving them a 
> selection of all the records to choose from for sure!
>
> Lisa
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Misi 
> Mladoniczky
> Sent: Friday, June 10, 2011 9:20 AM
> To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
> Subject: Re: Performance issue on Menu
>
> Hi,
>
> If the data does not need to be 100% up to date, this seems like a good 
> candidate for a nightly report?
>
> When it is useful for human to examine 22,000 lines when clicking on a 
> char-menu or scrolling a table-field?
>
> If the person needs to find one specific line, it seems likely that you can 
> do a multiple-tier selection of some kind?
>
> Best Regards - Misi, RRR AB, http://rrr.se
>
>> That's probably what I'll have to end up doing (limiting the selection).
>> I'll think of a different way (there are many ways to skin a cat)
>> <-where did this saying come from anyway?
>>
>> Anyway, just wondering if I was doing something wrong, but if this
>> performance is as expected for 22,000+ records, I'll figure out
>> another way to gather this data for the customer. Maybe I'll make
>> them type in the first few letters and only bring back those records or 
>> something.
>>
>> Thanks!!
>>
>> Lisa
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList)
>> [mailto_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"

Re: Performance issue on Menu

[Jason Miller]

Form a UI design perspective that is kind of harsh; here's your 22,000
records, select one.  Unless you have a really good drill down tier
structure to hide many of the values that do not apply it is likely people
would pick the wrong value out of frustration.

You are already seeing the performance impact in the amount of time it takes
to open the menu but think about why. That is 22k records being sent over
the wire and being stored in memory on the client's computer.  With modern
computers and a strong LAN this probably isn't much of an issue but will
that be the case for all of your users?

Can you give us a little more detail about your requirements? I am sure the
community could help with a solution :)

Jason
On Jun 10, 2011 6:25 AM, "Kemes, Lisa"  wrote:
> I want them to choose one of the records instead Typing it in and getting
it wrong. It would better to do it another way instead of giving them a
selection of all the records to choose from for sure!
>
> Lisa
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
> Sent: Friday, June 10, 2011 9:20 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Performance issue on Menu
>
> Hi,
>
> If the data does not need to be 100% up to date, this seems like a good
candidate for a nightly report?
>
> When it is useful for human to examine 22,000 lines when clicking on a
char-menu or scrolling a table-field?
>
> If the person needs to find one specific line, it seems likely that you
can do a multiple-tier selection of some kind?
>
> Best Regards - Misi, RRR AB, http://rrr.se
>
>> That's probably what I'll have to end up doing (limiting the selection).
>> I'll think of a different way (there are many ways to skin a cat)
>> <-where did this saying come from anyway?
>>
>> Anyway, just wondering if I was doing something wrong, but if this
>> performance is as expected for 22,000+ records, I'll figure out
>> another way to gather this data for the customer. Maybe I'll make
>> them type in the first few letters and only bring back those records or
something.
>>
>> Thanks!!
>>
>> Lisa
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList)
>> [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
>> Sent: Friday, June 10, 2011 8:55 AM
>> To: arslist@ARSLIST.ORG
>> Subject: Re: Performance issue on Menu
>>
>> Hi,
>>
>> If you want to load 22,000 records into your client, it will always
>> take time.
>>
>> Would it not be possible to limit the selection?
>>
>> If you are loading all records, indexes are not important, as
>> everything must be read anyhow.
>>
>> 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.
>>
>>> I have a table with about 22,000 records. I have a unique index on 2
>>> field on this table.
>>>
>>> On another form I have a Character field that connects via a menu to
>>> these records. Even though I have an index, it takes a good 40
>>> seconds for the menu item to show all of the records when activated.
>>>
>>> Is there any way to increase the performance on this? Looks like it
>>> works this way on the desktop client and the midtier.
>>>
>>> ARS 7.1 p7
>>> Windows 2003
>>> Oracle 10g
>>>
>>> Lisa Kemes
>>> AR System Developer
>>> TE Information Systems
>>> Global Infrastructure and Ops
>>> +01 717 810 2408 tel
>>> +01 717 602 9460 mobile
>>> lisa.ke...@te.com
>>> MS 161-43
>>> P.O. Box 3608
>>> Harrisburg, PA 17105-3608
>>>
>>> [cid:image001.gif@01CC2749.FBEC6050]<http://www.te.com/>
>>> www.te.com<http://www.te.com/>
>>>
>>> [cid:image002.png@01CC2749.FBEC6050]<http://twitter.com/teconnectivit
>>> y
>>> >[cid:image003.png@01CC2749.FBEC6050]<http://www.facebook.com/teconne
>>> >c
>>> tivity>[cid:image004.png@01CC2749.FBEC6050]<http://www.flickr.com/pho
>>> tivity>t
>>> os/teconnectivity/>[cid:image005.png@01CC2749.FBEC6050]<http://www.li
>>> n
>>> kedin.com/groups?gid=1591657>[cid:image006

Re: Performance issue on Menu

[Logan, Kelly]

As Misi noted, a multi-tiered menu could be very helpful here – if you have 
indexes declared, those same datapoints should be useful as groupings as well 
for a multi-tiered menu.  Or they could be separate elements set by the 
customer for the search to narrow the selection and make the query faster.  
These could be tiered elements like Product Categorization uses, in a 
multi-tiered menu or set of menus, or separate elements like Incident Matching 
(customer name, location, priority, etc) on a control panel with a list of 
query results in a table below.



Perhaps some of these datapoints could be set by the system from what is known 
about the user; without knowing the data involved it's hard to guess, but an 
example would be showing by default sites that are in the same state as the 
customer, or issues that are associated with the laptop the customer owns, or 
the top 10, 20, 100 choices made by similar customers.  This could also let you 
present most of the desired customer choices without having to do an 
unqualified query.




Kelly Logan, Sr. Systems Administrator (Remedy), GMS
ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 
USA | 734.997.4777
kelly.lo...@proquest.com<mailto:kelly.lo...@proquest.com>
www.proquest.com

ProQuest...Start here. 2010 InformationWeek 500 Top Innovator

P Please consider the environment before printing this email.

This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify the sender, and delete the 
message from your computer.





-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Friday, June 10, 2011 9:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance issue on Menu



I want them to choose one of the records instead Typing it in and getting it 
wrong.  It would better to do it another way instead of giving them a selection 
of all the records to choose from for sure!



Lisa





-Original Message-

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky

Sent: Friday, June 10, 2011 9:20 AM

To: arslist@ARSLIST.ORG

Subject: Re: Performance issue on Menu



Hi,



If the data does not need to be 100% up to date, this seems like a good 
candidate for a nightly report?



When it is useful for human to examine 22,000 lines when clicking on a 
char-menu or scrolling a table-field?



If the person needs to find one specific line, it seems likely that you can do 
a multiple-tier selection of some kind?



Best Regards - Misi, RRR AB, http://rrr.se



> That's probably what I'll have to end up doing (limiting the selection).

> I'll think of a different way (there are many ways to skin a cat)

> <-where did this saying come from anyway?

>

> Anyway, just wondering if I was doing something wrong, but if this

> performance is as expected for 22,000+ records, I'll figure out

> another way to gather this data for the customer.  Maybe I'll make

> them type in the first few letters and only bring back those records or 
> something.

>

> Thanks!!

>

> Lisa

>

> -Original Message-

> From: Action Request System discussion list(ARSList)

> [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky

> Sent: Friday, June 10, 2011 8:55 AM

> To: arslist@ARSLIST.ORG

> Subject: Re: Performance issue on Menu

>

> Hi,

>

> If you want to load 22,000 records into your client, it will always

> take time.

>

> Would it not be possible to limit the selection?

>

> If you are loading all records, indexes are not important, as

> everything must be read anyhow.

>

> 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.

>

>> I have a table with about 22,000 records. I have a unique index on 2

>> field on this table.

>>

>> On another form I have a Character field that connects via a menu to

>> these records.  Even though I have an index, it takes a good 40

>> seconds for the menu item to show all of the records when activated.

>>

>> Is there any way to increase the performance on this?  Looks like it

>> works this way on the desktop client and the midtier.

>>

>> ARS 7.1 p7

>> Windows 2003

>> Oracle 10g

>>

>> Lisa Kemes

>> AR System Developer

>> TE Information S

Re: Performance issue on Menu

[Kemes, Lisa]

I want them to choose one of the records instead Typing it in and getting it 
wrong.  It would better to do it another way instead of giving them a selection 
of all the records to choose from for sure!

Lisa 


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Friday, June 10, 2011 9:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance issue on Menu

Hi,

If the data does not need to be 100% up to date, this seems like a good 
candidate for a nightly report?

When it is useful for human to examine 22,000 lines when clicking on a 
char-menu or scrolling a table-field?

If the person needs to find one specific line, it seems likely that you can do 
a multiple-tier selection of some kind?

Best Regards - Misi, RRR AB, http://rrr.se

> That's probably what I'll have to end up doing (limiting the selection).
> I'll think of a different way (there are many ways to skin a cat)  
> <-where did this saying come from anyway?
>
> Anyway, just wondering if I was doing something wrong, but if this 
> performance is as expected for 22,000+ records, I'll figure out 
> another way to gather this data for the customer.  Maybe I'll make 
> them type in the first few letters and only bring back those records or 
> something.
>
> Thanks!!
>
> Lisa
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
> Sent: Friday, June 10, 2011 8:55 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Performance issue on Menu
>
> Hi,
>
> If you want to load 22,000 records into your client, it will always 
> take time.
>
> Would it not be possible to limit the selection?
>
> If you are loading all records, indexes are not important, as 
> everything must be read anyhow.
>
> 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.
>
>> I have a table with about 22,000 records. I have a unique index on 2 
>> field on this table.
>>
>> On another form I have a Character field that connects via a menu to 
>> these records.  Even though I have an index, it takes a good 40 
>> seconds for the menu item to show all of the records when activated.
>>
>> Is there any way to increase the performance on this?  Looks like it 
>> works this way on the desktop client and the midtier.
>>
>> ARS 7.1 p7
>> Windows 2003
>> Oracle 10g
>>
>> Lisa Kemes
>> AR System Developer
>> TE Information Systems
>> Global Infrastructure and Ops
>> +01 717 810 2408 tel
>> +01 717 602 9460 mobile
>> lisa.ke...@te.com
>> MS 161-43
>> P.O. Box 3608
>> Harrisburg, PA 17105-3608
>>
>> [cid:image001.gif@01CC2749.FBEC6050]<http://www.te.com/>
>> www.te.com<http://www.te.com/>
>>
>> [cid:image002.png@01CC2749.FBEC6050]<http://twitter.com/teconnectivit
>> y
>> >[cid:image003.png@01CC2749.FBEC6050]<http://www.facebook.com/teconne
>> >c
>> tivity>[cid:image004.png@01CC2749.FBEC6050]<http://www.flickr.com/pho
>> tivity>t
>> os/teconnectivity/>[cid:image005.png@01CC2749.FBEC6050]<http://www.li
>> n 
>> kedin.com/groups?gid=1591657>[cid:image006.png@01CC2749.FBEC6050]> p
>> ://www.youtube.com/teconnectivity>
>>
>>
>> _
>> _ _ 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"

Re: Performance issue on Menu

[Misi Mladoniczky]

Hi,

If the data does not need to be 100% up to date, this seems like a good
candidate for a nightly report?

When it is useful for human to examine 22,000 lines when clicking on a
char-menu or scrolling a table-field?

If the person needs to find one specific line, it seems likely that you
can do a multiple-tier selection of some kind?

Best Regards - Misi, RRR AB, http://rrr.se

> That's probably what I'll have to end up doing (limiting the selection).
> I'll think of a different way (there are many ways to skin a cat)  <-where
> did this saying come from anyway?
>
> Anyway, just wondering if I was doing something wrong, but if this
> performance is as expected for 22,000+ records, I'll figure out another
> way to gather this data for the customer.  Maybe I'll make them type in
> the first few letters and only bring back those records or something.
>
> Thanks!!
>
> Lisa
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
> Sent: Friday, June 10, 2011 8:55 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Performance issue on Menu
>
> Hi,
>
> If you want to load 22,000 records into your client, it will always take
> time.
>
> Would it not be possible to limit the selection?
>
> If you are loading all records, indexes are not important, as everything
> must be read anyhow.
>
> 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.
>
>> I have a table with about 22,000 records. I have a unique index on 2
>> field on this table.
>>
>> On another form I have a Character field that connects via a menu to
>> these records.  Even though I have an index, it takes a good 40
>> seconds for the menu item to show all of the records when activated.
>>
>> Is there any way to increase the performance on this?  Looks like it
>> works this way on the desktop client and the midtier.
>>
>> ARS 7.1 p7
>> Windows 2003
>> Oracle 10g
>>
>> Lisa Kemes
>> AR System Developer
>> TE Information Systems
>> Global Infrastructure and Ops
>> +01 717 810 2408 tel
>> +01 717 602 9460 mobile
>> lisa.ke...@te.com
>> MS 161-43
>> P.O. Box 3608
>> Harrisburg, PA 17105-3608
>>
>> [cid:image001.gif@01CC2749.FBEC6050]<http://www.te.com/>
>> www.te.com<http://www.te.com/>
>>
>> [cid:image002.png@01CC2749.FBEC6050]<http://twitter.com/teconnectivity
>> >[cid:image003.png@01CC2749.FBEC6050]<http://www.facebook.com/teconnec
>> tivity>[cid:image004.png@01CC2749.FBEC6050]<http://www.flickr.com/phot
>> os/teconnectivity/>[cid:image005.png@01CC2749.FBEC6050]<http://www.lin
>> kedin.com/groups?gid=1591657>[cid:image006.png@01CC2749.FBEC6050]> ://www.youtube.com/teconnectivity>
>>
>>
>> __
>> _ 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"

Re: Performance issue on Menu

[Matt Reinfeldt]

Lisa,

 

How are you qualifying the search on the menu?  If needed, run a SQL log to
see what query is actually getting passed to the database, and work from
there.  Often, it's not what you'd expect.  Hopefully, you're doing
something on the front-end to narrow down what shows in that menu from 22k,
though!  

 

Good luck,

 

Matt

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Friday, June 10, 2011 7:40 AM
To: arslist@ARSLIST.ORG
Subject: Performance issue on Menu

 

** 

I have a table with about 22,000 records. I have a unique index on 2 field
on this table.

 

On another form I have a Character field that connects via a menu to these
records.  Even though I have an index, it takes a good 40 seconds for the
menu item to show all of the records when activated.

 

Is there any way to increase the performance on this?  Looks like it works
this way on the desktop client and the midtier.

 

ARS 7.1 p7

Windows 2003

Oracle 10g

 

Lisa Kemes
AR System Developer
TE Information Systems

Global Infrastructure and Ops
+01 717 810 2408 tel
+01 717 602 9460 mobile
lisa.ke...@te.com
MS 161-43

P.O. Box 3608

Harrisburg, PA 17105-3608

 <http://www.te.com/> Description:
http://www.tycoelectronics.com/images/socialmedia/smallTElogo.gif
www.te.com <http://www.te.com/>  


 <http://twitter.com/teconnectivity> Description:
http://www.tycoelectronics.com/images/socialmedia/twitter.png
<http://www.facebook.com/teconnectivity> Description:
http://www.tycoelectronics.com/images/socialmedia/facebook.png
<http://www.flickr.com/photos/teconnectivity/> Description:
http://www.tycoelectronics.com/images/socialmedia/flickr.png
<http://www.linkedin.com/groups?gid=1591657> Description:
http://www.tycoelectronics.com/images/socialmedia/linkedin.png
<http://www.youtube.com/teconnectivity> Description:
http://www.tycoelectronics.com/images/socialmedia/youtube.png

 

_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"
<><><><><><>

Re: Performance issue on Menu

[Kemes, Lisa]

That's probably what I'll have to end up doing (limiting the selection).  I'll 
think of a different way (there are many ways to skin a cat)  <-where did this 
saying come from anyway?

Anyway, just wondering if I was doing something wrong, but if this performance 
is as expected for 22,000+ records, I'll figure out another way to gather this 
data for the customer.  Maybe I'll make them type in the first few letters and 
only bring back those records or something.

Thanks!!

Lisa 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Friday, June 10, 2011 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance issue on Menu

Hi,

If you want to load 22,000 records into your client, it will always take time.

Would it not be possible to limit the selection?

If you are loading all records, indexes are not important, as everything must 
be read anyhow.

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.

> I have a table with about 22,000 records. I have a unique index on 2 
> field on this table.
>
> On another form I have a Character field that connects via a menu to 
> these records.  Even though I have an index, it takes a good 40 
> seconds for the menu item to show all of the records when activated.
>
> Is there any way to increase the performance on this?  Looks like it 
> works this way on the desktop client and the midtier.
>
> ARS 7.1 p7
> Windows 2003
> Oracle 10g
>
> Lisa Kemes
> AR System Developer
> TE Information Systems
> Global Infrastructure and Ops
> +01 717 810 2408 tel
> +01 717 602 9460 mobile
> lisa.ke...@te.com
> MS 161-43
> P.O. Box 3608
> Harrisburg, PA 17105-3608
>
> [cid:image001.gif@01CC2749.FBEC6050]<http://www.te.com/>
> www.te.com<http://www.te.com/>
>
> [cid:image002.png@01CC2749.FBEC6050]<http://twitter.com/teconnectivity
> >[cid:image003.png@01CC2749.FBEC6050]<http://www.facebook.com/teconnec
> tivity>[cid:image004.png@01CC2749.FBEC6050]<http://www.flickr.com/phot
> os/teconnectivity/>[cid:image005.png@01CC2749.FBEC6050]<http://www.lin
> kedin.com/groups?gid=1591657>[cid:image006.png@01CC2749.FBEC6050] ://www.youtube.com/teconnectivity>
>
>
> __
> _ 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"

Re: Performance issue on Menu

[Misi Mladoniczky]

Hi,

If you want to load 22,000 records into your client, it will always take
time.

Would it not be possible to limit the selection?

If you are loading all records, indexes are not important, as everything
must be read anyhow.

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.

> I have a table with about 22,000 records. I have a unique index on 2 field
> on this table.
>
> On another form I have a Character field that connects via a menu to these
> records.  Even though I have an index, it takes a good 40 seconds for the
> menu item to show all of the records when activated.
>
> Is there any way to increase the performance on this?  Looks like it works
> this way on the desktop client and the midtier.
>
> ARS 7.1 p7
> Windows 2003
> Oracle 10g
>
> Lisa Kemes
> AR System Developer
> TE Information Systems
> Global Infrastructure and Ops
> +01 717 810 2408 tel
> +01 717 602 9460 mobile
> lisa.ke...@te.com
> MS 161-43
> P.O. Box 3608
> Harrisburg, PA 17105-3608
>
> [cid:image001.gif@01CC2749.FBEC6050]
> www.te.com
>
> [cid:image002.png@01CC2749.FBEC6050][cid:image003.png@01CC2749.FBEC6050][cid:image004.png@01CC2749.FBEC6050][cid:image005.png@01CC2749.FBEC6050][cid:image006.png@01CC2749.FBEC6050]
>
>
> ___
> 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"

Performance issue on Menu

[Kemes, Lisa]

I have a table with about 22,000 records. I have a unique index on 2 field on 
this table.

On another form I have a Character field that connects via a menu to these 
records.  Even though I have an index, it takes a good 40 seconds for the menu 
item to show all of the records when activated.

Is there any way to increase the performance on this?  Looks like it works this 
way on the desktop client and the midtier.

ARS 7.1 p7
Windows 2003
Oracle 10g

Lisa Kemes
AR System Developer
TE Information Systems
Global Infrastructure and Ops
+01 717 810 2408 tel
+01 717 602 9460 mobile
lisa.ke...@te.com
MS 161-43
P.O. Box 3608
Harrisburg, PA 17105-3608

[cid:image001.gif@01CC2749.FBEC6050]
www.te.com

[cid:image002.png@01CC2749.FBEC6050][cid:image003.png@01CC2749.FBEC6050][cid:image004.png@01CC2749.FBEC6050][cid:image005.png@01CC2749.FBEC6050][cid:image006.png@01CC2749.FBEC6050]


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<><><><><><>

Re: Ramdom Performance issue.

[Misi Mladoniczky]

Hi,

This will add load to your system mainly when you do not have other
qualification criteria that narrows down the search, and makes good use of
your indexes.

If you do an unqualified search, the C112-additions to the SELECT-statment
can definitely add a lot of load to the query.

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.

> Interesting that you say ignore C112 clauses.
> My Overview Console search adds C112 LIKE clauses.
>
> SELECT
> T943.C1,C10,C7,C100164,C179,C23009,C301626500,C100161,C100218,C3,C100019,C100018
> FROM T943 WHERE (((T943.C112 LIKE N'%;''user'';%') OR (T943.C112 LIKE
> N'%;0;%') OR (T943.C112 LIKE N'%;-1098;%') OR (T943.C112 LIKE
> N'%;-2;%') OR (T943.C112 LIKE N'%;-20026;%') OR (T943.C112 LIKE
> N'%;803;%') OR (T943.C112 LIKE N'%;804;%') OR (T943.C112 LIKE N'%;
> 20061;%') OR (T943.C112 LIKE N'%;20313;%') OR (T943.C112 LIKE N'%;
> 20316;%') OR (T943.C112 LIKE N'%;13006;%') OR (T943.C112 LIKE N'%;
> 20055;%') OR (T943.C112 LIKE N'%;20211;%') OR (T943.C112 LIKE N'%;
> 20221;%') OR (T943.C112 LIKE N'%;20315;%') OR (T943.C112 LIKE N'%;
> 11;%') OR (T943.C112 LIKE N'%;100113;%') OR (T943.C112
> LIKE N'%;20032;%') OR (T943.C112 LIKE N'%;20026;%') OR (T943.C112 LIKE
> N'%;2;%') OR (T943.C112 LIKE N'%;20012;%') OR (T943.C112 LIKE N'%;
> 20214;%') OR (T943.C112 LIKE N'%;20213;%') OR (T943.C112 LIKE N'%;
> 20302;%') OR (T943.C112 LIKE N'%;20218;%') OR (T943.C112 LIKE N'%;
> 20003;%') OR (T943.C112 LIKE N'%;100058;%'))
>
> This clause is added when Unrestricted Access is not checked.
> If I check Unrestricted access, it doesn't add that clause.
>
> Also having that clause in the SQL statement adds 5-8 seconds to the
> query and makes my CPU usage jump from 60% to 100% for the query.
>
> I cannot pinpoint where that clause gets added either.  It seems to be
> added at the start of any console search.  incident, problem, work
> order or overview and is solely based on if that Unrestricted Access
> is checked or not.
>
> We have Multitenancy turned on and are on ARS 7.1 patch 3, ITSM 7.0.3
>
> I'm wondering if it's similar to the OPs issue
>
>
>
> On Jan 24, 10:00 am, "Mueller, Doug"  wrote:
>> Viki,
>>
>> As Axton noted, although it looks BIG, ignore the C112 clauses in any
>> WHERE clause when looking at
>> AR System logs.  This also includes any C60xxx fields.  All of these
>> clauses will be at the end of the query.
>> They may be large (if you are in a lot of groups).  They do not affect
>> the overall performance of the system.
>>
>> So, you get down in this case to the very simply query Axton has
>> indicated.  This is an UNQUALIFIED
>> search of the given table (T28).
>>
>> First, do you have "disallow unqualified queries" server option set.
>>  This command would indicate you do not
>> have this set.  It is recommended that you do to control this type of
>> unqualified query from accidentally
>> happening.
>>
>> If you turn on SQL logging at the AR System level, it will tell you a
>> lot of information.
>>
>>    What login issued the command
>>    When
>>    From what type of client (the client type can tell you it came from
>> the mid-tier or a specific utility or if 0, it
>>         generally means from a custom API program)
>>
>> If you turn on various types of logs, one might include the IP address
>> too and then you can see the user and
>> the IP address and track back to the machine the command is coming from.
>>
>> All this can help track the problem.
>>
>> But, setting the option to disallow unqualified queries may go a long
>> way toward helping to either stop
>> accidents or to cause someone to come and ask you why their unqualified
>> search stopped working
>>
>> Note you have a little bit of a clue about the user.  They are not an
>> Administrator and they are in all the
>> groups that show up in the query below that field 112 is being searched
>> for.
>>
>> I hope this helps,
>>
>> Doug Mueller
>>
>> 

Re: Ramdom Performance issue.

[remedy lee]

Interesting that you say ignore C112 clauses.
My Overview Console search adds C112 LIKE clauses.

SELECT
T943.C1,C10,C7,C100164,C179,C23009,C301626500,C100161,C100218,C3,C100019,C100018
FROM T943 WHERE (((T943.C112 LIKE N'%;''user'';%') OR (T943.C112 LIKE
N'%;0;%') OR (T943.C112 LIKE N'%;-1098;%') OR (T943.C112 LIKE
N'%;-2;%') OR (T943.C112 LIKE N'%;-20026;%') OR (T943.C112 LIKE
N'%;803;%') OR (T943.C112 LIKE N'%;804;%') OR (T943.C112 LIKE N'%;
20061;%') OR (T943.C112 LIKE N'%;20313;%') OR (T943.C112 LIKE N'%;
20316;%') OR (T943.C112 LIKE N'%;13006;%') OR (T943.C112 LIKE N'%;
20055;%') OR (T943.C112 LIKE N'%;20211;%') OR (T943.C112 LIKE N'%;
20221;%') OR (T943.C112 LIKE N'%;20315;%') OR (T943.C112 LIKE N'%;
11;%') OR (T943.C112 LIKE N'%;100113;%') OR (T943.C112
LIKE N'%;20032;%') OR (T943.C112 LIKE N'%;20026;%') OR (T943.C112 LIKE
N'%;2;%') OR (T943.C112 LIKE N'%;20012;%') OR (T943.C112 LIKE N'%;
20214;%') OR (T943.C112 LIKE N'%;20213;%') OR (T943.C112 LIKE N'%;
20302;%') OR (T943.C112 LIKE N'%;20218;%') OR (T943.C112 LIKE N'%;
20003;%') OR (T943.C112 LIKE N'%;100058;%'))

This clause is added when Unrestricted Access is not checked.
If I check Unrestricted access, it doesn't add that clause.

Also having that clause in the SQL statement adds 5-8 seconds to the
query and makes my CPU usage jump from 60% to 100% for the query.

I cannot pinpoint where that clause gets added either.  It seems to be
added at the start of any console search.  incident, problem, work
order or overview and is solely based on if that Unrestricted Access
is checked or not.

We have Multitenancy turned on and are on ARS 7.1 patch 3, ITSM 7.0.3

I'm wondering if it's similar to the OPs issue



On Jan 24, 10:00 am, "Mueller, Doug"  wrote:
> Viki,
>
> As Axton noted, although it looks BIG, ignore the C112 clauses in any WHERE 
> clause when looking at
> AR System logs.  This also includes any C60xxx fields.  All of these clauses 
> will be at the end of the query.
> They may be large (if you are in a lot of groups).  They do not affect the 
> overall performance of the system.
>
> So, you get down in this case to the very simply query Axton has indicated.  
> This is an UNQUALIFIED
> search of the given table (T28).
>
> First, do you have "disallow unqualified queries" server option set.  This 
> command would indicate you do not
> have this set.  It is recommended that you do to control this type of 
> unqualified query from accidentally
> happening.
>
> If you turn on SQL logging at the AR System level, it will tell you a lot of 
> information.
>
>    What login issued the command
>    When
>    From what type of client (the client type can tell you it came from the 
> mid-tier or a specific utility or if 0, it
>         generally means from a custom API program)
>
> If you turn on various types of logs, one might include the IP address too 
> and then you can see the user and
> the IP address and track back to the machine the command is coming from.
>
> All this can help track the problem.
>
> But, setting the option to disallow unqualified queries may go a long way 
> toward helping to either stop
> accidents or to cause someone to come and ask you why their unqualified 
> search stopped working
>
> Note you have a little bit of a clue about the user.  They are not an 
> Administrator and they are in all the
> groups that show up in the query below that field 112 is being searched for.
>
> I hope this helps,
>
> Doug Mueller
>
> 
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Axton
> Sent: Monday, January 24, 2011 6:45 AM
> To: arsl...@arslist.org
> Subject: Re: Ramdom Performance issue.
>
> ** What is table T28?
>
> select name
>   from arschema
>  where schemaid = 28
> /
>
> The C112 parts of the query have to do with the row level locking that is set 
> up on T28.
>
> Also, what method are you using to identify this as a cause or indicator of 
> your performance problem?
>
> Axton
>
> On Mon, Jan 24, 2011 at 3:13 AM, Viki_kulkarni 
> mailto:vk0073...@techmahindra.com>> wrote:
> hi all,
>
> since couple of weeks we are facing a strange issue.
> The AR Server just peaks at 100% and hangs. We see that there is a heavy
> query running on DB which looks like this
>
> SELECT
> T28.C1,C600011000,C536870984,C536870913,C900106001,C9

Re: Ramdom Performance issue.

[Siddiqi, Wirasat (Contractor)]

You can turn on SQL, Filter and Escalation log from server side and give the 
file same name. That way, you may be able to figure out what filter or 
escalation is generating this query.


Thanks,
Wirasat




From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Monday, January 24, 2011 10:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: Ramdom Performance issue.

**
Viki,

As Axton noted, although it looks BIG, ignore the C112 clauses in any WHERE 
clause when looking at
AR System logs.  This also includes any C60xxx fields.  All of these clauses 
will be at the end of the query.
They may be large (if you are in a lot of groups).  They do not affect the 
overall performance of the system.

So, you get down in this case to the very simply query Axton has indicated.  
This is an UNQUALIFIED
search of the given table (T28).

First, do you have "disallow unqualified queries" server option set.  This 
command would indicate you do not
have this set.  It is recommended that you do to control this type of 
unqualified query from accidentally
happening.

If you turn on SQL logging at the AR System level, it will tell you a lot of 
information.

   What login issued the command
   When
   From what type of client (the client type can tell you it came from the 
mid-tier or a specific utility or if 0, it
generally means from a custom API program)

If you turn on various types of logs, one might include the IP address too and 
then you can see the user and
the IP address and track back to the machine the command is coming from.

All this can help track the problem.

But, setting the option to disallow unqualified queries may go a long way 
toward helping to either stop
accidents or to cause someone to come and ask you why their unqualified search 
stopped working

Note you have a little bit of a clue about the user.  They are not an 
Administrator and they are in all the
groups that show up in the query below that field 112 is being searched for.

I hope this helps,

Doug Mueller


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, January 24, 2011 6:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: Ramdom Performance issue.

** What is table T28?

select name
  from arschema
 where schemaid = 28
/

The C112 parts of the query have to do with the row level locking that is set 
up on T28.

Also, what method are you using to identify this as a cause or indicator of 
your performance problem?

Axton

On Mon, Jan 24, 2011 at 3:13 AM, Viki_kulkarni 
mailto:vk0073...@techmahindra.com>> wrote:
hi all,

since couple of weeks we are facing a strange issue.
The AR Server just peaks at 100% and hangs. We see that there is a heavy
query running on DB which looks like this

SELECT
T28.C1,C600011000,C536870984,C536870913,C900106001,C901050057,C536871019,C900200400,C536870958,C536870950,C900170325,C536870935,C90013,C536870929,C536870931,C536870914,C536871018,C536870938,C65000,C536870952,C536871025,C536871038,C53690,C536870912,C7,C900040206,C901092014,C900110076,C536870987,C901170021,C536870957
FROM T28
WHERE (((T28.C112 LIKE :"SYS_B_00") OR ((T28.C112 LIKE :"SYS_B_01") OR
((T28.C112 LIKE :"SYS_B_02") OR ((T28.C112 LIKE :"SYS_B_03") OR ((T28.C112
LIKE :"SYS_B_04") OR ((T28.C112 LIKE :"SYS_B_05") OR ((T28.C112 LIKE
:"SYS_B_06") OR ((T28.C112 LIKE :"SYS_B_07") OR ((T28.C112 LIKE :"SYS_B_08")
OR ((T28.C112 LIKE :"SYS_B_09") OR ((T28.C112 LIKE :"SYS_B_10") OR
((T28.C112 LIKE :"SYS_B_11") OR ((T28.C112 LIKE :"SYS_B_12") OR ((T28.C112
LIKE :"SYS_B_13") OR ((T28.C112 LIKE :"SYS_B_14") OR ((T28.C112 LIKE
:"SYS_B_15") OR ((T28.C112 LIKE :"SYS_B_16") OR ((T28.C112 LIKE :"SYS_B_17")
OR ((T28.C112 LIKE :"SYS_B_18") OR ((T28.C112 LIKE :"SYS_B_19") OR
((T28.C112 LIKE :"SYS_B_20") OR ((T28.C112 LIKE :"SYS_B_21") OR ((T28.C112
LIKE :"SYS_B_22") OR ((T28.C112 LIKE :"SYS_B_23") OR ((T28.C112 LIKE
:"SYS_B_24") OR ((T28.C112 LIKE :"SYS_B_25") OR ((T28.C112 LIKE :"SYS_B_26")
OR ((T28.C112 LIKE :"SYS_B_27") OR ((T28.C112 LIKE :"SYS_B_28") OR
((T28.C112 LIKE :"SYS_B_29") OR ((T28.C112 LIKE :"SYS_B_30") OR ((T28.C112
LIKE :"SYS_B_31") OR ((T28.C112 LIKE :"SYS_B_32") OR ((T28.C112 LIKE
:"SYS_B_33") OR ((T28.C112 LIKE :"SYS_B_34") OR ((T28.C112 LIKE :"SYS_B_35")
OR ((T28.C112 LIKE :"SYS_B_36") OR ((T28.C112 LIKE :"SYS_B_37") OR
((T28.C112 LIKE :"SYS_B_38") OR ((T28.C112 LIKE :"SYS_B_39") OR ((T28.C112
LIKE :"SYS_B_40") OR ((T28.C112 LIKE 

Re: Ramdom Performance issue.

[Mueller, Doug]

Viki,

As Axton noted, although it looks BIG, ignore the C112 clauses in any WHERE 
clause when looking at
AR System logs.  This also includes any C60xxx fields.  All of these clauses 
will be at the end of the query.
They may be large (if you are in a lot of groups).  They do not affect the 
overall performance of the system.

So, you get down in this case to the very simply query Axton has indicated.  
This is an UNQUALIFIED
search of the given table (T28).

First, do you have "disallow unqualified queries" server option set.  This 
command would indicate you do not
have this set.  It is recommended that you do to control this type of 
unqualified query from accidentally
happening.

If you turn on SQL logging at the AR System level, it will tell you a lot of 
information.

   What login issued the command
   When
   From what type of client (the client type can tell you it came from the 
mid-tier or a specific utility or if 0, it
generally means from a custom API program)

If you turn on various types of logs, one might include the IP address too and 
then you can see the user and
the IP address and track back to the machine the command is coming from.

All this can help track the problem.

But, setting the option to disallow unqualified queries may go a long way 
toward helping to either stop
accidents or to cause someone to come and ask you why their unqualified search 
stopped working

Note you have a little bit of a clue about the user.  They are not an 
Administrator and they are in all the
groups that show up in the query below that field 112 is being searched for.

I hope this helps,

Doug Mueller


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, January 24, 2011 6:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: Ramdom Performance issue.

** What is table T28?

select name
  from arschema
 where schemaid = 28
/

The C112 parts of the query have to do with the row level locking that is set 
up on T28.

Also, what method are you using to identify this as a cause or indicator of 
your performance problem?

Axton

On Mon, Jan 24, 2011 at 3:13 AM, Viki_kulkarni 
mailto:vk0073...@techmahindra.com>> wrote:
hi all,

since couple of weeks we are facing a strange issue.
The AR Server just peaks at 100% and hangs. We see that there is a heavy
query running on DB which looks like this

SELECT
T28.C1,C600011000,C536870984,C536870913,C900106001,C901050057,C536871019,C900200400,C536870958,C536870950,C900170325,C536870935,C90013,C536870929,C536870931,C536870914,C536871018,C536870938,C65000,C536870952,C536871025,C536871038,C53690,C536870912,C7,C900040206,C901092014,C900110076,C536870987,C901170021,C536870957
FROM T28
WHERE (((T28.C112 LIKE :"SYS_B_00") OR ((T28.C112 LIKE :"SYS_B_01") OR
((T28.C112 LIKE :"SYS_B_02") OR ((T28.C112 LIKE :"SYS_B_03") OR ((T28.C112
LIKE :"SYS_B_04") OR ((T28.C112 LIKE :"SYS_B_05") OR ((T28.C112 LIKE
:"SYS_B_06") OR ((T28.C112 LIKE :"SYS_B_07") OR ((T28.C112 LIKE :"SYS_B_08")
OR ((T28.C112 LIKE :"SYS_B_09") OR ((T28.C112 LIKE :"SYS_B_10") OR
((T28.C112 LIKE :"SYS_B_11") OR ((T28.C112 LIKE :"SYS_B_12") OR ((T28.C112
LIKE :"SYS_B_13") OR ((T28.C112 LIKE :"SYS_B_14") OR ((T28.C112 LIKE
:"SYS_B_15") OR ((T28.C112 LIKE :"SYS_B_16") OR ((T28.C112 LIKE :"SYS_B_17")
OR ((T28.C112 LIKE :"SYS_B_18") OR ((T28.C112 LIKE :"SYS_B_19") OR
((T28.C112 LIKE :"SYS_B_20") OR ((T28.C112 LIKE :"SYS_B_21") OR ((T28.C112
LIKE :"SYS_B_22") OR ((T28.C112 LIKE :"SYS_B_23") OR ((T28.C112 LIKE
:"SYS_B_24") OR ((T28.C112 LIKE :"SYS_B_25") OR ((T28.C112 LIKE :"SYS_B_26")
OR ((T28.C112 LIKE :"SYS_B_27") OR ((T28.C112 LIKE :"SYS_B_28") OR
((T28.C112 LIKE :"SYS_B_29") OR ((T28.C112 LIKE :"SYS_B_30") OR ((T28.C112
LIKE :"SYS_B_31") OR ((T28.C112 LIKE :"SYS_B_32") OR ((T28.C112 LIKE
:"SYS_B_33") OR ((T28.C112 LIKE :"SYS_B_34") OR ((T28.C112 LIKE :"SYS_B_35")
OR ((T28.C112 LIKE :"SYS_B_36") OR ((T28.C112 LIKE :"SYS_B_37") OR
((T28.C112 LIKE :"SYS_B_38") OR ((T28.C112 LIKE :"SYS_B_39") OR ((T28.C112
LIKE :"SYS_B_40") OR ((T28.C112 LIKE :"SYS_B_41") OR ((T28.C112 LIKE
:"SYS_B_42") OR ((T28.C112 LIKE :"SYS_B_43") OR ((T28.C112 LIKE :"SYS_B_44")
OR ((T28.C112 LIKE :"SYS_B_45") OR ((T28.C112 LIKE :"SYS_B_46") OR
((T28.C112 LIKE :"SYS_B_47") OR ((T28.C112 LIKE :"SYS_B_48") OR ((T28.C112
LIKE :"SYS_B_49") OR ((T28.C112 LIKE :"SYS_B_50") OR ((T28.C112 LIKE
:"SYS_B_51") OR ((T28.C112 LIK

Re: Ramdom Performance issue.

[Axton]

What is table T28?

select name
  from arschema
 where schemaid = 28
/

The C112 parts of the query have to do with the row level locking that is
set up on T28.

Also, what method are you using to identify this as a cause or indicator of
your performance problem?

Axton

On Mon, Jan 24, 2011 at 3:13 AM, Viki_kulkarni
wrote:

> hi all,
>
> since couple of weeks we are facing a strange issue.
> The AR Server just peaks at 100% and hangs. We see that there is a heavy
> query running on DB which looks like this
>
> SELECT
>
> T28.C1,C600011000,C536870984,C536870913,C900106001,C901050057,C536871019,C900200400,C536870958,C536870950,C900170325,C536870935,C90013,C536870929,C536870931,C536870914,C536871018,C536870938,C65000,C536870952,C536871025,C536871038,C53690,C536870912,C7,C900040206,C901092014,C900110076,C536870987,C901170021,C536870957
> FROM T28
> WHERE (((T28.C112 LIKE :"SYS_B_00") OR ((T28.C112 LIKE :"SYS_B_01") OR
> ((T28.C112 LIKE :"SYS_B_02") OR ((T28.C112 LIKE :"SYS_B_03") OR ((T28.C112
> LIKE :"SYS_B_04") OR ((T28.C112 LIKE :"SYS_B_05") OR ((T28.C112 LIKE
> :"SYS_B_06") OR ((T28.C112 LIKE :"SYS_B_07") OR ((T28.C112 LIKE
> :"SYS_B_08")
> OR ((T28.C112 LIKE :"SYS_B_09") OR ((T28.C112 LIKE :"SYS_B_10") OR
> ((T28.C112 LIKE :"SYS_B_11") OR ((T28.C112 LIKE :"SYS_B_12") OR ((T28.C112
> LIKE :"SYS_B_13") OR ((T28.C112 LIKE :"SYS_B_14") OR ((T28.C112 LIKE
> :"SYS_B_15") OR ((T28.C112 LIKE :"SYS_B_16") OR ((T28.C112 LIKE
> :"SYS_B_17")
> OR ((T28.C112 LIKE :"SYS_B_18") OR ((T28.C112 LIKE :"SYS_B_19") OR
> ((T28.C112 LIKE :"SYS_B_20") OR ((T28.C112 LIKE :"SYS_B_21") OR ((T28.C112
> LIKE :"SYS_B_22") OR ((T28.C112 LIKE :"SYS_B_23") OR ((T28.C112 LIKE
> :"SYS_B_24") OR ((T28.C112 LIKE :"SYS_B_25") OR ((T28.C112 LIKE
> :"SYS_B_26")
> OR ((T28.C112 LIKE :"SYS_B_27") OR ((T28.C112 LIKE :"SYS_B_28") OR
> ((T28.C112 LIKE :"SYS_B_29") OR ((T28.C112 LIKE :"SYS_B_30") OR ((T28.C112
> LIKE :"SYS_B_31") OR ((T28.C112 LIKE :"SYS_B_32") OR ((T28.C112 LIKE
> :"SYS_B_33") OR ((T28.C112 LIKE :"SYS_B_34") OR ((T28.C112 LIKE
> :"SYS_B_35")
> OR ((T28.C112 LIKE :"SYS_B_36") OR ((T28.C112 LIKE :"SYS_B_37") OR
> ((T28.C112 LIKE :"SYS_B_38") OR ((T28.C112 LIKE :"SYS_B_39") OR ((T28.C112
> LIKE :"SYS_B_40") OR ((T28.C112 LIKE :"SYS_B_41") OR ((T28.C112 LIKE
> :"SYS_B_42") OR ((T28.C112 LIKE :"SYS_B_43") OR ((T28.C112 LIKE
> :"SYS_B_44")
> OR ((T28.C112 LIKE :"SYS_B_45") OR ((T28.C112 LIKE :"SYS_B_46") OR
> ((T28.C112 LIKE :"SYS_B_47") OR ((T28.C112 LIKE :"SYS_B_48") OR ((T28.C112
> LIKE :"SYS_B_49") OR ((T28.C112 LIKE :"SYS_B_50") OR ((T28.C112 LIKE
> :"SYS_B_51") OR ((T28.C112 LIKE :"SYS_B_52") OR ((T28.C112 LIKE
> :"SYS_B_53")
> OR ((T28.C112 LIKE :"SYS_B_54") OR ((T28.C112 LIKE :"SYS_B_55") OR
> ((T28.C112 LIKE :"SYS_B_56") OR ((T28.C112 LIKE :"SYS_B_57") OR ((T28.C112
> LIKE :"SYS_B_58") OR ((T28.C112 LIKE :"SYS_B_59") OR ((T28.C112 LIKE
> :"SYS_B_60") OR ((T28.C112 LIKE :"SYS_B_61") OR ((T28.C112 LIKE
> :"SYS_B_62")
> OR ((T28.C112 LIKE :"SYS_B_63") OR ((T28.C112 LIKE :"SYS_B_64") OR
> ((T28.C112 LIKE :"SYS_B_65") OR (T28.C112 LIKE
>
> :"SYS_B_66")))
> AND (T28.C536870993 LIKE :"SYS_B_67")) ORDER BY :"SYS_B_68" ASC
>
>
> but we don't know from where this query is getting fired out by which
> action. It happens at random and hence i am not able to keep my logging on
> for long time on my production setup.
>
> Can anyone help me decipher the query or guess why and how this query is
> coming into the picture while doing what action. I am sure it has to do
> something with the 112 field while pulling reports. Am I correct?
>
> Any help is appreciated as this is now creeping up as a major issue.
>
> Thanks,
> Viki
>
>
> --
> View this message in context:
> http://old.nabble.com/Ramdom-Performance-issue.-tp30746787p30746787.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"

Ramdom Performance issue.

[Viki_kulkarni]

hi all,

since couple of weeks we are facing a strange issue. 
The AR Server just peaks at 100% and hangs. We see that there is a heavy
query running on DB which looks like this 

SELECT
T28.C1,C600011000,C536870984,C536870913,C900106001,C901050057,C536871019,C900200400,C536870958,C536870950,C900170325,C536870935,C90013,C536870929,C536870931,C536870914,C536871018,C536870938,C65000,C536870952,C536871025,C536871038,C53690,C536870912,C7,C900040206,C901092014,C900110076,C536870987,C901170021,C536870957
FROM T28 
WHERE (((T28.C112 LIKE :"SYS_B_00") OR ((T28.C112 LIKE :"SYS_B_01") OR
((T28.C112 LIKE :"SYS_B_02") OR ((T28.C112 LIKE :"SYS_B_03") OR ((T28.C112
LIKE :"SYS_B_04") OR ((T28.C112 LIKE :"SYS_B_05") OR ((T28.C112 LIKE
:"SYS_B_06") OR ((T28.C112 LIKE :"SYS_B_07") OR ((T28.C112 LIKE :"SYS_B_08")
OR ((T28.C112 LIKE :"SYS_B_09") OR ((T28.C112 LIKE :"SYS_B_10") OR
((T28.C112 LIKE :"SYS_B_11") OR ((T28.C112 LIKE :"SYS_B_12") OR ((T28.C112
LIKE :"SYS_B_13") OR ((T28.C112 LIKE :"SYS_B_14") OR ((T28.C112 LIKE
:"SYS_B_15") OR ((T28.C112 LIKE :"SYS_B_16") OR ((T28.C112 LIKE :"SYS_B_17")
OR ((T28.C112 LIKE :"SYS_B_18") OR ((T28.C112 LIKE :"SYS_B_19") OR
((T28.C112 LIKE :"SYS_B_20") OR ((T28.C112 LIKE :"SYS_B_21") OR ((T28.C112
LIKE :"SYS_B_22") OR ((T28.C112 LIKE :"SYS_B_23") OR ((T28.C112 LIKE
:"SYS_B_24") OR ((T28.C112 LIKE :"SYS_B_25") OR ((T28.C112 LIKE :"SYS_B_26")
OR ((T28.C112 LIKE :"SYS_B_27") OR ((T28.C112 LIKE :"SYS_B_28") OR
((T28.C112 LIKE :"SYS_B_29") OR ((T28.C112 LIKE :"SYS_B_30") OR ((T28.C112
LIKE :"SYS_B_31") OR ((T28.C112 LIKE :"SYS_B_32") OR ((T28.C112 LIKE
:"SYS_B_33") OR ((T28.C112 LIKE :"SYS_B_34") OR ((T28.C112 LIKE :"SYS_B_35")
OR ((T28.C112 LIKE :"SYS_B_36") OR ((T28.C112 LIKE :"SYS_B_37") OR
((T28.C112 LIKE :"SYS_B_38") OR ((T28.C112 LIKE :"SYS_B_39") OR ((T28.C112
LIKE :"SYS_B_40") OR ((T28.C112 LIKE :"SYS_B_41") OR ((T28.C112 LIKE
:"SYS_B_42") OR ((T28.C112 LIKE :"SYS_B_43") OR ((T28.C112 LIKE :"SYS_B_44")
OR ((T28.C112 LIKE :"SYS_B_45") OR ((T28.C112 LIKE :"SYS_B_46") OR
((T28.C112 LIKE :"SYS_B_47") OR ((T28.C112 LIKE :"SYS_B_48") OR ((T28.C112
LIKE :"SYS_B_49") OR ((T28.C112 LIKE :"SYS_B_50") OR ((T28.C112 LIKE
:"SYS_B_51") OR ((T28.C112 LIKE :"SYS_B_52") OR ((T28.C112 LIKE :"SYS_B_53")
OR ((T28.C112 LIKE :"SYS_B_54") OR ((T28.C112 LIKE :"SYS_B_55") OR
((T28.C112 LIKE :"SYS_B_56") OR ((T28.C112 LIKE :"SYS_B_57") OR ((T28.C112
LIKE :"SYS_B_58") OR ((T28.C112 LIKE :"SYS_B_59") OR ((T28.C112 LIKE
:"SYS_B_60") OR ((T28.C112 LIKE :"SYS_B_61") OR ((T28.C112 LIKE :"SYS_B_62")
OR ((T28.C112 LIKE :"SYS_B_63") OR ((T28.C112 LIKE :"SYS_B_64") OR
((T28.C112 LIKE :"SYS_B_65") OR (T28.C112 LIKE
:"SYS_B_66")))))))
AND (T28.C536870993 LIKE :"SYS_B_67")) ORDER BY :"SYS_B_68" ASC


but we don't know from where this query is getting fired out by which
action. It happens at random and hence i am not able to keep my logging on
for long time on my production setup.

Can anyone help me decipher the query or guess why and how this query is
coming into the picture while doing what action. I am sure it has to do
something with the 112 field while pulling reports. Am I correct?

Any help is appreciated as this is now creeping up as a major issue.

Thanks,
Viki 


-- 
View this message in context: 
http://old.nabble.com/Ramdom-Performance-issue.-tp30746787p30746787.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"

Re: Email Engine 6.3 Performance issue

[Brittain, Mark]

Hi Ron,

I am on 6.3 patch 24 and had a similar problem about 2 years ago. I added a 
second mailbox and roughly load balanced by sending external mail (customer 
updates) though one box and internal mail (ticket assignments) out the other. 
As suggested below I delete after send.

Check your polling interval which by default is 2 minutes as well as the number 
of emails, default 100, sent per polling. I have not changed the number per 
polling but dropped the polling to 1 minute. Have not had a problem with 
outgoing mail since.

Mark


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Thursday, March 18, 2010 3:26 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email Engine 6.3 Performance issue

The first thing to check is how many emails do you have in your "AR System 
Email Messages" form.  Purge all that you can

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Suwanski, Ron
Sent: Thursday, March 18, 2010 12:10 PM
To: arslist@ARSLIST.ORG
Subject: Email Engine 6.3 Performance issue

**
We are experiencing about an hour and a half delay in the sending of emails 
from Remedy in version 6.3.  Any idea how I can improve the performance?? I 
have seen items for 7.0 but I am on 6.3.

Ron Suwanski
Remedy Administrator / Developer

DeVry Inc.
814 Commerce Drive
Oakbrook, IL 60523-8822

p: 630.472.2209
e: rsuwan...@devry.com<mailto:rsuwan...@devry.com>

www.devry.edu<http://www.devry.com/>

[cid:image001.jpg@01CAC6B0.A0CD6700]


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

This e-mail is the property of NaviSite, Inc. It is intended only for the 
person or entity to which it is addressed and may contain information that is 
privileged, confidential, or otherwise protected from disclosure. Distribution 
or copying of this e-mail, or the information contained herein, to anyone other 
than the intended recipient is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
<>

Re: Email Engine 6.3 Performance issue

[Grooms, Frederick W]

The first thing to check is how many emails do you have in your "AR System 
Email Messages" form.  Purge all that you can

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Suwanski, Ron
Sent: Thursday, March 18, 2010 12:10 PM
To: arslist@ARSLIST.ORG
Subject: Email Engine 6.3 Performance issue

**
We are experiencing about an hour and a half delay in the sending of emails 
from Remedy in version 6.3.  Any idea how I can improve the performance?? I 
have seen items for 7.0 but I am on 6.3.

Ron Suwanski
Remedy Administrator / Developer

DeVry Inc.
814 Commerce Drive
Oakbrook, IL 60523-8822

p: 630.472.2209
e: rsuwan...@devry.com<mailto:rsuwan...@devry.com>

www.devry.edu<http://www.devry.com/>

[cid:image001.jpg@01CAC6A7.029DBB10]



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
<>

Email Engine 6.3 Performance issue

[Suwanski, Ron]

We are experiencing about an hour and a half delay in the sending of
emails from Remedy in version 6.3.  Any idea how I can improve the
performance?? I have seen items for 7.0 but I am on 6.3.

 

Ron Suwanski

Remedy Administrator / Developer

 

DeVry Inc.

814 Commerce Drive

Oakbrook, IL 60523-8822

 

p: 630.472.2209

e: rsuwan...@devry.com  

 

www.devry.edu  

 

 

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
<>

Re: Performance Issue - Urgent

[Joe D'Souza]

To add to what Hugo and others suggested, when you report performance
issues. it would also be nice to add where you are really seeing drop in the
performance. Is it generally doing anything that you are experiencing
problems with (which in case it could be you run short of hardware
resources) or is it in a specific area of the application (where you may
require to tune the apps using tips that Hugo pointed out)

Without that its hard to really tell - its like phoning your doctor and
saying hey I have a problem and I think I'm not well and not really telling
him what you are experiencing and yet expect the doctor to fix you with some
magic portion..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Hyunkel v2.0
  Sent: Thursday, January 14, 2010 12:21 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Performance Issue - Urgent


  ** The minimal requirements of RAM are 2GB+ for ARS 7.1 and ITSM 7.3.

  On the other hand you must check a couple of things first:

  * Are you using indexes on the forms other than the predefined ones?
  * If you monitor your DB, are you seeing locked tables or an unusual size
increase on one table (specially B'X' or H'X')
  * Do you have escalations modifying a large ammount of data on short
intervals?
  * Do you manage the DB in other way than the one that uses ARS?
  * Are you seeing API Calls fails on the API log?
  * Do you perform a specific task when you notice the bad performance?
  * Which kind of client are you using (Fat OR Web), and the clients behave
the same?
  * What are you seeing in performance manager regarding arserverd process?

  Best Regards.


  Hugo Ruesga
  perotsystems®
  US  972.577.7000
  MX +52 (33) 3332.3868

  P Please consider the environment before printing this email

  The information contained in and transferred with this electronic message
is intended only for the recipient(s) designated above, it is protected by
law and it may contain information which is privileged and confidential. If
you are not the intended recipient, please do not read, copy, or use it, and
do not disclose it to others. Please notify the sender of the delivery error
by replying to this message, and then delete it from your system. Thank you.











--
  Date: Thu, 14 Jan 2010 18:57:16 +0200
  From: ramyay...@gmail.com
  Subject: Performance Issue - Urgent
  To: arslist@ARSLIST.ORG

  **
  ***
  List ,

  I m wondering how I can point figure why remedy application is slow , is
it memory ,CPU or What

  which the value for CPU and Memory reasonable rather than good the
question now why Remedy it goes to paging rather than using the free
available memory and how could tune this.

  ARS Version: 7.1
  ITSM: 7,3
  OS : Windows 2003 (VMWARE)
  DATABASE: SQL 2005

  Regards,
  Ramy

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance Issue - Urgent

[Hyunkel v2.0]

The minimal requirements of RAM are 2GB+ for ARS 7.1 and ITSM 7.3.

On the other hand you must check a couple of things first:

* Are you using indexes on the forms other than the predefined ones?
* If you monitor your DB, are you seeing locked tables or an unusual size 
increase on one table (specially B'X' or H'X')
* Do you have escalations modifying a large ammount of data on short intervals?
* Do you manage the DB in other way than the one that uses ARS?
* Are you seeing API Calls fails on the API log?
* Do you perform a specific task when you notice the bad performance?
* Which kind of client are you using (Fat OR Web), and the clients behave the 
same?
* What are you seeing in performance manager regarding arserverd process?

Best Regards.


Hugo Ruesga 
perotsystems® 
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email

The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.






Date: Thu, 14 Jan 2010 18:57:16 +0200
From: ramyay...@gmail.com
Subject: Performance Issue - Urgent
To: arslist@ARSLIST.ORG

**
***
List , 
 
I m wondering how I can point figure why remedy application is slow , is it 
memory ,CPU or What 
 
which the value for CPU and Memory reasonable rather than good the question now 
why Remedy it goes to paging rather than using the free available memory and 
how could tune this.
 
ARS Version: 7.1 
ITSM: 7,3
OS : Windows 2003 (VMWARE)
DATABASE: SQL 2005
 
Regards,
Ramy
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_   
  
_
Una nueva experiencia de búsqueda está aquí
http://www.bing.com/?mkt=es-MX&FORM=M006IR&Publ=WLHMTAG&Crea=TEXT_M006IR_Bing_ES_SaveTimeClicks_1X1
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance Issue - Urgent

[Martinez, Marcelo A]

I'm running almost the same setup (my Prod is a blade; my Dev is virtual):

I would say you need 4 CPUs and 4GB RAM to run smooth. Also, make sure Dev 
Cache mode is not on.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Ramy S. Ayoub
Sent: Thursday, January 14, 2010 10:57 AM
To: arslist@ARSLIST.ORG
Subject: Performance Issue - Urgent

**
***
List ,

I m wondering how I can point figure why remedy application is slow , is it 
memory ,CPU or What

which the value for CPU and Memory reasonable rather than good the question now 
why Remedy it goes to paging rather than using the free available memory and 
how could tune this.

ARS Version: 7.1
ITSM: 7,3
OS : Windows 2003 (VMWARE)
DATABASE: SQL 2005

Regards,
Ramy
_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"

Performance Issue - Urgent

[Ramy S. Ayoub]

***
List ,

I m wondering how I can point figure why remedy application is slow , is it
memory ,CPU or What

which the value for CPU and Memory reasonable rather than good the question
now why Remedy it goes to paging rather than using the free available memory
and how could tune this.

ARS Version: 7.1
ITSM: 7,3
OS : Windows 2003 (VMWARE)
DATABASE: SQL 2005

Regards,
Ramy

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance issue as ARServed takes 100% CPU utilization

[patrick zandi]

I have seen an older version of Email engine do this? in the configuration
it was set to 1,
1 should be minutes, but I remember there were versions that this was
Seconds instead..
And so then I was seeing polling to the SMTP server several times a second,
causing CPU spike.

Turning on admin panel, turning on server events can cause CPU hit's that
would bring it up, Especially if the server cannot handle in the first place
(slow server - old)...

Hope those help.. have a great day.
On Fri, Jul 17, 2009 at 11:01 AM, Axton  wrote:

> ** The cpu utilization tells you the process is busy doing something, the
> real questions is, "What is the process doing?"  Turn on your api logs and
> check it out.  There are some operations that block, which would explain it
> being bound to a single cpu.  What is the cache mode of the server?
>
> Axton Grams
>
>  On Fri, Jul 17, 2009 at 8:05 AM, Manish SINGLA wrote:
>
>> Hello List,
>>
>> We have been observing that, when ARServed process reaches to 100% CPU
>> utilization, system performance get degraded drastically.
>> Even if system still has another CPU available means in total it's 50%
>> utilized. This results into when user even couldn't login.
>>
>> Please advice how I can unblock the situation.
>>
>> Regards
>> Manish
>>
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> Platinum 
>> Sponsor:rmisoluti...@verizon.netARSlist: 
>> "Where the Answers Are"
>>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_




-- 
Patrick Zandi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance issue as ARServed takes 100% CPU utilization

[Axton]

The cpu utilization tells you the process is busy doing something, the real
questions is, "What is the process doing?"  Turn on your api logs and check
it out.  There are some operations that block, which would explain it being
bound to a single cpu.  What is the cache mode of the server?

Axton Grams

On Fri, Jul 17, 2009 at 8:05 AM, Manish SINGLA  wrote:

> Hello List,
>
> We have been observing that, when ARServed process reaches to 100% CPU
> utilization, system performance get degraded drastically.
> Even if system still has another CPU available means in total it's 50%
> utilized. This results into when user even couldn't login.
>
> Please advice how I can unblock the situation.
>
> Regards
> Manish
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum 
> Sponsor:rmisoluti...@verizon.netARSlist: 
> "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance issue as ARServed takes 100% CPU utilization

[Darrell Reading]

So this is a one proc box?
How much memory?
How many users access the system, total, and contiguous?
What OS?  32 or 64 bit?
What DB?
What version of Remedy?
What did the compatibility matrix say?
 


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:arsl...@arslist.org] On Behalf Of Manish SINGLA
Sent: Friday, July 17, 2009 08:05
To: arslist@ARSLIST.ORG
Subject: Performance issue as ARServed takes 100% CPU utilization
Importance: High

Hello List,

We have been observing that, when ARServed process reaches to 100% CPU
utilization, system performance get degraded drastically.
Even if system still has another CPU available means in total it's 50%
utilized. This results into when user even couldn't login.

Please advice how I can unblock the situation.

Regards
Manish


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net 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.
**
Wal-Mart Confidential
**


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance issue as ARServed takes 100% CPU utilization

[patrick zandi]

you may want to post your ar.conf as well.. remove the password strings for
us, even if hashed.

On Fri, Jul 17, 2009 at 9:05 AM, Manish SINGLA  wrote:

> Hello List,
>
> We have been observing that, when ARServed process reaches to 100% CPU
> utilization, system performance get degraded drastically.
> Even if system still has another CPU available means in total it's 50%
> utilized. This results into when user even couldn't login.
>
> Please advice how I can unblock the situation.
>
> Regards
> Manish
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum 
> Sponsor:rmisoluti...@verizon.netARSlist: 
> "Where the Answers Are"
>



-- 
Patrick Zandi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance issue as ARServed takes 100% CPU utilization

[Kaiser, Norm E CIV USAF AFMC 96 CS/SCOKT]

Look for code that is running away or overly ambitious:

- Active links that run on an interval that do massive queries
- Escalations that do massive updates running during prime time
- Code that trips a filter that trips a filter that trips a filter that
does massive updates

Check your logs to see what's going on during those peak CPU utilization
times.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Manish SINGLA
Sent: Friday, July 17, 2009 8:05 AM
To: arslist@ARSLIST.ORG
Subject: Performance issue as ARServed takes 100% CPU utilization
Importance: High

Hello List,

We have been observing that, when ARServed process reaches to 100% CPU
utilization, system performance get degraded drastically.
Even if system still has another CPU available means in total it's 50%
utilized. This results into when user even couldn't login.

Please advice how I can unblock the situation.

Regards
Manish


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
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"

Performance issue as ARServed takes 100% CPU utilization

[Manish SINGLA]

Hello List,

We have been observing that, when ARServed process reaches to 100% CPU
utilization, system performance get degraded drastically.
Even if system still has another CPU available means in total it's 50%
utilized. This results into when user even couldn't login.

Please advice how I can unblock the situation.

Regards
Manish

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance Issue Please Give Me Any Suggesstion

[Ken Pritchard]

Hi Manoj,

 

   The API / SQL logs on each server might be good - I'd also kick off the
user logs.  There could be a number of items, but here's a couple to check
for (I didn't see what OS you are using, so I'm trying to keep this
generic):

 

  Is the load balancer set up to distribute the users  evenly or are they
using a different algorithm?

 

   Are all users going through the load balancer or are some going directly
to this server?  

 

   Look at which server things like escalations, email engine,  etc. are
active on.  There are some forms associated with server grouping that drive
which server these things are on.

 

The server groupings use a process called ARSignal.  See if there are a
backup of these processes on the server that is running slow.  The servers
in the server group talk to each other through the ARSignal process.
Normally this process starts and stops very quickly, but if there is an
issue with the ARS servers talking to each other, these processes can hang
around (I've seen this on HPUX).

 

   I also don't know whether your database is on a separate server or on
this server.   If the DB is on this server, it will definitely have an
impact.

 

Hope these things help - ken

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of manoj jain
Sent: Thursday, July 16, 2009 3:44 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance Issue Please Give Me Any Suggesstion

 

** 

Hi Lina & Ken,

 

Yes you were right that load balancer is infornt of system so what we can do
for reducing performance issue?But Performance issue occuring only in one
server which is not primary server.

 

Thanks & Regards,

Manoj jain

On Thu, Jul 16, 2009 at 12:52 PM, Lina Hartojo 
wrote:

** Hi Manoj

I assume the load balancer is the traffic controller for user access to the
servers within this server group, which means that the load balancer is
*always* in front of the system.  Ken, is that the case or is there any
other situation where this is not the case?  Apologies for my novice
knowledge, please explain if you can.

Kind regards - Lina

On Thu, Jul 16, 2009 at 4:56 PM, manoj jain 
wrote:

** 

Hi Ken,

 

1.No that server in which performance issue going on is not our primary
server.

so email and escalation is not part of that server.

2.We have a load balancer but i didn't get what is meaning of this sentence
"load balancer infornt of server".

 

Thanks & Regards,

Manoj Jain

On Wed, Jul 15, 2009 at 11:00 PM, Ken Pritchard  wrote:

** 

Manoj,

 

   Probably need to provide some additional information, such as:

 

   Is this your primary server (does it run escalations, email, etc..)?  

 

   Do you have a load balancer in front of the system?

 

  I found it helpful to lower the amount of user traffic that goes to the
primary server where your non-user items (such as escalations) are primarily
set to run.

 

Thank you - ken

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of manoj jain
Sent: Wednesday, July 15, 2009 12:21 PM
To: arslist@ARSLIST.ORG
Subject: Performance Issue Please Give Me Any Suggesstion

 

** 

Hi Remedians,

 

I have one issue 

 

1.i have one server group on linux box there are three servers  in that
group.

2.Two servers running very good   without any performance issue.

3.One server running very  bad with high  performance  issue.

4.CPU utilization  in that server is 150%,Idel time 2%.

5.So please give me  any suggesstion  so that i could  resolve  this
performance  issue. 

6. How can i reduce cpu utilization and increase idel time.

 

Thanks & Regards,

Manoj Jain

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 


_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"

AW: Performance Issue Please Give Me Any Suggesstion

[Conny Martin]

Manoj,
 
turn on API-Logging on all 3 servers. So you can check (and compare) how
many API-calls reaching each of the servers. Perhaps this gives you some
information why server1 is performing so bad.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von manoj jain
Gesendet: Donnerstag, 16. Juli 2009 09:44
An: arslist@ARSLIST.ORG
Betreff: Re: Performance Issue Please Give Me Any Suggesstion


** 
Hi Lina & Ken,
 
Yes you were right that load balancer is infornt of system so what we
can do for reducing performance issue?But Performance issue occuring
only in one server which is not primary server.
 
Thanks & Regards,
Manoj jain


On Thu, Jul 16, 2009 at 12:52 PM, Lina Hartojo 
wrote:


** Hi Manoj

I assume the load balancer is the traffic controller for user
access to the servers within this server group, which means that the
load balancer is *always* in front of the system.  Ken, is that the case
or is there any other situation where this is not the case?  Apologies
for my novice knowledge, please explain if you can.

Kind regards - Lina


On Thu, Jul 16, 2009 at 4:56 PM, manoj jain
 wrote:


** 
Hi Ken,
 
1.No that server in which performance issue going on is
not our primary server.
so email and escalation is not part of that server.
2.We have a load balancer but i didn't get what is
meaning of this sentence "load balancer infornt of server".
 
Thanks & Regards,
Manoj Jain


On Wed, Jul 15, 2009 at 11:00 PM, Ken Pritchard
 wrote:


** 

Manoj,

 

   Probably need to provide some additional
information, such as:

 

   Is this your primary server (does it run
escalations, email, etc..)?  

 

   Do you have a load balancer in front of the
system?

 

  I found it helpful to lower the amount of user
traffic that goes to the primary server where your non-user items (such
as escalations) are primarily set to run.

 

Thank you - ken

 

From: Action Request System discussion
list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of manoj jain
Sent: Wednesday, July 15, 2009 12:21 PM
To: arslist@ARSLIST.ORG
        Subject: Performance Issue Please Give Me Any
Suggesstion

 

** 

Hi Remedians,

 

I have one issue 

 

1.i have one server group on linux box there are
three servers  in that group.

2.Two servers running very good   without any
performance issue.

3.One server running very  bad with high
performance  issue.

4.CPU utilization  in that server is 150%,Idel
time 2%.

5.So please give me  any suggesstion  so that i
could  resolve  this  performance  issue. 

6. How can i reduce cpu utilization and increase
idel time.

 

Thanks & Regards,

Manoj Jain

_Platinum Sponsor: rmisoluti...@verizon.net
ARSlist: "Where the Answers Are"_ 

_Platinum Sponsor: rmisoluti...@verizon.net
ARSlist: "Where the Answers Are"_ 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist:
"Where the Answers Are"_ 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the
Answers Are"_ 


_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"

Re: Performance Issue Please Give Me Any Suggesstion

[manoj jain]

Hi Lina & Ken,

Yes you were right that load balancer is infornt of system so what we can do
for reducing performance issue?But Performance issue occuring only in one
server which is not primary server.

Thanks & Regards,
Manoj jain

On Thu, Jul 16, 2009 at 12:52 PM, Lina Hartojo wrote:

> ** Hi Manoj
>
> I assume the load balancer is the traffic controller for user access to the
> servers within this server group, which means that the load balancer is
> *always* in front of the system.  Ken, is that the case or is there any
> other situation where this is not the case?  Apologies for my novice
> knowledge, please explain if you can.
>
> Kind regards - Lina
>
> On Thu, Jul 16, 2009 at 4:56 PM, manoj jain wrote:
>
>> **
>>  Hi Ken,
>>
>> 1.No that server in which performance issue going on is not our primary
>> server.
>> so email and escalation is not part of that server.
>> 2.We have a load balancer but i didn't get what is meaning of this
>> sentence "load balancer infornt of server".
>>
>> Thanks & Regards,
>> Manoj Jain
>>
>>   On Wed, Jul 15, 2009 at 11:00 PM, Ken Pritchard  wrote:
>>
>>> **
>>>
>>> Manoj,
>>>
>>>
>>>
>>>Probably need to provide some additional information, such as:
>>>
>>>
>>>
>>>Is this your primary server (does it run escalations, email, etc..)?
>>>
>>>
>>>
>>>Do you have a load balancer in front of the system?
>>>
>>>
>>>
>>>   I found it helpful to lower the amount of user traffic that goes to the
>>> primary server where your non-user items (such as escalations) are primarily
>>> set to run.
>>>
>>>
>>>
>>> Thank you - ken
>>>
>>>
>>>
>>> *From:* Action Request System discussion list(ARSList) [mailto:
>>> arsl...@arslist.org] *On Behalf Of *manoj jain
>>> *Sent:* Wednesday, July 15, 2009 12:21 PM
>>> *To:* arslist@ARSLIST.ORG
>>> *Subject:* Performance Issue Please Give Me Any Suggesstion
>>>
>>>
>>>
>>> **
>>>
>>> Hi Remedians,
>>>
>>>
>>>
>>> I have one issue
>>>
>>>
>>>
>>> 1.i have one server group on linux box there are three servers  in that
>>> group.
>>>
>>> 2.Two servers running very good   without any performance issue.
>>>
>>> 3.One server running very  bad with high  performance  issue.
>>>
>>> 4.CPU utilization  in that server is 150%,Idel time 2%.
>>>
>>> 5.So please give me  any suggesstion  so that i could  resolve  this
>>> performance  issue.
>>>
>>> 6. How can i reduce cpu utilization and increase idel time.
>>>
>>>
>>>
>>> Thanks & Regards,
>>>
>>> Manoj Jain
>>>
>>> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
>>> Are"_
>>> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
>>> Are"_
>>
>>
>> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
>> Are"_
>>
>
> _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"

Re: Performance Issue Please Give Me Any Suggesstion

[Joe DeSouza]

Load balancer in front of the server is just another way of saying that the 
user clients will connect to the load balancer IP or hostname and not the 
individual AR Server IP or hostname..

Joe




From: manoj jain 
To: arslist@ARSLIST.ORG
Sent: Thursday, July 16, 2009 2:56:23 AM
Subject: Re: Performance Issue Please Give Me Any Suggesstion

** 
Hi Ken,

1.No that server in which performance issue going on is not our primary server.
so email and escalation is not part of that server.
2.We have a load balancer but i didn't get what is meaning of this sentence 
"load balancer infornt of server".

Thanks & Regards,
Manoj Jain


On Wed, Jul 15, 2009 at 11:00 PM, Ken Pritchard  wrote:

** 
>Manoj,
> 
>   Probably need to provide some additional information, such as:
> 
>   Is this your primary server (does it run escalations, email, etc..)?  
> 
>   Do you have a load balancer in front of the system?
> 
>  I found it helpful to lower the amount of user traffic that goes to the 
>primary server where your non-user items (such as escalations) are primarily 
>set to run.
> 
>Thank you - ken
> 
>From:Action Request System discussion list(ARSList) 
>[mailto:arsl...@arslist.org] On Behalf Of manoj jain
>Sent: Wednesday, July 15, 2009 12:21 PM
>To: arslist@ARSLIST.ORG
>Subject: Performance Issue Please Give Me Any Suggesstion
> 
>** 
>Hi Remedians,
> 
>I have one issue 
> 
>1.i have one server group on linux box there are three servers  in that group.
>2.Two servers running very good   without any performance issue.
>3.One server running very  bad with high  performance  issue.
>4.CPU utilization  in that server is 150%,Idel time 2%.
>5.So please give me  any suggesstion  so that i could  resolve  this  
>performance  issue. 
>6. How can i reduce cpu utilization and increase idel time.
> 
>Thanks & Regards,
>Manoj Jain



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
  

Re: Performance Issue Please Give Me Any Suggesstion

[Lina Hartojo]

Hi Manoj

I assume the load balancer is the traffic controller for user access to the
servers within this server group, which means that the load balancer is
*always* in front of the system.  Ken, is that the case or is there any
other situation where this is not the case?  Apologies for my novice
knowledge, please explain if you can.

Kind regards - Lina

On Thu, Jul 16, 2009 at 4:56 PM, manoj jain wrote:

> ** Hi Ken,
>
> 1.No that server in which performance issue going on is not our primary
> server.
> so email and escalation is not part of that server.
> 2.We have a load balancer but i didn't get what is meaning of this sentence
> "load balancer infornt of server".
>
> Thanks & Regards,
> Manoj Jain
>
> On Wed, Jul 15, 2009 at 11:00 PM, Ken Pritchard  wrote:
>
>> **
>>
>> Manoj,
>>
>>
>>
>>Probably need to provide some additional information, such as:
>>
>>
>>
>>Is this your primary server (does it run escalations, email, etc..)?
>>
>>
>>
>>Do you have a load balancer in front of the system?
>>
>>
>>
>>   I found it helpful to lower the amount of user traffic that goes to the
>> primary server where your non-user items (such as escalations) are primarily
>> set to run.
>>
>>
>>
>> Thank you - ken
>>
>>
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arsl...@arslist.org] *On Behalf Of *manoj jain
>> *Sent:* Wednesday, July 15, 2009 12:21 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* Performance Issue Please Give Me Any Suggesstion
>>
>>
>>
>> **
>>
>> Hi Remedians,
>>
>>
>>
>> I have one issue
>>
>>
>>
>> 1.i have one server group on linux box there are three servers  in that
>> group.
>>
>> 2.Two servers running very good   without any performance issue.
>>
>> 3.One server running very  bad with high  performance  issue.
>>
>> 4.CPU utilization  in that server is 150%,Idel time 2%.
>>
>> 5.So please give me  any suggesstion  so that i could  resolve  this
>> performance  issue.
>>
>> 6. How can i reduce cpu utilization and increase idel time.
>>
>>
>>
>> Thanks & Regards,
>>
>> Manoj Jain
>>
>> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
>> Are"_
>> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
>> Are"_
>
>
> _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"

Re: Performance Issue Please Give Me Any Suggesstion

[manoj jain]

Hi Ken,

1.No that server in which performance issue going on is not our primary
server.
so email and escalation is not part of that server.
2.We have a load balancer but i didn't get what is meaning of this sentence
"load balancer infornt of server".

Thanks & Regards,
Manoj Jain

On Wed, Jul 15, 2009 at 11:00 PM, Ken Pritchard  wrote:

> **
>
> Manoj,
>
>
>
>Probably need to provide some additional information, such as:
>
>
>
>Is this your primary server (does it run escalations, email, etc..)?
>
>
>
>Do you have a load balancer in front of the system?
>
>
>
>   I found it helpful to lower the amount of user traffic that goes to the
> primary server where your non-user items (such as escalations) are primarily
> set to run.
>
>
>
> Thank you - ken
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *manoj jain
> *Sent:* Wednesday, July 15, 2009 12:21 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Performance Issue Please Give Me Any Suggesstion
>
>
>
> **
>
> Hi Remedians,
>
>
>
> I have one issue
>
>
>
> 1.i have one server group on linux box there are three servers  in that
> group.
>
> 2.Two servers running very good   without any performance issue.
>
> 3.One server running very  bad with high  performance  issue.
>
> 4.CPU utilization  in that server is 150%,Idel time 2%.
>
> 5.So please give me  any suggesstion  so that i could  resolve  this
> performance  issue.
>
> 6. How can i reduce cpu utilization and increase idel time.
>
>
>
> Thanks & Regards,
>
> Manoj Jain
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
> _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"

Re: Performance Issue Please Give Me Any Suggesstion

[Ken Pritchard]

Manoj,

 

   Probably need to provide some additional information, such as:

 

   Is this your primary server (does it run escalations, email, etc..)?  

 

   Do you have a load balancer in front of the system?

 

  I found it helpful to lower the amount of user traffic that goes to the
primary server where your non-user items (such as escalations) are primarily
set to run.

 

Thank you - ken

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of manoj jain
Sent: Wednesday, July 15, 2009 12:21 PM
To: arslist@ARSLIST.ORG
Subject: Performance Issue Please Give Me Any Suggesstion

 

** 

Hi Remedians,

 

I have one issue 

 

1.i have one server group on linux box there are three servers  in that
group.

2.Two servers running very good   without any performance issue.

3.One server running very  bad with high  performance  issue.

4.CPU utilization  in that server is 150%,Idel time 2%.

5.So please give me  any suggesstion  so that i could  resolve  this
performance  issue. 

6. How can i reduce cpu utilization and increase idel time.

 

Thanks & Regards,

Manoj Jain

_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"

Performance Issue Please Give Me Any Suggesstion

[manoj jain]

Hi Remedians,

I have one issue

1.i have one server group on linux box there are three servers  in that
group.
2.Two servers running very good   without any performance issue.
3.One server running very  bad with high  performance  issue.
4.CPU utilization  in that server is 150%,Idel time 2%.
5.So please give me  any suggesstion  so that i could  resolve  this
performance  issue.
6. How can i reduce cpu utilization and increase idel time.

Thanks & Regards,
Manoj Jain

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance Issue of Admin Tool 7.1 since installing BMC Atrium and Asset Management.

[Munukutla,Ravishankar]

This issue has been addressed in 7.1 Admin Tool Patch 007.

7.X Admin Tool performance is slow when user does the following activities 
under "View by Details Mode". (View-->Details)
a) Load Active Link
b) Save as active Link
c) Delete Active Link.

Things addressed in the latest patch of Admin Tool


Regards,
Ravishankar

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Thursday, May 14, 2009 5:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance Issue of Admin Tool 7.1 since installing BMC Atrium 
and Asset Management.

** The gory details are available here if you are interested in what is going 
on:

http://bugs.arswiki.org/show_bug.cgi?id=58

Axton Grams
On Wed, May 13, 2009 at 4:59 AM, Jarl Grøneng 
mailto:jarl.gron...@gmail.com>> wrote:
It is a known issue. Its beacuse how admin tool queries the database,
and as you said, the amount of workflow objects.

One workaround is to disable the detailed information in the admin
tool (list tables), another one is to add the forms and workflow you
working on in an application. Then it does not refresh the information
that often.

BMC solution is to use Developerstudio 7.5, and upgrade your server to 7.5.

--
Jarl

2009/5/13 Jay Sytangco 
mailto:syta...@airproducts.com>>:
> Hello,
>
> Right after installing the Atrium and Asset Management applications
> we've noticed a considerable reduction in performance when making
> changes via the Admin Tool.  It is especially evident when adding or
> changing workflow objects, moreso than a form change.  Making changes
> via a definition file import is also slower but not as bad as saving
> single Active Link or Filter changes.
>
> Installing the two applications obviously added a lot of new form and
> workflow objects.  Is that the root cause?  Is there anything we can
> do to make it faster?   We set it to Development Cache Mode, which
> helped a little but it's still much slower than it was.
>
>
> Thanks.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at 
> www.arslist.org<http://www.arslist.org>
> Platinum 
> Sponsor:rmisoluti...@verizon.net<mailto:sponsor%3armisoluti...@verizon.net> 
> ARSlist: "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at 
www.arslist.org<http://www.arslist.org>
Platinum 
Sponsor:rmisoluti...@verizon.net<mailto:sponsor%3armisoluti...@verizon.net> 
ARSlist: "Where the Answers Are"

_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"

Re: Performance Issue of Admin Tool 7.1 since installing BMC Atrium and Asset Management.

[SYTANGCO,JENARO]

Mark,

We already applied the said patch but it did not help.  I'm also in the process 
of coordinating this with BMC.

Regards, 
Jay Sytangco 
CAI Outsourcing
IT Equipment and Process Team
Phone: 63.2.5819240
Email: syta...@airproducts.com 


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Walters, Mark
Sent: Wednesday, May 13, 2009 6:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: Performance Issue of Admin Tool 7.1 since installing BMC Atrium 
and Asset Management.

There's a change in the just released 7.1 patch 7 admin tool that may help 
performance when working on a server with lots of forms/workflow, you may want 
to download it and give it a go.


Mark Walters

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or support representative for BMC Software, Inc.



-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Jarl Grøneng
Sent: 13 May 2009 11:00
To: arslist@ARSLIST.ORG
Subject: Re: Performance Issue of Admin Tool 7.1 since installing BMC Atrium 
and Asset Management.

It is a known issue. Its beacuse how admin tool queries the database,
and as you said, the amount of workflow objects.

One workaround is to disable the detailed information in the admin
tool (list tables), another one is to add the forms and workflow you
working on in an application. Then it does not refresh the information
that often.

BMC solution is to use Developerstudio 7.5, and upgrade your server to 7.5.

--
Jarl

2009/5/13 Jay Sytangco :
> Hello,
>
> Right after installing the Atrium and Asset Management applications
> we've noticed a considerable reduction in performance when making
> changes via the Admin Tool.  It is especially evident when adding or
> changing workflow objects, moreso than a form change.  Making changes
> via a definition file import is also slower but not as bad as saving
> single Active Link or Filter changes.
>
> Installing the two applications obviously added a lot of new form and
> workflow objects.  Is that the root cause?  Is there anything we can
> do to make it faster?   We set it to Development Cache Mode, which
> helped a little but it's still much slower than it was.
>
>
> Thanks.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> 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"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
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"

Re: Performance Issue of Admin Tool 7.1 since installing BMC Atrium and Asset Management.

[SYTANGCO,JENARO]

Jarl,

Thanks for your reply.  Actually we already did that but we still encounter the 
issue when saving, exporting and importing objects.

Regards, 
Jay Sytangco 


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Jarl Grøneng
Sent: Wednesday, May 13, 2009 6:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: Performance Issue of Admin Tool 7.1 since installing BMC Atrium 
and Asset Management.

It is a known issue. Its beacuse how admin tool queries the database,
and as you said, the amount of workflow objects.

One workaround is to disable the detailed information in the admin
tool (list tables), another one is to add the forms and workflow you
working on in an application. Then it does not refresh the information
that often.

BMC solution is to use Developerstudio 7.5, and upgrade your server to 7.5.

--
Jarl

2009/5/13 Jay Sytangco :
> Hello,
>
> Right after installing the Atrium and Asset Management applications
> we've noticed a considerable reduction in performance when making
> changes via the Admin Tool.  It is especially evident when adding or
> changing workflow objects, moreso than a form change.  Making changes
> via a definition file import is also slower but not as bad as saving
> single Active Link or Filter changes.
>
> Installing the two applications obviously added a lot of new form and
> workflow objects.  Is that the root cause?  Is there anything we can
> do to make it faster?   We set it to Development Cache Mode, which
> helped a little but it's still much slower than it was.
>
>
> Thanks.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> 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"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance Issue of Admin Tool 7.1 since installing BMC Atrium and Asset Management.

[Axton]

The gory details are available here if you are interested in what is going
on:

http://bugs.arswiki.org/show_bug.cgi?id=58

Axton Grams

On Wed, May 13, 2009 at 4:59 AM, Jarl Grøneng wrote:

> It is a known issue. Its beacuse how admin tool queries the database,
> and as you said, the amount of workflow objects.
>
> One workaround is to disable the detailed information in the admin
> tool (list tables), another one is to add the forms and workflow you
> working on in an application. Then it does not refresh the information
> that often.
>
> BMC solution is to use Developerstudio 7.5, and upgrade your server to 7.5.
>
> --
> Jarl
>
> 2009/5/13 Jay Sytangco :
> > Hello,
> >
> > Right after installing the Atrium and Asset Management applications
> > we've noticed a considerable reduction in performance when making
> > changes via the Admin Tool.  It is especially evident when adding or
> > changing workflow objects, moreso than a form change.  Making changes
> > via a definition file import is also slower but not as bad as saving
> > single Active Link or Filter changes.
> >
> > Installing the two applications obviously added a lot of new form and
> > workflow objects.  Is that the root cause?  Is there anything we can
> > do to make it faster?   We set it to Development Cache Mode, which
> > helped a little but it's still much slower than it was.
> >
> >
> > Thanks.
> >
> >
> ___
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > Platinum 
> > Sponsor:rmisoluti...@verizon.netARSlist:
> >  "Where the Answers Are"
> >
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum 
> Sponsor:rmisoluti...@verizon.netARSlist: 
> "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance Issue of Admin Tool 7.1 since installing BMC Atrium and Asset Management.

[Walters, Mark]

There's a change in the just released 7.1 patch 7 admin tool that may help 
performance when working on a server with lots of forms/workflow, you may want 
to download it and give it a go.


Mark Walters

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or support representative for BMC Software, Inc.



-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Jarl Grøneng
Sent: 13 May 2009 11:00
To: arslist@ARSLIST.ORG
Subject: Re: Performance Issue of Admin Tool 7.1 since installing BMC Atrium 
and Asset Management.

It is a known issue. Its beacuse how admin tool queries the database,
and as you said, the amount of workflow objects.

One workaround is to disable the detailed information in the admin
tool (list tables), another one is to add the forms and workflow you
working on in an application. Then it does not refresh the information
that often.

BMC solution is to use Developerstudio 7.5, and upgrade your server to 7.5.

--
Jarl

2009/5/13 Jay Sytangco :
> Hello,
>
> Right after installing the Atrium and Asset Management applications
> we've noticed a considerable reduction in performance when making
> changes via the Admin Tool.  It is especially evident when adding or
> changing workflow objects, moreso than a form change.  Making changes
> via a definition file import is also slower but not as bad as saving
> single Active Link or Filter changes.
>
> Installing the two applications obviously added a lot of new form and
> workflow objects.  Is that the root cause?  Is there anything we can
> do to make it faster?   We set it to Development Cache Mode, which
> helped a little but it's still much slower than it was.
>
>
> Thanks.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> 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"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance Issue of Admin Tool 7.1 since installing BMC Atrium and Asset Management.

[Jarl Grøneng]

It is a known issue. Its beacuse how admin tool queries the database,
and as you said, the amount of workflow objects.

One workaround is to disable the detailed information in the admin
tool (list tables), another one is to add the forms and workflow you
working on in an application. Then it does not refresh the information
that often.

BMC solution is to use Developerstudio 7.5, and upgrade your server to 7.5.

--
Jarl

2009/5/13 Jay Sytangco :
> Hello,
>
> Right after installing the Atrium and Asset Management applications
> we've noticed a considerable reduction in performance when making
> changes via the Admin Tool.  It is especially evident when adding or
> changing workflow objects, moreso than a form change.  Making changes
> via a definition file import is also slower but not as bad as saving
> single Active Link or Filter changes.
>
> Installing the two applications obviously added a lot of new form and
> workflow objects.  Is that the root cause?  Is there anything we can
> do to make it faster?   We set it to Development Cache Mode, which
> helped a little but it's still much slower than it was.
>
>
> Thanks.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> 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"

Performance Issue of Admin Tool 7.1 since installing BMC Atrium and Asset Management.

[Jay Sytangco]

Hello,

Right after installing the Atrium and Asset Management applications
we've noticed a considerable reduction in performance when making
changes via the Admin Tool.  It is especially evident when adding or
changing workflow objects, moreso than a form change.  Making changes
via a definition file import is also slower but not as bad as saving
single Active Link or Filter changes.

Installing the two applications obviously added a lot of new form and
workflow objects.  Is that the root cause?  Is there anything we can
do to make it faster?   We set it to Development Cache Mode, which
helped a little but it's still much slower than it was.


Thanks.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Performance Issue In Archiving the data

[Brittain, Mark]

I found that it would take me about 2 hours to archive about 5,000
records using the copy and delete. I would recommend archiving more that
once a day in smaller chunks.  Using AR Utilities, you can count records
to determine if the archiving is still running. Be careful in your
scheduling because you cannot start and archive before the last is
finished, which may have led to the crash.

 

Hope this helps.

 

Mark

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Vijayalakshmi Paulraj
Sent: Thursday, December 11, 2008 7:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance Issue In Archiving the data

 

Just a small tip.

 

The fields (columns) you use to specify the Archive qualification should
be indexed so to avoid full table scan before the archiving starts.

Thanks&Regards, 
Vijayalakshmi Paulraj 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Vyom Labs - ITSM Support
Sent: Thursday, December 11, 2008 3:45 PM
To: arslist@ARSLIST.ORG
Subject: Performance Issue In Archiving the data

 

Hello Everyone ... 

We are in very wired situation right now. We are using Remedy 7.0.0 with
ITSM Suits. 
We are facing problem in archiving. Our user complaining about slow
performance of system everyday.
If i am not wrong it's could be solve if we archive current HPD tickets.

currently we have, more than 34,00,000 incident record in HPD:HelpDesk. 
We tried to archive with qualification which has near around 60,000
record. But our UAT server had crash while arching. Same risk of arching
we can not take on production.
We have following H/w configuration.
Application server: 16 GB RAM, Sun 4 u (dual core - 4 CPU)
OS - Solaris 10
Database (remote) - 10g
Web server (remote) - tomact 5.5

Per day Incident are around 30,000. So we have decided to archive
everyday. 
Qualification would be like this, so system archive only 2 days record
before 3 months. 
So everyday we will archive around 50,000 Record. 
We want to know, How much time it will take? ..

please any suggestion would be welcome ...

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 



This message, including any attachments, contains confidential
information 
intended for a specific individual and purpose, and is intended for the
addressee only. Any unauthorized disclosure, use, dissemination,
copying, or distribution of 
this message or any of its attachments or the information contained in
this e-mail, or the taking of any action based on it, is strictly
prohibited. If you are not the intended recipient, please notify the
sender immediately by return e-mail and delete this message.



__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

This e-mail is the property of NaviSite, Inc. It is intended only
for the person or entity to which it is addressed and may contain
information that is privileged, confidential, or otherwise protected
from disclosure. Distribution or copying of this e-mail, or the
information contained herein, to anyone other than the intended
recipient is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Performance Issue In Archiving the data

[Thad K Esser]

Hi.  Your commas are confusing... do you have 3.4 million incident records 
or 34 million to archive?

Anyway, if you are archiving 50,000 incidents every day, but adding 
30,000, your net archiving is 20,000.  Dividing it out:
  34,000,000/20,000 = 1700 days (4.7 years, rounded and not 
considering the leap year)
or (depending on which number you use:
  3,400,000 / 20,000 = 170 days

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach



Vyom Labs - ITSM Support <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

12/11/2008 02:14 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Performance Issue In Archiving the data






** 
Hello Everyone ... 

We are in very wired situation right now. We are using Remedy 7.0.0 with 
ITSM Suits. 
We are facing problem in archiving. Our user complaining about slow 
performance of system everyday.
If i am not wrong it's could be solve if we archive current HPD tickets. 
currently we have, more than 34,00,000 incident record in HPD:HelpDesk. 
We tried to archive with qualification which has near around 60,000 
record. But our UAT server had crash while arching. Same risk of arching 
we can not take on production.
We have following H/w configuration.
Application server: 16 GB RAM, Sun 4 u (dual core - 4 CPU)
OS - Solaris 10
Database (remote) - 10g
Web server (remote) - tomact 5.5

Per day Incident are around 30,000. So we have decided to archive 
everyday. 
Qualification would be like this, so system archive only 2 days record 
before 3 months. 
So everyday we will archive around 50,000 Record. 
We want to know, How much time it will take? ..

please any suggestion would be welcome ...
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 

*IMPORTANT NOTICE: This communication, including any attachment, contains 
information that may be confidential or privileged, and is intended solely for 
the entity or individual to whom it is addressed.  If you are not the intended 
recipient, you should delete this message and are hereby notified that any 
disclosure, copying, or distribution of this message is strictly prohibited.  
Nothing in this email, including any attachment, is intended to be a legally 
binding signature.
*

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Performance Issue In Archiving the data

[Vijayalakshmi Paulraj]

Just a small tip.

 

The fields (columns) you use to specify the Archive qualification should
be indexed so to avoid full table scan before the archiving starts.

Thanks&Regards, 
Vijayalakshmi Paulraj 




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Vyom Labs - ITSM Support
Sent: Thursday, December 11, 2008 3:45 PM
To: arslist@ARSLIST.ORG
Subject: Performance Issue In Archiving the data

 

Hello Everyone ... 

We are in very wired situation right now. We are using Remedy 7.0.0 with
ITSM Suits. 
We are facing problem in archiving. Our user complaining about slow
performance of system everyday.
If i am not wrong it's could be solve if we archive current HPD tickets.

currently we have, more than 34,00,000 incident record in HPD:HelpDesk. 
We tried to archive with qualification which has near around 60,000
record. But our UAT server had crash while arching. Same risk of arching
we can not take on production.
We have following H/w configuration.
Application server: 16 GB RAM, Sun 4 u (dual core - 4 CPU)
OS - Solaris 10
Database (remote) - 10g
Web server (remote) - tomact 5.5

Per day Incident are around 30,000. So we have decided to archive
everyday. 
Qualification would be like this, so system archive only 2 days record
before 3 months. 
So everyday we will archive around 50,000 Record. 
We want to know, How much time it will take? ..

please any suggestion would be welcome ...

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___



This message, including any attachments, contains confidential information 
intended for a specific individual and purpose, and is intended for the 
addressee only. Any unauthorized disclosure, use, dissemination, copying, or 
distribution of 
this message or any of its attachments or the information contained in this 
e-mail, or the taking of any action based on it, is strictly prohibited. If you 
are not the intended recipient, please notify the sender immediately by return 
e-mail and delete this message.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Performance Issue In Archiving the data

[Vyom Labs - ITSM Support]

**
Hello Everyone ... We are in very wired situation right now. We are using Remedy 7.0.0 with ITSM Suits. We are facing problem in archiving. Our user complaining about slow performance of system everyday.If i am not wrong it's could be solve if we archive current HPD tickets. currently we have, more than 34,00,000 incident record in HPD:HelpDesk. We
tried to archive with qualification which has near around 60,000
record. But our UAT server had crash while arching. Same risk of
arching we can not take on production.We have following H/w configuration.Application server: 16 GB RAM, Sun 4 u (dual core - 4 CPU)OS - Solaris 10Database (remote) - 10gWeb server (remote) - tomact 5.5Per day Incident are around 30,000. So we have decided to archive everyday. Qualification would be like this, so system archive only 2 days record before 3 months. So everyday we will archive around 50,000 Record. We want to know, How much time it will take? ..please any suggestion would be welcome ...
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

[Sreenivas, Aravind]

Thank you, all, for your responses.

 

Aravind

 

 

 

On Thu, Nov 20, 2008 at 9:57 PM, strauss <[EMAIL PROTECTED]> wrote:

** 

If you restart the web server (and mid-tier) without first clearing the
cache, the mid-tier reads in the exiting persistent pre-fetch cache file
(takes about 1 minute on our servers).  Only if you flush the cache in
the mid-tier configuration tool and then restart the mid-tier will the
complete pre-fetch run (takes 24 minutes on our servers).  The
persistent pre-fetch only works properly on 7.1.00.002 
and later; earlier releases did not re-read the existing pre-fetched
cache properly after a restart, especially after a tomcat crash and
restart.

 

Christopher Strauss, Ph.D.

Call Tracking Administration Manager

University of North Texas Computing & IT Center

http://itsm.unt.edu/

 

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

[strauss]

If you restart the web server (and mid-tier) without first clearing the cache, 
the mid-tier reads in the exiting persistent pre-fetch cache file (takes about 
1 minute on our servers).  Only if you flush the cache in the mid-tier 
configuration tool and then restart the mid-tier will the complete pre-fetch 
run (takes 24 minutes on our servers).  The persistent pre-fetch only works 
properly on 7.1.00.002 and later; earlier releases did not re-read the existing 
pre-fetched cache properly after a restart, especially after a tomcat crash and 
restart.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Sreenivas, Aravind
Sent: Thursday, November 20, 2008 6:03 AM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

**

We recently observed that when we restart our app/web server (Tomcat/Apache), 
majority of the files in the cache directory (*.data and *.index) are updated 
(/webapps/ars/cache). We have enabled persistent cache option and have 
a few of the biggest forms in pre-fetch.

1. For forms mentioned in the prefetch xml, am I correct in assuming that :
a. these are fetched when I start/restart the app/web server AND the other 
forms (i.e. those not mentioned in the prefetch xml) are not fetched?
b. The forms not mentioned in the prefetch are fetched only when a user tries 
to access the forms and its out-of-date (assuming Enable check is switched on)?

2. Is there any way in which we can tell the app/web server not to fetch forms 
(either mentioned in prefetch or not) when we restart the app/web server? We 
would like it to use what data it already has in the cache directory before it 
was restarted, rather than it fetching the forms from the server again after 
its restarted.

3. What is the purpose of the USERNAME in the prefetch xml? Should only an 
admin username be defined here or will any ID do?

I skimmed through the documentation available, but was unable to get clarity on 
the above.

ARS 7.1 patch 003 on solaris
MT 7.1 patch 005 on apache 2_2/tomcat 5-5.5.25

Thanks
Aravind


From: "Easter, David" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Sent: Wednesday, November 19, 2008 6:50:50 PM

Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

**
The use of persistent cache is so that you don't have to go fetch again after 
the Mid-Tier is restarted.


BMC Remedy Mid Tier performance (persistent cache)

In AR System 7.1, forms currently cached in memory can now be serialized to a 
file, which enables these forms to be read back into memory when the 
application server hosting the mid tier application is restarted (after a 
normal shutdown).

Pre-fetch is for when the forms haven't yet been fetched.  It ensures that the 
fetching occurs prior to the first request for the form.  That way, users don't 
have to wait for the Mid-Tier to fetch the form - it's already there and cached 
for them.

-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

[SPrasad]

Hi Aravind,

In the prefetchconfig.xml we only define Demo and appadmin user accounts.
Using Demo or appadmin users for prefetchig would be enough to have a
configuration usefull for most of your users.

Thanks
SPrasad


Sreenivas, Aravind wrote:
> 
>  
> 
> We recently observed that when we restart our app/web server
> (Tomcat/Apache), majority of the files in the cache directory (*.data
> and *.index) are updated (/webapps/ars/cache). We have enabled
> persistent cache option and have a few of the biggest forms in
> pre-fetch.
> 
>  
> 
> 1. For forms mentioned in the prefetch xml, am I correct in assuming
> that :
> 
> a. these are fetched when I start/restart the app/web server AND the
> other forms (i.e. those not mentioned in the prefetch xml) are not
> fetched? 
> 
> b. The forms not mentioned in the prefetch are fetched only when a user
> tries to access the forms and its out-of-date (assuming Enable check is
> switched on)?
> 
>  
> 
> 2. Is there any way in which we can tell the app/web server not to fetch
> forms (either mentioned in prefetch or not) when we restart the app/web
> server? We would like it to use what data it already has in the cache
> directory before it was restarted, rather than it fetching the forms
> from the server again after its restarted.
> 
>  
> 
> 3. What is the purpose of the USERNAME in the prefetch xml? Should only
> an admin username be defined here or will any ID do?
> 
>  
> 
> I skimmed through the documentation available, but was unable to get
> clarity on the above.
> 
>  
> 
> ARS 7.1 patch 003 on solaris
> 
> MT 7.1 patch 005 on apache 2_2/tomcat 5-5.5.25
> 
>  
> 
> Thanks
> 
> Aravind
> 
>  
> 
> ____
> 
> From: "Easter, David" <[EMAIL PROTECTED]>
> To: arslist@ARSLIST.ORG
> 
> Sent: Wednesday, November 19, 2008 6:50:50 PM 
> 
> 
> Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat
> 
> 
> ** 
> 
> The use of persistent cache is so that you don't have to go fetch again
> after the Mid-Tier is restarted.  
> 
>  
> 
> BMC Remedy Mid Tier performance (persistent cache)
> 
> In AR System 7.1, forms currently cached in memory can now be serialized
> to a file, which enables these forms to be read back into memory when
> the application server hosting the mid tier application is restarted
> (after a normal shutdown).
> 
>  
> 
> Pre-fetch is for when the forms haven't yet been fetched.  It ensures
> that the fetching occurs prior to the first request for the form.  That
> way, users don't have to wait for the Mid-Tier to fetch the form - it's
> already there and cached for them.
> 
>  
> 
> -David J. Easter
> 
> Sr. Product Manager, Solution Strategy and Development
> 
> BMC Software, Inc.
> 
>  
> 
> The opinions, statements, and/or suggested courses of action expressed
> in this E-mail do not necessarily reflect those of BMC Software, Inc.
> My voluntary participation in this forum is not intended to convey a
> role as a spokesperson, liaison or public relations representative for
> BMC Software, Inc.
> 
>  
> 
>  
> 
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Mid-Tier-7.1.0-Performance-IssueTomcat-tp20587205p20604874.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

[Joe DeSouza]

Aravind,

It uses the persistent cache by default after a restart of the web server 
unless the stop of the web server had been caused by a crash - that is my 
understanding of persistent cache.

I believe the reason it doesn't use the persistent cache if the web server 
crashes is that the crash may have been caused by a corruption in the cache, so 
it flushes and rebuilds the cache..

Joe





From: "Sreenivas, Aravind" <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, November 20, 2008 7:02:51 AM
Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

** 
 
We recently observed that when we restart our app/web server (Tomcat/Apache), 
majority of the files in the cache directory (*.data and *.index) are updated 
(/webapps/ars/cache). We have enabled persistent cache option and have 
a few of the biggest forms in pre-fetch.
 
1. For forms mentioned in the prefetch xml, am I correct in assuming that :
a. these are fetched when I start/restart the app/web server AND the other 
forms (i.e. those not mentioned in the prefetch xml) are not fetched? 
b. The forms not mentioned in the prefetch are fetched only when a user tries 
to access the forms and its out-of-date (assuming Enable check is switched on)?
 
2. Is there any way in which we can tell the app/web server not to fetch forms 
(either mentioned in prefetch or not) when we restart the app/web server? We 
would like it to use what data it already has in the cache directory before it 
was restarted, rather than it fetching the forms from the server again after 
its restarted.
 
3. What is the purpose of the USERNAME in the prefetch xml? Should only an 
admin username be defined here or will any ID do?
 
I skimmed through the documentation available, but was unable to get clarity on 
the above.
 
ARS 7.1 patch 003 on solaris
MT 7.1 patch 005 on apache 2_2/tomcat 5-5.5.25
 
Thanks
Aravind
 



From:"Easter, David" <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent:Wednesday, November 19, 2008 6:50:50 PM 

Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

** 
The use of persistent cache is so that you don't have to go fetch again after 
the Mid-Tier is restarted.  
 
BMC Remedy Mid Tier performance (persistent cache)
In AR System 7.1, forms currently cached in memory can now be serialized to a 
file, which enables these forms to be read back into memory when the 
application server hosting the mid tier application is restarted (after a 
normal shutdown).
 
Pre-fetch is for when the forms haven't yet been fetched.  It ensures that the 
fetching occurs prior to the first request for the form.  That way, users don't 
have to wait for the Mid-Tier to fetch the form - it's already there and cached 
for them.
 
-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.
 
The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

[Sreenivas, Aravind]

 

We recently observed that when we restart our app/web server
(Tomcat/Apache), majority of the files in the cache directory (*.data
and *.index) are updated (/webapps/ars/cache). We have enabled
persistent cache option and have a few of the biggest forms in
pre-fetch.

 

1. For forms mentioned in the prefetch xml, am I correct in assuming
that :

a. these are fetched when I start/restart the app/web server AND the
other forms (i.e. those not mentioned in the prefetch xml) are not
fetched? 

b. The forms not mentioned in the prefetch are fetched only when a user
tries to access the forms and its out-of-date (assuming Enable check is
switched on)?

 

2. Is there any way in which we can tell the app/web server not to fetch
forms (either mentioned in prefetch or not) when we restart the app/web
server? We would like it to use what data it already has in the cache
directory before it was restarted, rather than it fetching the forms
from the server again after its restarted.

 

3. What is the purpose of the USERNAME in the prefetch xml? Should only
an admin username be defined here or will any ID do?

 

I skimmed through the documentation available, but was unable to get
clarity on the above.

 

ARS 7.1 patch 003 on solaris

MT 7.1 patch 005 on apache 2_2/tomcat 5-5.5.25

 

Thanks

Aravind

 



From: "Easter, David" <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG

Sent: Wednesday, November 19, 2008 6:50:50 PM 


Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat


** 

The use of persistent cache is so that you don't have to go fetch again
after the Mid-Tier is restarted.  

 

BMC Remedy Mid Tier performance (persistent cache)

In AR System 7.1, forms currently cached in memory can now be serialized
to a file, which enables these forms to be read back into memory when
the application server hosting the mid tier application is restarted
(after a normal shutdown).

 

Pre-fetch is for when the forms haven't yet been fetched.  It ensures
that the fetching occurs prior to the first request for the form.  That
way, users don't have to wait for the Mid-Tier to fetch the form - it's
already there and cached for them.

 

-David J. Easter

Sr. Product Manager, Solution Strategy and Development

BMC Software, Inc.

 

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.

 

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

[Joe DeSouza]

Cool, for some reason I was under the impression that persistent cache was 
designed to do away with pre-fetching altogether. From your explanation and 
extract from documentation it appears like it is designed to collaborate with 
pre-fetch to further improve the overall performance..

Thanks for the correction.

Cheers

Joe





From: "Easter, David" <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, November 19, 2008 6:50:50 PM
Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

** 
The use of persistent cache is so that you don't have to go fetch again after 
the Mid-Tier is restarted.  
 
BMC Remedy Mid Tier performance (persistent cache)
In AR System 7.1, forms currently cached in memory can now be serialized to a 
file,which enables these forms to be read back into memory when the 
applicationserver hosting the mid tier application is restarted (after a normal 
shutdown).
 
Pre-fetch is for when the forms haven't yet been fetched.  It ensures that the 
fetching occurs prior to the first request for the form.  That way, users don't 
have to wait for the Mid-Tier to fetch the form - it's already there and cached 
for them.
 
-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.
 
The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.




From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Joe DeSouza
Sent: Wednesday, November 19, 2008 3:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

** 
What is the use of persistent cache then? I thought that was introduced to do 
away with that initial hit of choking up the server during a startup where it 
takes forever to build its cache.

I did notice that the prefetch xml file was still available but hadn't really 
bothered configuring it as persistent cache kept our cache intact on disk 
during any web server restarts..

Joe





From: "Easter, David" <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, November 19, 2008 5:31:52 PM
Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

** 
> 7.1 doesn't use pre-fetch to the best of my knowledge.. 
 
AR System 7.1.00 definitely provides an ability to do pre-fetch.  In fact, 
7.1.00 is the first release where it was formally supported.  Here's a 
cut/paste from the "What's New in AR System 7.1.00" document:
 
Prefetching specified forms
Administrators can select forms to be preloaded into the system’s 
memory(prefetched) so that forms can be loaded faster when they are opened in a 
browser.This capability is especially useful for larger forms that otherwise 
might takeseveral seconds to load.  Forms can be selected for prefetching 
eitherby editing the prefetchConfig.xml file, available in the 
web-inf/classesdirectory.from the BMC Remedy Configuration Tool, or
 
The What's New document can be found here:
 
06-Aug-2007 What’s New: BMC Remedy Action Request System 7.1.00 PDF
 
 
-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.
 
The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Joe DeSouza
Sent: Wednesday, November 19, 2008 12:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

** 
Change the Resource Check Interval to greater than that - make it about 604800 
that equate to 7 days rather than a day that you have there..

7.1 doesn't use pre-fetch to the best of my knowledge.. That was good until 
7.0. Check the Persistent Cache option instead on 7.1 which basically stores 
all your server cache on disk so if the web server is shut down gracefully, it 
uses the same cache that is on disk the next time it is brought up.

It blows the cache away from the disk only in case of a web server crash..

Adjust the java initial and maximum heap size (-Xms & -Xmx). The recommended 
maximum heap size should be no greater than 65 to 70% of the 'total available 
free memory' before Tomcat is started. Its good to have about 30 to 35% 
headroom or you would crash your tomcat server even while starting it or it 
might crash when and if you want to stop it. Your initial size should be at 
least 

Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

[Easter, David]

The use of persistent cache is so that you don't have to go fetch again after 
the Mid-Tier is restarted.  
 
BMC Remedy Mid Tier performance (persistent cache)

In AR System 7.1, forms currently cached in memory can now be serialized to a 
file, which enables these forms to be read back into memory when the 
application server hosting the mid tier application is restarted (after a 
normal shutdown).

 
Pre-fetch is for when the forms haven't yet been fetched.  It ensures that the 
fetching occurs prior to the first request for the form.  That way, users don't 
have to wait for the Mid-Tier to fetch the form - it's already there and cached 
for them.
 
-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.
 
The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.
 
 


From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Joe DeSouza
Sent: Wednesday, November 19, 2008 3:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat


** 
What is the use of persistent cache then? I thought that was introduced to do 
away with that initial hit of choking up the server during a startup where it 
takes forever to build its cache.
 
I did notice that the prefetch xml file was still available but hadn't really 
bothered configuring it as persistent cache kept our cache intact on disk 
during any web server restarts..
 
Joe




From: "Easter, David" <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, November 19, 2008 5:31:52 PM
Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

** 
> 7.1 doesn't use pre-fetch to the best of my knowledge.. 
 
AR System 7.1.00 definitely provides an ability to do pre-fetch.  In fact, 
7.1.00 is the first release where it was formally supported.  Here's a 
cut/paste from the "What's New in AR System 7.1.00" document:
 
Prefetching specified forms

Administrators can select forms to be preloaded into the system’s memory 
(prefetched) so that forms can be loaded faster when they are opened in a 
browser. This capability is especially useful for larger forms that otherwise 
might take several seconds to load.  Forms can be selected for prefetching 
either

from the BMC Remedy Configuration Tool, or

by editing the prefetchConfig.xml file, available in the web-inf/classes 
directory.

 
The What's New document can be found here:
 
06-Aug-2007 What’s New: BMC Remedy Action Request System 7.1.00 PDF 
<http://www.bmc.com/supportu/documents/17/53/71753/71753.pdf>  
 
 
-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.
 
The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.
 


From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Joe DeSouza
Sent: Wednesday, November 19, 2008 12:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat


** 
Change the Resource Check Interval to greater than that - make it about 604800 
that equate to 7 days rather than a day that you have there..
 
7.1 doesn't use pre-fetch to the best of my knowledge.. That was good until 
7.0. Check the Persistent Cache option instead on 7.1 which basically stores 
all your server cache on disk so if the web server is shut down gracefully, it 
uses the same cache that is on disk the next time it is brought up.
 
It blows the cache away from the disk only in case of a web server crash..
 
Adjust the java initial and maximum heap size (-Xms & -Xmx). The recommended 
maximum heap size should be no greater than 65 to 70% of the 'total available 
free memory' before Tomcat is started. Its good to have about 30 to 35% 
headroom or you would crash your tomcat server even while starting it or it 
might crash when and if you want to stop it. Your initial size should be at 
least about 1024 M. If that is over the 65 to 70% headroom that you need, then 
your server resources aren't enough - consider up sizing your server..
 
If you still see out of memory errors on the catalina.out file that causes your 
tomcat application server to crash, implement the 'incremental garbage 
collection' (-Xincgc). This helps your tomcat server to free up memory by 
clearing unused portions of its memory (least used portions).
 
Let

Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

[Joe DeSouza]

What is the use of persistent cache then? I thought that was introduced to do 
away with that initial hit of choking up the server during a startup where it 
takes forever to build its cache.

I did notice that the prefetch xml file was still available but hadn't really 
bothered configuring it as persistent cache kept our cache intact on disk 
during any web server restarts..

Joe





From: "Easter, David" <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, November 19, 2008 5:31:52 PM
Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

** 
> 7.1 doesn't use pre-fetch to the best of my knowledge.. 
 
AR System 7.1.00 definitely provides an ability to do pre-fetch.  In fact, 
7.1.00 is the first release where it was formally supported.  Here's a 
cut/paste from the "What's New in AR System 7.1.00" document:
 
Prefetching specified forms
Administrators can select forms to be preloaded into the system’s 
memory(prefetched) so that forms can be loaded faster when they are opened in a 
browser.This capability is especially useful for larger forms that otherwise 
might takeseveral seconds to load.  Forms can be selected for prefetching 
eitherby editing the prefetchConfig.xml file, available in the 
web-inf/classesdirectory.from the BMC Remedy Configuration Tool, or
 
The What's New document can be found here:
 
06-Aug-2007 What’s New: BMC Remedy Action Request System 7.1.00 PDF
 
 
-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.
 
The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Joe DeSouza
Sent: Wednesday, November 19, 2008 12:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

** 
Change the Resource Check Interval to greater than that - make it about 604800 
that equate to 7 days rather than a day that you have there..

7.1 doesn't use pre-fetch to the best of my knowledge.. That was good until 
7.0. Check the Persistent Cache option instead on 7.1 which basically stores 
all your server cache on disk so if the web server is shut down gracefully, it 
uses the same cache that is on disk the next time it is brought up.

It blows the cache away from the disk only in case of a web server crash..

Adjust the java initial and maximum heap size (-Xms & -Xmx). The recommended 
maximum heap size should be no greater than 65 to 70% of the 'total available 
free memory' before Tomcat is started. Its good to have about 30 to 35% 
headroom or you would crash your tomcat server even while starting it or it 
might crash when and if you want to stop it. Your initial size should be at 
least about 1024 M. If that is over the 65 to 70% headroom that you need, then 
your server resources aren't enough - consider up sizing your server..

If you still see out of memory errors on the catalina.out file that causes your 
tomcat application server to crash, implement the 'incremental garbage 
collection' (-Xincgc). This helps your tomcat server to free up memory by 
clearing unused portions of its memory (least used portions).

Let me know if any of these help..

Cheers

Joe





From: SPrasad <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, November 19, 2008 2:20:50 PM
Subject: Mid-Tier 7.1.0 Performance Issue -- Tomcat

Hi All,

We are getting slow response from Server and we are looking for ways to improve 
our server performance.

I have made the following changes in the Mid-Tier configuration tool.

Cache Settings:

1) Uncheck the perform check box
2) Change the Resource Check Interval from the default of 300 seconds to 86400 
seconds 

Reporting:

1) Log Level: For best performance, this value should be set to SEVERE. 
2) We are logging only Reporting.

There are few more recommedations I saw in the documentation and those are 

1) arsystem.pooling_max_connections_per_server: Default is 80. Change to 1000 
2) arsystem.pooling_max_total_connections: Change to 2000.

And also, I have updated the prefetchconfig.xml file with all the forms that we 
use regularly.

Below is our Environment Info:

AR Server Ver:7.1.0 Patch002
Mid-Tier: 7.1.0 Patch002
Web Server Information: Apache Tomcat/5.5.26
Java Version: 1.5.0_13
O/S: Linux
Database:Oracle 10.2.0.4

Does anyone have some type of documentation or tips or recommendations for 
enhancing the performance of Mid-Tier version 7.1.0 Patch002?

Any help is really appreciated.

Thanks
SPrasad


 

Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

[Easter, David]

> 7.1 doesn't use pre-fetch to the best of my knowledge.. 
 
AR System 7.1.00 definitely provides an ability to do pre-fetch.  In
fact, 7.1.00 is the first release where it was formally supported.
Here's a cut/paste from the "What's New in AR System 7.1.00" document:
 
Prefetching specified forms

Administrators can select forms to be preloaded into the system's memory
(prefetched) so that forms can be loaded faster when they are opened in
a browser. This capability is especially useful for larger forms that
otherwise might take several seconds to load.  Forms can be selected for
prefetching either


 from the BMC Remedy Configuration Tool, or


 by editing the prefetchConfig.xml file, available in the
web-inf/classes directory.

 
The What's New document can be found here:
 
06-Aug-2007 What's New: BMC Remedy Action Request System 7.1.00
PDF <http://www.bmc.com/supportu/documents/17/53/71753/71753.pdf>  
 
 
-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.
 
The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.
 


From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza
Sent: Wednesday, November 19, 2008 12:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat


** 
Change the Resource Check Interval to greater than that - make it about
604800 that equate to 7 days rather than a day that you have there..
 
7.1 doesn't use pre-fetch to the best of my knowledge.. That was good
until 7.0. Check the Persistent Cache option instead on 7.1 which
basically stores all your server cache on disk so if the web server is
shut down gracefully, it uses the same cache that is on disk the next
time it is brought up.
 
It blows the cache away from the disk only in case of a web server
crash..
 
Adjust the java initial and maximum heap size (-Xms & -Xmx). The
recommended maximum heap size should be no greater than 65 to 70% of the
'total available free memory' before Tomcat is started. Its good to have
about 30 to 35% headroom or you would crash your tomcat server even
while starting it or it might crash when and if you want to stop it.
Your initial size should be at least about 1024 M. If that is over the
65 to 70% headroom that you need, then your server resources aren't
enough - consider up sizing your server..
 
If you still see out of memory errors on the catalina.out file that
causes your tomcat application server to crash, implement the
'incremental garbage collection' (-Xincgc). This helps your tomcat
server to free up memory by clearing unused portions of its memory
(least used portions).
 
Let me know if any of these help..
 
Cheers
 
Joe




From: SPrasad <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, November 19, 2008 2:20:50 PM
Subject: Mid-Tier 7.1.0 Performance Issue -- Tomcat

Hi All,

We are getting slow response from Server and we are looking for ways to
improve our server performance.

I have made the following changes in the Mid-Tier configuration tool.

Cache Settings:

1) Uncheck the perform check box
2) Change the Resource Check Interval from the default of 300 seconds to
86400 seconds 

Reporting:

1) Log Level: For best performance, this value should be set to SEVERE. 
2) We are logging only Reporting.

There are few more recommedations I saw in the documentation and those
are 

1) arsystem.pooling_max_connections_per_server: Default is 80. Change to
1000 
2) arsystem.pooling_max_total_connections: Change to 2000.

And also, I have updated the prefetchconfig.xml file with all the forms
that we use regularly.

Below is our Environment Info:

AR Server Ver:7.1.0 Patch002
Mid-Tier: 7.1.0 Patch002
Web Server Information: Apache Tomcat/5.5.26
Java Version: 1.5.0_13
O/S: Linux
Database:Oracle 10.2.0.4

Does anyone have some type of documentation or tips or recommendations
for enhancing the performance of Mid-Tier version 7.1.0 Patch002?

Any help is really appreciated.

Thanks
SPrasad

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Mid-Tier 7.1.0 Performance Issue -- Tomcat

[Joe DeSouza]

Change the Resource Check Interval to greater than that - make it about 604800 
that equate to 7 days rather than a day that you have there..

7.1 doesn't use pre-fetch to the best of my knowledge.. That was good until 
7.0. Check the Persistent Cache option instead on 7.1 which basically stores 
all your server cache on disk so if the web server is shut down gracefully, it 
uses the same cache that is on disk the next time it is brought up.

It blows the cache away from the disk only in case of a web server crash..

Adjust the java initial and maximum heap size (-Xms & -Xmx). The recommended 
maximum heap size should be no greater than 65 to 70% of the 'total available 
free memory' before Tomcat is started. Its good to have about 30 to 35% 
headroom or you would crash your tomcat server even while starting it or it 
might crash when and if you want to stop it. Your initial size should be at 
least about 1024 M. If that is over the 65 to 70% headroom that you need, then 
your server resources aren't enough - consider up sizing your server..

If you still see out of memory errors on the catalina.out file that causes your 
tomcat application server to crash, implement the 'incremental garbage 
collection' (-Xincgc). This helps your tomcat server to free up memory by 
clearing unused portions of its memory (least used portions).

Let me know if any of these help..

Cheers

Joe





From: SPrasad <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, November 19, 2008 2:20:50 PM
Subject: Mid-Tier 7.1.0 Performance Issue -- Tomcat

Hi All,

We are getting slow response from Server and we are looking for ways to improve 
our server performance.

I have made the following changes in the Mid-Tier configuration tool.

Cache Settings:

1) Uncheck the perform check box
2) Change the Resource Check Interval from the default of 300 seconds to 86400 
seconds 

Reporting:

1) Log Level: For best performance, this value should be set to SEVERE. 
2) We are logging only Reporting.

There are few more recommedations I saw in the documentation and those are 

1) arsystem.pooling_max_connections_per_server: Default is 80. Change to 1000 
2) arsystem.pooling_max_total_connections: Change to 2000.

And also, I have updated the prefetchconfig.xml file with all the forms that we 
use regularly.

Below is our Environment Info:

AR Server Ver:7.1.0 Patch002
Mid-Tier: 7.1.0 Patch002
Web Server Information: Apache Tomcat/5.5.26
Java Version: 1.5.0_13
O/S: Linux
Database:Oracle 10.2.0.4

Does anyone have some type of documentation or tips or recommendations for 
enhancing the performance of Mid-Tier version 7.1.0 Patch002?

Any help is really appreciated.

Thanks
SPrasad




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Mid-Tier 7.1.0 Performance Issue -- Tomcat

[SPrasad]

Hi All,

We are getting slow response from Server and we are looking for ways to
improve our server performance.

I have made the following changes in the Mid-Tier configuration tool.

Cache Settings:

1) Uncheck the perform check box
2) Change the Resource Check Interval from the default of 300 seconds to
86400 seconds 

Reporting:

1) Log Level: For best performance, this value should be set to SEVERE. 
2) We are logging only Reporting.

There are few more recommedations I saw in the documentation and those are 

 1) arsystem.pooling_max_connections_per_server: Default is 80. Change to
1000 
 2) arsystem.pooling_max_total_connections: Change to 2000.

And also, I have updated the prefetchconfig.xml file with all the forms that
we use regularly.

Below is our Environment Info:

AR Server Ver:7.1.0 Patch002
Mid-Tier: 7.1.0 Patch002
Web Server Information: Apache Tomcat/5.5.26
Java Version: 1.5.0_13
O/S: Linux
Database:Oracle 10.2.0.4

Does anyone have some type of documentation or tips or recommendations for
enhancing the performance of Mid-Tier version 7.1.0 Patch002?

Any help is really appreciated.

Thanks
SPrasad

-- 
View this message in context: 
http://www.nabble.com/Mid-Tier-7.1.0-Performance-IssueTomcat-tp20587205p20587205.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Performance Issue with Marimba Integration application data uploads

[jmchugh]

CMDB 2.01 Patch 4
DSL 7.0.1 to latest patched data
Remedy Server version 7.0.1patch 5
ARServer OS HPUX 11i

Marimba/CM Tuner version 7.1 - OS Windows 2003
Marimba/CM Transmitter MC 7.1 OS Windows 2003
Marimba/CM Database Oracle 9i OS HPUX

Integration with CMDB version 7.0.3
Remedy Link for Oracle/EIE version 7.0.1 patch 6 OS Windows 2003

Hi
Has anyone had problems with the appication upload of data
Pull_ARS_INV_APPLICATION.

The debug log files shows the statement:

SELECT DISTINCT "SEQ_ID" FROM INVENTORY.MRB_INV_APPLICATION ORDER BY
"SEQ_ID"

not completing after 2 - 3 days this is woring as we have completed
this from an out of the box integration. We have tried the statement
at database level this does not complete.

Does anyone have any pointers in what could be causing this type of
issue? or

how to overcome such a problem?

Thanks in advance
John

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

URGENT - ITSM 7 performance issue - help needed - SOLVED

[ZHANG, ERIC L]

Many thanks to all those who replied to the list and sent me email 
directly.

After 8 days 12 hours, the issue has been resolved by changing a file 
system setting on Oracle database server.  The setting "mincache" was
set 
to "direct".  After we implemented the change at noon today, saving a
new 
incident took only 1-2 seconds, down from over 2 minutes in some cases!

The BMC support engineer (thanks to Virginia Burnham) looked at all the 
loggings I collected and identified that writing BLOBs to disk took too 
long. The incident table happens to have quite a few BLOB columns. 
The "mincache" setting was recommended by Oracle/Veritas for 
Oracle/Solaris platform using Veritas file system. This was a 
recommendation by Virginia on Tuesday but was not implemented until
today 
after all the evidences showed that BLOG writing to disk took very long 
time.

If you have Oracle/Solaris platform using Veritas file system, you may 
want to consider setting "mincache" to "direct" with your ITSM 7 
implementation. It may save you some sleepless nights.

Eric Zhang
Sr. IT Consultant
Entergy Services, Inc.
(501) 377-5815

On Wed, 8 Aug 2007 23:25:34 -0500, ZHANG, ERIC L <[EMAIL PROTECTED]> 
wrote:

>I post this earlier today but don't see it on the list.  I am trying
>again.  I apologize if you already saw this.
>
>-Original Message-
>From: Eric Zhang [mailto:[EMAIL PROTECTED] 
>Sent: Wednesday, August 08, 2007 12:21 PM
>To: [EMAIL PROTECTED]
>Cc: ZHANG, ERIC L
>Subject: URGENT - ITSM 7 performance issue - help needed
>
>Hello, all.
>
>We have been struggling with ITSM 7 performance since it went live on 
>8/1.  The performance is getting worse and worse for all the
operations:
>
>search, create, and update.  At the begging, it's the creating incident

>that took more that 40 seconds to complete.  Now it's all the
>operations, 
>primarily on Incident.  The incident ticket update can take up to 3 
>minutes now.  We opened a critical ticket to BMC support but so far we 
>haven't received a solution that improves the performance.
>
>Our configurations:
>
>ARS 7.0.01 no patch on Solaris 9
>Database is Oracle 10gR2 on another Solaris 9 box 
>Midtier is on Wintel 2003 IIS server (Only for requesters)
>ITSM (including Incident and Change) 7.0.02 patch 3
>
>I have been sending all kinds of loggings to BMC.  The first suggestion

>from BMC was to set Oracle-Cursor-Sharing to FORCES.  That didn't help.
>
>The other suggestion was to change a Veritas setting
("mincache=direct")
>
>on the database server.  But our DBA, UNIX. and Storage people all 
>rejected the idea because 1) that fix is for bulk data import 2) they
>had 
>very experienced with that setting, which produced high IO waits and
>worse 
>overall daily performance.
>
>Thanks in advance for your help.
>
>Eric Zhang
>Sr. IT Consultant
>Entergy Services, Inc.
>(501) 377-5815
>
>___
___
_
>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where 
the Answers Are"
>===
=

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: URGENT - ITSM 7 performance issue - help needed

[john rosquist]

How many fast and list servers do you have configured.  Do the DBA see a 
similar number if threads being consumed on the database.  Are the threads on 
the database being orphaned or recycled?  Do the DBA's have suffient number of 
connections set up for remedy to access (thread starvation). What are the SQL 
response times? (<1sec?)

Is there anything between remedy and the database. Are you sure. Often the 
System Admins will not admint to this.  Check your line speeds, duplex and mtu 
settings one EVERY step of the path.

Verify your indexes.  ITSM 7 does not seem to have a lot indexed.

John Rosquist
Windward Consulting Group


- Original Message 
From: "Pierson, Shawn" <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, August 9, 2007 8:36:54 AM
Subject: Re: URGENT - ITSM 7 performance issue - help needed


Turn on your SQL logging and try running the SQL that is generated in
Toad (just select statements, not updates or inserts.)  In the past I've
found that there can be table scans that are major performance hits that
way.  The resolution ends up being adding more indexes or changing the
criteria Set Fields workflow uses.  If you find a SQL statement that
takes too long to run, pass it on to your DBA and they should be able to
do more troubleshooting to see why it is doing so and what can be done
about it.

Shawn Pierson

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of ZHANG, ERIC L
Sent: Wednesday, August 08, 2007 11:26 PM
To: arslist@ARSLIST.ORG
Subject: URGENT - ITSM 7 performance issue - help needed


I post this earlier today but don't see it on the list.  I am trying
again.  I apologize if you already saw this.

-Original Message-
From: Eric Zhang [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 12:21 PM
To: [EMAIL PROTECTED]
Cc: ZHANG, ERIC L
Subject: URGENT - ITSM 7 performance issue - help needed

Hello, all.

We have been struggling with ITSM 7 performance since it went live on
8/1.  The performance is getting worse and worse for all the operations:

search, create, and update.  At the begging, it's the creating incident
that took more that 40 seconds to complete.  Now it's all the
operations,
primarily on Incident.  The incident ticket update can take up to 3
minutes now.  We opened a critical ticket to BMC support but so far we
haven't received a solution that improves the performance.

Our configurations:

ARS 7.0.01 no patch on Solaris 9
Database is Oracle 10gR2 on another Solaris 9 box
Midtier is on Wintel 2003 IIS server (Only for requesters)
ITSM (including Incident and Change) 7.0.02 patch 3

I have been sending all kinds of loggings to BMC.  The first suggestion
from BMC was to set Oracle-Cursor-Sharing to FORCES.  That didn't help.

The other suggestion was to change a Veritas setting ("mincache=direct")

on the database server.  But our DBA, UNIX. and Storage people all
rejected the idea because 1) that fix is for bulk data import 2) they
had
very experienced with that setting, which produced high IO waits and
worse
overall daily performance.

Thanks in advance for your help.

Eric Zhang
Sr. IT Consultant
Entergy Services, Inc.
(501) 377-5815


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

Private and confidential as detailed http://www.sug.com/disclaimers/default.htm#Mail";>here.  If you cannot 
access hyperlink, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"


   

Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, 
photos & more. 
http://mobile.yahoo.com/go?refer=1GNXIC

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: URGENT - ITSM 7 performance issue - help needed

[Pierson, Shawn]

Turn on your SQL logging and try running the SQL that is generated in
Toad (just select statements, not updates or inserts.)  In the past I've
found that there can be table scans that are major performance hits that
way.  The resolution ends up being adding more indexes or changing the
criteria Set Fields workflow uses.  If you find a SQL statement that
takes too long to run, pass it on to your DBA and they should be able to
do more troubleshooting to see why it is doing so and what can be done
about it.

Shawn Pierson

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of ZHANG, ERIC L
Sent: Wednesday, August 08, 2007 11:26 PM
To: arslist@ARSLIST.ORG
Subject: URGENT - ITSM 7 performance issue - help needed


I post this earlier today but don't see it on the list.  I am trying
again.  I apologize if you already saw this.

-Original Message-
From: Eric Zhang [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 12:21 PM
To: [EMAIL PROTECTED]
Cc: ZHANG, ERIC L
Subject: URGENT - ITSM 7 performance issue - help needed

Hello, all.

We have been struggling with ITSM 7 performance since it went live on
8/1.  The performance is getting worse and worse for all the operations:

search, create, and update.  At the begging, it's the creating incident
that took more that 40 seconds to complete.  Now it's all the
operations,
primarily on Incident.  The incident ticket update can take up to 3
minutes now.  We opened a critical ticket to BMC support but so far we
haven't received a solution that improves the performance.

Our configurations:

ARS 7.0.01 no patch on Solaris 9
Database is Oracle 10gR2 on another Solaris 9 box
Midtier is on Wintel 2003 IIS server (Only for requesters)
ITSM (including Incident and Change) 7.0.02 patch 3

I have been sending all kinds of loggings to BMC.  The first suggestion
from BMC was to set Oracle-Cursor-Sharing to FORCES.  That didn't help.

The other suggestion was to change a Veritas setting ("mincache=direct")

on the database server.  But our DBA, UNIX. and Storage people all
rejected the idea because 1) that fix is for bulk data import 2) they
had
very experienced with that setting, which produced high IO waits and
worse
overall daily performance.

Thanks in advance for your help.

Eric Zhang
Sr. IT Consultant
Entergy Services, Inc.
(501) 377-5815


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

Private and confidential as detailed http://www.sug.com/disclaimers/default.htm#Mail";>here.  If you cannot 
access hyperlink, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: URGENT - ITSM 7 performance issue - help needed

[John Cahill]

Have there been any configuration settings placed directly in the database,
for example, Case Insensitive.  The setting Oracle provides, unfortunately,
ignores all Remedy indexes.  This will result in very poor performance.

John Cahill
Regional Engineering Manager
Column Technologies, Inc.
email: [EMAIL PROTECTED]
cell: (513) 314-9922
www.columnit.com
 
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of ZHANG, ERIC L
Sent: Thursday, August 09, 2007 12:26 AM
To: arslist@ARSLIST.ORG
Subject: URGENT - ITSM 7 performance issue - help needed

I post this earlier today but don't see it on the list.  I am trying
again.  I apologize if you already saw this.

-Original Message-
From: Eric Zhang [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 12:21 PM
To: [EMAIL PROTECTED]
Cc: ZHANG, ERIC L
Subject: URGENT - ITSM 7 performance issue - help needed

Hello, all.

We have been struggling with ITSM 7 performance since it went live on 
8/1.  The performance is getting worse and worse for all the operations:

search, create, and update.  At the begging, it's the creating incident 
that took more that 40 seconds to complete.  Now it's all the
operations, 
primarily on Incident.  The incident ticket update can take up to 3 
minutes now.  We opened a critical ticket to BMC support but so far we 
haven't received a solution that improves the performance.

Our configurations:

ARS 7.0.01 no patch on Solaris 9
Database is Oracle 10gR2 on another Solaris 9 box 
Midtier is on Wintel 2003 IIS server (Only for requesters)
ITSM (including Incident and Change) 7.0.02 patch 3

I have been sending all kinds of loggings to BMC.  The first suggestion 
from BMC was to set Oracle-Cursor-Sharing to FORCES.  That didn't help.

The other suggestion was to change a Veritas setting ("mincache=direct")

on the database server.  But our DBA, UNIX. and Storage people all 
rejected the idea because 1) that fix is for bulk data import 2) they
had 
very experienced with that setting, which produced high IO waits and
worse 
overall daily performance.

Thanks in advance for your help.

Eric Zhang
Sr. IT Consultant
Entergy Services, Inc.
(501) 377-5815


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: URGENT - ITSM 7 performance issue - help needed

[Jose Manuel Viejo Lobato]

Before modify anything, I think you should patch the ARS server. There are a few
memory issues resolved with the patchs, maybe could resolve your problems.

Regards;

Jose Manuel Viejo Lobato
[EMAIL PROTECTED]
ViejoLobato S.L.


Mensaje citado por "ZHANG, ERIC L" <[EMAIL PROTECTED]>:

> I post this earlier today but don't see it on the list.  I am trying
> again.  I apologize if you already saw this.
>
> -Original Message-
> From: Eric Zhang [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 08, 2007 12:21 PM
> To: [EMAIL PROTECTED]
> Cc: ZHANG, ERIC L
> Subject: URGENT - ITSM 7 performance issue - help needed
>
> Hello, all.
>
> We have been struggling with ITSM 7 performance since it went live on
> 8/1.  The performance is getting worse and worse for all the operations:
>
> search, create, and update.  At the begging, it's the creating incident
> that took more that 40 seconds to complete.  Now it's all the
> operations,
> primarily on Incident.  The incident ticket update can take up to 3
> minutes now.  We opened a critical ticket to BMC support but so far we
> haven't received a solution that improves the performance.
>
> Our configurations:
>
> ARS 7.0.01 no patch on Solaris 9
> Database is Oracle 10gR2 on another Solaris 9 box
> Midtier is on Wintel 2003 IIS server (Only for requesters)
> ITSM (including Incident and Change) 7.0.02 patch 3
>
> I have been sending all kinds of loggings to BMC.  The first suggestion
> from BMC was to set Oracle-Cursor-Sharing to FORCES.  That didn't help.
>
> The other suggestion was to change a Veritas setting ("mincache=direct")
>
> on the database server.  But our DBA, UNIX. and Storage people all
> rejected the idea because 1) that fix is for bulk data import 2) they
> had
> very experienced with that setting, which produced high IO waits and
> worse
> overall daily performance.
>
> Thanks in advance for your help.
>
> Eric Zhang
> Sr. IT Consultant
> Entergy Services, Inc.
> (501) 377-5815
>
>
___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
> Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: URGENT - ITSM 7 performance issue - help needed

[Rick Cook]

Eric, it would help if you could tell us more about your environment, and
what system logging you've looked at in your performance evaluation.

Rick

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of ZHANG, ERIC L
Sent: Wednesday, August 08, 2007 9:26 PM
To: arslist@ARSLIST.ORG
Subject: URGENT - ITSM 7 performance issue - help needed

I post this earlier today but don't see it on the list.  I am trying again.
I apologize if you already saw this.

-Original Message-
From: Eric Zhang [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 12:21 PM
To: [EMAIL PROTECTED]
Cc: ZHANG, ERIC L
Subject: URGENT - ITSM 7 performance issue - help needed

Hello, all.

We have been struggling with ITSM 7 performance since it went live on 8/1.
The performance is getting worse and worse for all the operations:

search, create, and update.  At the begging, it's the creating incident that
took more that 40 seconds to complete.  Now it's all the operations,
primarily on Incident.  The incident ticket update can take up to 3 minutes
now.  We opened a critical ticket to BMC support but so far we haven't
received a solution that improves the performance.

Our configurations:

ARS 7.0.01 no patch on Solaris 9
Database is Oracle 10gR2 on another Solaris 9 box Midtier is on Wintel 2003
IIS server (Only for requesters) ITSM (including Incident and Change) 7.0.02
patch 3

I have been sending all kinds of loggings to BMC.  The first suggestion from
BMC was to set Oracle-Cursor-Sharing to FORCES.  That didn't help.

The other suggestion was to change a Veritas setting ("mincache=direct")

on the database server.  But our DBA, UNIX. and Storage people all rejected
the idea because 1) that fix is for bulk data import 2) they had very
experienced with that setting, which produced high IO waits and worse
overall daily performance.

Thanks in advance for your help.

Eric Zhang
Sr. IT Consultant
Entergy Services, Inc.
(501) 377-5815


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

URGENT - ITSM 7 performance issue - help needed

[ZHANG, ERIC L]

I post this earlier today but don't see it on the list.  I am trying
again.  I apologize if you already saw this.

-Original Message-
From: Eric Zhang [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 12:21 PM
To: [EMAIL PROTECTED]
Cc: ZHANG, ERIC L
Subject: URGENT - ITSM 7 performance issue - help needed

Hello, all.

We have been struggling with ITSM 7 performance since it went live on 
8/1.  The performance is getting worse and worse for all the operations:

search, create, and update.  At the begging, it's the creating incident 
that took more that 40 seconds to complete.  Now it's all the
operations, 
primarily on Incident.  The incident ticket update can take up to 3 
minutes now.  We opened a critical ticket to BMC support but so far we 
haven't received a solution that improves the performance.

Our configurations:

ARS 7.0.01 no patch on Solaris 9
Database is Oracle 10gR2 on another Solaris 9 box 
Midtier is on Wintel 2003 IIS server (Only for requesters)
ITSM (including Incident and Change) 7.0.02 patch 3

I have been sending all kinds of loggings to BMC.  The first suggestion 
from BMC was to set Oracle-Cursor-Sharing to FORCES.  That didn't help.

The other suggestion was to change a Veritas setting ("mincache=direct")

on the database server.  But our DBA, UNIX. and Storage people all 
rejected the idea because 1) that fix is for bulk data import 2) they
had 
very experienced with that setting, which produced high IO waits and
worse 
overall daily performance.

Thanks in advance for your help.

Eric Zhang
Sr. IT Consultant
Entergy Services, Inc.
(501) 377-5815

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: CMDB Performance Issue - Heads Up out there

[Rick Cook]

We're going to try that today, actually.  I'll report back with the effects.
 
Rick 
  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Tuesday, June 19, 2007 7:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB Performance Issue - Heads Up out there


** 
Look into the Oracle's Cursor Sharing for BMCR RemedyR Products white paper
on setting your cursor sharing to similar or force.
 
Ask your DBA if cursor_sharing is set in the init.ora.  If it is not then it
defaults to "cursor_sharing = EXACT".   Setting it to similiar or force will
help eliminate this issue.
 
Fred

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Tuesday, June 19, 2007 9:04 AM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB Performance Issue - Heads Up out there


** 
Our Oracle DBA noted what he thought was a design flaw yesterday - on
retrievals, the SQL isn't binding any of the variables (like form ID), so
it's having to re-fetch each of those each time, instead of having it
locally cached like a server variable.  That causes the searches to take FAR
longer than they otherwise would.
 
Rick 
  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Terry Bootsma
Sent: Tuesday, June 19, 2007 5:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB Performance Issue - Heads Up out there


** 
Roger interesting 
 
how many rows are in your BMC:CORE:BMC:BaseElement and
BMC:CORE:BMC_BaseRelationship table?  Are you on Oracle or SQLServer?
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Roger Justice
Sent: Monday, June 18, 2007 4:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB Performance Issue - Heads Up out there


** 

ITSM 7 CMDB 2.X each computer had 100-200 software items related and the
loading of the individual computer and the selection of the related items
tab was 1-3 seconds. Maybe it was improved.

__20060125___This posting was submitted with HTML in
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: CMDB Performance Issue - Heads Up out there

[Grooms, Frederick W]

Look into the Oracle's Cursor Sharing for BMC(r) Remedy(r) Products
white paper on setting your cursor sharing to similar or force.
 
Ask your DBA if cursor_sharing is set in the init.ora.  If it is not
then it defaults to "cursor_sharing = EXACT".   Setting it to similiar
or force will help eliminate this issue.
 
Fred



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Tuesday, June 19, 2007 9:04 AM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB Performance Issue - Heads Up out there


** 
Our Oracle DBA noted what he thought was a design flaw yesterday - on
retrievals, the SQL isn't binding any of the variables (like form ID),
so it's having to re-fetch each of those each time, instead of having it
locally cached like a server variable.  That causes the searches to take
FAR longer than they otherwise would.
 
Rick 


From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Terry Bootsma
Sent: Tuesday, June 19, 2007 5:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB Performance Issue - Heads Up out there


** 
Roger interesting 
 
how many rows are in your BMC:CORE:BMC:BaseElement and
BMC:CORE:BMC_BaseRelationship table?  Are you on Oracle or SQLServer?
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Roger Justice
Sent: Monday, June 18, 2007 4:49 PM
To: arslist@ARSLIST.ORG
    Subject: Re: CMDB Performance Issue - Heads Up out there


** 

ITSM 7 CMDB 2.X each computer had 100-200 software items related
and the loading of the individual computer and the selection of the
related items tab was 1-3 seconds. Maybe it was improved.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: CMDB Performance Issue - Heads Up out there

[Rick Cook]

Our Oracle DBA noted what he thought was a design flaw yesterday - on
retrievals, the SQL isn't binding any of the variables (like form ID), so
it's having to re-fetch each of those each time, instead of having it
locally cached like a server variable.  That causes the searches to take FAR
longer than they otherwise would.
 
Rick 
  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Terry Bootsma
Sent: Tuesday, June 19, 2007 5:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB Performance Issue - Heads Up out there


** 
Roger interesting 
 
how many rows are in your BMC:CORE:BMC:BaseElement and
BMC:CORE:BMC_BaseRelationship table?  Are you on Oracle or SQLServer?
 
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Roger Justice
Sent: Monday, June 18, 2007 4:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB Performance Issue - Heads Up out there


** 

ITSM 7 CMDB 2.X each computer had 100-200 software items related and the
loading of the individual computer and the selection of the related items
tab was 1-3 seconds. Maybe it was improved.




  _  

See what's free at AOL.com <http://www.aol.com?ncid=AOLAOF0002000503> . 
__20060125___This posting was submitted with HTML in
it___ 

__20060125___This posting was submitted with HTML in
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: CMDB Performance Issue - Heads Up out there

[Terry Bootsma]

I would suspect flawed design.

As I mentioned, if I copy/paste the SQL directly in SQL Advantage and run it
(looking at the Query plans), it estimates 5+ minutes to run.  So... I would
conclude that this is not a Remedy Server issue but a design issue.

Terry


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Rick Cook
Sent: Monday, June 18, 2007 4:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB Performance Issue - Heads Up out there


Terry, that's kind of disturbing, though it is probably functioning by
flawed design.

Just a thought - the Maximum Filters settings - are they high enough?  I've
seen that lock/crash a server before.

Rick

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Terry Bootsma
Sent: Monday, June 18, 2007 11:43 AM
To: arslist@ARSLIST.ORG
Subject: CMDB Performance Issue - Heads Up out there

* Confirmed by Remedy as RFE SW00269736 *

Environment: ITSM 6 , Asset management 6.0 patch 1470, with CMDB 1.1 Patch
004  on Remedy ARSystem 6.0.3 patch 020 and SQL Server 2000.  CMDB Design is
fundamentally the same for ITSM 7.X, thus would occur in this environment as
well.

Disclaimer: This performance issue is related to VIEWING the CMDB
information via the Remedy User Tool.  It does not occur when populating the
CMDB.

This situation occurs with a large amount of data populated in the CMDB.

The situation is as follows.  I have several Applications (AST:Application)
that are related to several computers (AST:ComputerSystem) through the
dependency relationship (BMC:BMC_Dependency).  For one application, there
are several dependency relationships that relate the Application to 3000+
computer systems (NOTE: I'm only creating one instance for an application
and relating that application to all computers that are running the
application.  I'm updating license counts accordingly).   If you're asking
how I'm relating 3000+ computers to one application (that's a lot of mouse
clicks!!), I'm keeping this information up-2-date via a custom interface to
SMS through EIE.

The situation is this, when a user (in the user tool) views this particular
application and goes to the related items tab to display the dependencies,
the user tool hangs while it tries to show the dependent computers, and the
Remedy ARSystem hangs while the system tries to update the table
OSRelationship_tbl.I'm forced to stop/restart the Remedy system in order
to re-establish processing.  If I view other applications that have 150
->300 computers related to an application, the table does get refreshed, but
it does take time (10 -> 30 seconds).  The threshold seems to be around the
400 to 500 relationship mark.

After a lot of investigation, I've come up with the following:

The OSRelationship_tbl on the Related Items tab(Note:This table is the same
table that is used on other AST forms that have relationships) on
AST:Application is refreshing itself from the view
AST_SearchFromBaseDependency which references AST_SearchFromBaseDependency1.
AST_SearchFromBaseDependency1 is a join between BMC:BMC_Dependency and
BMC:BMC_AssetBase.  The problem is that the JOIN criteria on
AST_SearchFromBaseDependency1 is an OR relationship.  This results in a
cartesian product between BMC:BMC_Dependency and BMC:BMC_AssetBase when
queries are performed against the table in SQL Server 2000 (I suspect it
would be the same in Oracle or any other DB).  Because the join relationship
on AST_SearchFromBaseDependency1  is an OR, a cartesian product is being
generated and no utilization of any index would solve this performance
issue.  Performance is not an issue when an object only has a few dependency
relationships or if BMC:BMC_AssetBase is fairly small, but when the opposite
is true, it causes the application to hang (I've turned on SQL logging and
the same is true if the SQL is issued directly to the database via SQL
Advantage.  The SQL will take 5+ minutes to run).  For the instance I am
talking about, I have 20,000 objects in BMC:BMC_AssetBase and 10,480 items
in BMC:BMC_Dependency.  The application that I am viewing has 3700 items in
BMC:BMC_Dependency  (ie. 3700 computers are dependent upon this application
(are running it).

I checked out the ITSM 7.X design, and the design is still, fundamentally
the same, with the AST:SearchFromBaseRelationship being an OR join between
BMC:CORE:BMC_BaseRelationship and BMC:CORE:BMC:BaseElement.  This problem
will also occur in this version as well.

Has anyone else out there experienced this issue ?  I've been forced to
write code to check on the number of dependencies that an object has, and if
over the 400 mark, to hide the related items tab and pop up an error message
so that we don't hang the server.  Any thoughts?

Terry


___
U

Re: CMDB Performance Issue - Heads Up out there

[Terry Bootsma]

Roger interesting

how many rows are in your BMC:CORE:BMC:BaseElement and
BMC:CORE:BMC_BaseRelationship table?  Are you on Oracle or SQLServer?


  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Roger Justice
  Sent: Monday, June 18, 2007 4:49 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: CMDB Performance Issue - Heads Up out there


  **
  ITSM 7 CMDB 2.X each computer had 100-200 software items related and the
loading of the individual computer and the selection of the related items
tab was 1-3 seconds. Maybe it was improved.






--
  See what's free at AOL.com.
  __20060125___This posting was submitted with HTML in
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: CMDB Performance Issue - Heads Up out there

[Roger Justice]

ITSM 7 CMDB 2.X each computer had 100-200 software items related and the  
loading of the individual computer and the selection of the related items tab  
was 1-3 seconds. Maybe it was improved.



** See what's free at http://www.aol.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: CMDB Performance Issue - Heads Up out there

[Rick Cook]

Terry, that's kind of disturbing, though it is probably functioning by
flawed design.

Just a thought - the Maximum Filters settings - are they high enough?  I've
seen that lock/crash a server before.

Rick

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Terry Bootsma
Sent: Monday, June 18, 2007 11:43 AM
To: arslist@ARSLIST.ORG
Subject: CMDB Performance Issue - Heads Up out there

* Confirmed by Remedy as RFE SW00269736 *

Environment: ITSM 6 , Asset management 6.0 patch 1470, with CMDB 1.1 Patch
004  on Remedy ARSystem 6.0.3 patch 020 and SQL Server 2000.  CMDB Design is
fundamentally the same for ITSM 7.X, thus would occur in this environment as
well.

Disclaimer: This performance issue is related to VIEWING the CMDB
information via the Remedy User Tool.  It does not occur when populating the
CMDB.

This situation occurs with a large amount of data populated in the CMDB.

The situation is as follows.  I have several Applications (AST:Application)
that are related to several computers (AST:ComputerSystem) through the
dependency relationship (BMC:BMC_Dependency).  For one application, there
are several dependency relationships that relate the Application to 3000+
computer systems (NOTE: I'm only creating one instance for an application
and relating that application to all computers that are running the
application.  I'm updating license counts accordingly).   If you're asking
how I'm relating 3000+ computers to one application (that's a lot of mouse
clicks!!), I'm keeping this information up-2-date via a custom interface to
SMS through EIE.

The situation is this, when a user (in the user tool) views this particular
application and goes to the related items tab to display the dependencies,
the user tool hangs while it tries to show the dependent computers, and the
Remedy ARSystem hangs while the system tries to update the table
OSRelationship_tbl.I'm forced to stop/restart the Remedy system in order
to re-establish processing.  If I view other applications that have 150
->300 computers related to an application, the table does get refreshed, but
it does take time (10 -> 30 seconds).  The threshold seems to be around the
400 to 500 relationship mark.

After a lot of investigation, I've come up with the following:

The OSRelationship_tbl on the Related Items tab(Note:This table is the same
table that is used on other AST forms that have relationships) on
AST:Application is refreshing itself from the view
AST_SearchFromBaseDependency which references AST_SearchFromBaseDependency1.
AST_SearchFromBaseDependency1 is a join between BMC:BMC_Dependency and
BMC:BMC_AssetBase.  The problem is that the JOIN criteria on
AST_SearchFromBaseDependency1 is an OR relationship.  This results in a
cartesian product between BMC:BMC_Dependency and BMC:BMC_AssetBase when
queries are performed against the table in SQL Server 2000 (I suspect it
would be the same in Oracle or any other DB).  Because the join relationship
on AST_SearchFromBaseDependency1  is an OR, a cartesian product is being
generated and no utilization of any index would solve this performance
issue.  Performance is not an issue when an object only has a few dependency
relationships or if BMC:BMC_AssetBase is fairly small, but when the opposite
is true, it causes the application to hang (I've turned on SQL logging and
the same is true if the SQL is issued directly to the database via SQL
Advantage.  The SQL will take 5+ minutes to run).  For the instance I am
talking about, I have 20,000 objects in BMC:BMC_AssetBase and 10,480 items
in BMC:BMC_Dependency.  The application that I am viewing has 3700 items in
BMC:BMC_Dependency  (ie. 3700 computers are dependent upon this application
(are running it).

I checked out the ITSM 7.X design, and the design is still, fundamentally
the same, with the AST:SearchFromBaseRelationship being an OR join between
BMC:CORE:BMC_BaseRelationship and BMC:CORE:BMC:BaseElement.  This problem
will also occur in this version as well.

Has anyone else out there experienced this issue ?  I've been forced to
write code to check on the number of dependencies that an object has, and if
over the 400 mark, to hide the related items tab and pop up an error message
so that we don't hang the server.  Any thoughts?

Terry


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

CMDB Performance Issue - Heads Up out there

[Terry Bootsma]

* Confirmed by Remedy as RFE SW00269736 *

Environment: ITSM 6 , Asset management 6.0 patch 1470, with CMDB 1.1 Patch
004  on Remedy ARSystem 6.0.3 patch 020 and SQL Server 2000.  CMDB Design is
fundamentally the same for ITSM 7.X, thus would occur in this environment as
well.

Disclaimer: This performance issue is related to VIEWING the CMDB
information via the Remedy User Tool.  It does not occur when populating the
CMDB.

This situation occurs with a large amount of data populated in the CMDB.

The situation is as follows.  I have several Applications (AST:Application)
that are related to several computers (AST:ComputerSystem) through the
dependency relationship (BMC:BMC_Dependency).  For one application, there
are several dependency relationships that relate the Application to 3000+
computer systems (NOTE: I'm only creating one instance for an application
and relating that application to all computers that are running the
application.  I'm updating license counts accordingly).   If you're asking
how I'm relating 3000+ computers to one application (that's a lot of mouse
clicks!!), I'm keeping this information up-2-date via a custom interface to
SMS through EIE.

The situation is this, when a user (in the user tool) views this particular
application and goes to the related items tab to display the dependencies,
the user tool hangs while it tries to show the dependent computers, and the
Remedy ARSystem hangs while the system tries to update the table
OSRelationship_tbl.I'm forced to stop/restart the Remedy system in order
to re-establish processing.  If I view other applications that have
150 ->300 computers related to an application, the table does get refreshed,
but it does take time (10 -> 30 seconds).  The threshold seems to be around
the 400 to 500 relationship mark.

After a lot of investigation, I've come up with the following:

The OSRelationship_tbl on the Related Items tab(Note:This table is the same
table that is used on other AST forms that have relationships) on
AST:Application is refreshing itself from the view
AST_SearchFromBaseDependency which references AST_SearchFromBaseDependency1.
AST_SearchFromBaseDependency1 is a join between BMC:BMC_Dependency and
BMC:BMC_AssetBase.  The problem is that the JOIN criteria on
AST_SearchFromBaseDependency1 is an OR relationship.  This results in a
cartesian product between BMC:BMC_Dependency and BMC:BMC_AssetBase when
queries are performed against the table in SQL Server 2000 (I suspect it
would be the same in Oracle or any other DB).  Because the join relationship
on AST_SearchFromBaseDependency1  is an OR, a cartesian product is being
generated and no utilization of any index would solve this performance
issue.  Performance is not an issue when an object only has a few dependency
relationships or if BMC:BMC_AssetBase is fairly small, but when the opposite
is true, it causes the application to hang (I've turned on SQL logging and
the same is true if the SQL is issued directly to the database via SQL
Advantage.  The SQL will take 5+ minutes to run).  For the instance I am
talking about, I have 20,000 objects in BMC:BMC_AssetBase and 10,480 items
in BMC:BMC_Dependency.  The application that I am viewing has 3700 items in
BMC:BMC_Dependency  (ie. 3700 computers are dependent upon this application
(are running it).

I checked out the ITSM 7.X design, and the design is still, fundamentally
the same, with the AST:SearchFromBaseRelationship being an OR join between
BMC:CORE:BMC_BaseRelationship and BMC:CORE:BMC:BaseElement.  This problem
will also occur in this version as well.

Has anyone else out there experienced this issue ?  I've been forced to
write code to check on the number of dependencies that an object has, and if
over the 400 mark, to hide the related items tab and pop up an error message
so that we don't hang the server.  Any thoughts?

Terry

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Performance Issue with Active Links- Reg.,

[Vinod Kumar]

Hi Murtuza,
Thanks for the response.
But those indexes that you have mentioned were for the T-Table behind the
HelPDesk form. THese indexes will  improve the response time when we open
the form using the AR User Tool.  but i am facing problems when i access the
Active LInks of HelpDesk using the AR Admin tool.

Please provide me if there is any other alternate solutions.

Thanks in Advance.

Regards,
Vinod





On 4/19/07, msb * <[EMAIL PROTECTED]> wrote:


Hello Vinod,

If you double-click the Helpdesk form, you will see a tab called Indexes
in
the Form properties window. There should be some indexes pre-listed there
on
the right hand side.

You can add more indexes here if your users search on specific fields.

You will also have to check in the database if the pre-listed indexes
actually exist. There is a KB article on how to do this.

-Murtuza.

>From: Vinod Kumar <[EMAIL PROTECTED]>
>Reply-To: arslist@ARSLIST.ORG
>To: arslist@ARSLIST.ORG
>Subject: Re: Performance Issue with Active Links- Reg.,
>Date: Thu, 19 Apr 2007 08:46:38 +0530
>
>Hi,
>I tried to understand more about OOTB index on the HelpDesk form but i
>couldnt progress in it.
>
>Can anyone please help me to understand what a OOTB Index is  , and how i
>can check if it has got corrupted? If so, how do i correct the corrupted
>indexes.
>
>THanks in Advance.
>
>Regards,
>Vinod
>
>
>
>
>- Original Message 
>From: Murtuza Bookwala <[EMAIL PROTECTED]>
>To: arslist@ARSLIST.ORG
>Sent: Saturday, 14 April, 2007 1:58:34 PM
>Subject: Re: Performance Issue with Active Links- Reg.,
>
>Hello Vinod,
>
>Last time I had this problem, I found that the OOTB Indexes on the
Helpdesk
>form had become corrupt.
>You can check that in the database.
>
>Regards,
>Murtuza.
>
>-Original Message-
>From: Action Request System discussion list(ARSList)
>[mailto:[EMAIL PROTECTED] On Behalf Of Rabi Tripathi
>Sent: Thursday, April 12, 2007 7:56 AM
>To: arslist@ARSLIST.ORG
>Subject: Re: Performance Issue with Active Links- Reg.,
>
>Vinod:
>It makes sense that Helpdesk form's objects open relatively slower than
>smaller forms'.
>
>The question is whether 100 seconds is reasobable for your setup or not.
No
>way to judge that without details of what you mean by...
>
>...from a "remote" machine
>
>What do you mean by "remote"? What's the link between the client and the
>server? Dialup, LAN, WAN? VPN?
>
>You essentially need to think of the link between your client and the
>server
>as a pipe with numerous links in series and figure out whether it's
>choking...your client PC, your local network, remote network, server
>(hardware, software setup, database)?
>
>Use basic elimination techniques to rule out what is
>*not* a problem and look at the remaining suspects more closely. For
>example, if access through Remedy User from the same client PC is rather
>fast, the network is likely not an issue. If access using Remedy admin on
>the server itself is fast, then server side stuff including database is
not
>an issue. Also, is it slow for others in your local network..for others
in
>some other network? You get the idea. Another important question is
whether
>it suddenly become slow or it has always been like this.
>
>If you want listers to point out the suspect, you will need to post
details
>of you client PC, the network, the server hardware, the database details,
>concurrent user load etc.
>
>The last time I saw unusually slow opening of objects was when somebody
had
>hacked into the underlying database to change the last modified date of
all
>the objects and set them to some future date by mistake.
>Very unusual issue, **most likely irrelevant to you**.
>
>Sorry, I can't tell you exactly what the issue is in your environment.
>There
>is no substitute to following basic troubleshooting steps.
>
>Regards.
>
>--- Vinod <[EMAIL PROTECTED]> wrote:
>
>>Hi,
>>We currently work on one of the customised HelpDesk application.
>>Whenever i open any active link of the HelpDesk form from a remote
>>machine, it takes around 90-100 seconds whereas when i open an
>>activelink of any other form in the same environment, it takes around
>>15 seconds.
>>
>>Taking 15 seconds for opening an object from a remote machine is
>>acceptable but 100 seconds is too high. I am trying to find out the
>>reason for the issue and i am looking for ways to improve the
>>performance, whenever i open the active links of our HelpDesk form.
>>
>>Please provide me with some insight/thoughts on what may be the reason
>>for such performance issue? Any suggestions or ideas for rectifying
>>the iss