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" <[email protected]> wrote: > ** > > Sweet... don’t think I knew this.. > > New feature?? > > Joe > > *From:* John Sundberg <[email protected]> > *Sent:* Monday, September 17, 2012 4:56 PM > *Newsgroups:* public.remedy.arsystem.general > *To:* [email protected] > *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 <[email protected]> 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 >> <[email protected]>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: >>> [email protected]] *On Behalf Of *Chris Kelly >>> *Sent:* Monday, September 17, 2012 10:51 AM >>> *To:* [email protected] >>> *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 [email protected] > 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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
