No - they won't work. :( Sorry...
-John On Mon, Sep 17, 2012 at 6:05 PM, Chris Kelly <ctopke...@gmail.com> wrote: > ** > > These are great suggestions But I an in 2012 and I need a solution > today.... > As you can tell I know nothing about remedy. So will adding the two lines > work? > > Any help is great, my future self says thanks also.... > > Chris > On Sep 17, 2012 4:26 PM, "Joe Martin D'Souza" <jdso...@shyle.net> wrote: > >> ** >> >> Sweet... don’t think I knew this.. >> >> New feature?? >> >> Joe >> >> *From:* John Sundberg <john.sundb...@kineticdata.com> >> *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"_ >> _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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
