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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
