Re: Memory issue on sybase ARS 6.0.1

2009-04-06 Thread Mahan, Janet L[EQ]
(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Darrell Reading Sent: Thursday, April 02, 2009 11:35 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Yep, never do a != on a status field. Also if you go into the admin tool and limit the number of records returned to 10k or so

Re: Memory issue on sybase ARS 6.0.1

2009-04-02 Thread Nicky Madjarov
r AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Grooms, Frederick W" Newsgroups: public.remedy.arsystem.general To: Sent: Thursday, April 02, 2009 11:16 AM Subject: Re: Memory issue on sybase ARS 6.0.1 Actually using NULL in a query should always cause a tabl

Re: Memory issue on sybase ARS 6.0.1

2009-04-02 Thread Darrell Reading
day, April 02, 2009 10:20 To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Memory size: 16384 Megabytes Memory grows to about 3932M or so and ARS dies The table has about 373k rows and approximately 350 tickets open The escalation will Run If: ( 'Trouble Ticket Status

Re: Memory issue on sybase ARS 6.0.1

2009-04-02 Thread Grooms, Frederick W
AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Memory size: 16384 Megabytes Memory grows to about 3932M or so and ARS dies The table has about 373k rows and approximately 350 tickets open The escalation will Run If: ( 'Trouble Ticket Status' != "Close

Re: Memory issue on sybase ARS 6.0.1

2009-04-02 Thread Grooms, Frederick W
Thursday, April 02, 2009 10:07 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 That is exactly what I am trying to do. The MTTR fields display in a table for the users but if the ticket is not modified they are not current so the escalation fires and modifies tickets that

Re: Memory issue on sybase ARS 6.0.1

2009-04-02 Thread Mahan, Janet L[EQ]
- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Darrell Reading Sent: Thursday, April 02, 2009 10:42 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 How much memory does your system have, and how large does the arsystem executabl

Re: Memory issue on sybase ARS 6.0.1

2009-04-02 Thread Grooms, Frederick W
org] On Behalf Of Nicky Madjarov Sent: Thursday, April 02, 2009 10:03 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Janet, 'Status'<"Resolved" in most of the database performs full table scan regardless if you have indexed on status or not. Given the amou

Re: Memory issue on sybase ARS 6.0.1

2009-04-02 Thread Mahan, Janet L[EQ]
. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Thursday, April 02, 2009 10:53 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 The question is what are you trying to update on

Re: Memory issue on sybase ARS 6.0.1

2009-04-02 Thread Nicky Madjarov
mance @ http://www.SpeedUpARS.com - Original Message - From: "Darrell Reading" Newsgroups: public.remedy.arsystem.general To: Sent: Thursday, April 02, 2009 10:42 AM Subject: Re: Memory issue on sybase ARS 6.0.1 How much memory does your system have, and how large does the arsystem

Re: Memory issue on sybase ARS 6.0.1

2009-04-02 Thread Grooms, Frederick W
April 02, 2009 9:23 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Ok, let me ask something else related to my issue. Does anyone have a recommendation of the best way to update all open tickets every 5 minutes other than an escalation? The escalation seems to fill the m

Re: Memory issue on sybase ARS 6.0.1

2009-04-02 Thread Darrell Reading
: Thursday, April 02, 2009 09:23 To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Ok, let me ask something else related to my issue. Does anyone have a recommendation of the best way to update all open tickets every 5 minutes other than an escalation? The escalation seems to

Re: Memory issue on sybase ARS 6.0.1

2009-04-02 Thread Mahan, Janet L[EQ]
- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, April 01, 2009 2:00 PM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Looking below it looks like you are on a Sun V240. What OS Version "

Re: Memory issue on sybase ARS 6.0.1

2009-04-01 Thread Mahan, Janet L[EQ]
nesday, April 01, 2009 2:00 PM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Looking below it looks like you are on a Sun V240. What OS Version "uname -a" and what is your "ulimit -a" values. Also check your disk space "df -k" Fred -Origin

Re: Memory issue on sybase ARS 6.0.1

2009-04-01 Thread Grooms, Frederick W
On Behalf Of Mahan, Janet L[EQ] Sent: Wednesday, April 01, 2009 11:27 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Any ideas? Janet Mahan -Original Message- From: Mahan, Janet L[EQ] Sent: Tuesday, March 31, 2009 2:18 PM To: Mahan, Janet L[EQ]; arsl...@listserv

Re: Memory issue on sybase ARS 6.0.1

2009-04-01 Thread Mahan, Janet L[EQ]
. -Original Message- From: Mahan, Janet L[EQ] Sent: Tuesday, March 31, 2009 2:18 PM To: Mahan, Janet L[EQ]; arsl...@listserv.rbugs.com Subject: RE: Memory issue on sybase ARS 6.0.1 Also get these errors: ARERR [160] Decompression has failed ARERR [300] Malloc failed on server Janet Mahan

Re: Memory issue on sybase ARS 6.0.1

2009-03-31 Thread Mahan, Janet L[EQ]
the recipient), please contact the sender and delete all copies of the message. -Original Message- From: Janet Mahan [mailto:janet.ma...@embarq.com] Sent: Tuesday, March 31, 2009 1:20 PM To: arsl...@listserv.rbugs.com Cc: Mahan, Janet L[EQ] Subject: Memory issue on sybase ARS 6.0.1 Does