Sweet... don’t think I knew this..
New feature??
Joe
From: John Sundberg
Sent: Monday, September 17, 2012 4:56 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Querys that kill my system
**
You could go into ar.cfg
add the 2 lines :
ars_track_long_queries: true
ars_track_long_queries_min_length: 5000 # This is milliseconds - so all greater
than 5 seconds
Then -- restart server
Look for table called: "ARS_TRACK_QUERIES" (I think that is the name)…
Look in there -- it will tell
who
when
what
how long it ran
how many entries returned
what ip address
what client type and version
Pretty sweet feature… (wish I would have thought of it originally)
-John
On Mon, Sep 17, 2012 at 10:21 AM, Chris Kelly <ctopke...@gmail.com> wrote:
**
Thanks so very much. I am not a Remedy Admin so My admin says the
Unqualified searches is disabled.
I will work on getting the fields indexed asap.
The thing is we don't know who is running the queries... is there a way on
the remedy system that we could look at to see who is running this and stop it
when it is going on?
Chris
On Mon, Sep 17, 2012 at 9:09 AM, Maddala, Venkat <venkat.madd...@ncr.com>
wrote:
**
Hi Chris,
Here are the few things that you can do
1) Disable Unqualified searches on server
2) Index the most commonly used fields in search
3) Limit the free form searches by adding custom workflow
BTW is this for custom applications? Or OOTB?
HTH
Venkat Maddala
http://RemediesForRemedy.com
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Chris Kelly
Sent: Monday, September 17, 2012 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Querys that kill my system
**
Hello all.
I have a question for the group.
Our ARsystem 7.1 and what is going on is when someone runs a intensive
query my system comes to a standstill. what are a few things i would do to
stop this? or set it so if queries get approved before running????
Please help ...
Chris
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
--
John Sundberg
Kinetic Data, Inc.
"Your Business. Your Process."
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award
651-556-0930 I john.sundb...@kineticdata.com
www.kineticdata.com I community.kineticdata.com
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
