In 7604 it works with thread logining Enable Thread Log and add following line in Ar.cfg and restart services Large-Result-Logging-Threshold: 90000 Ravi
Date: Mon, 17 Sep 2012 15:58:10 -0500 From: john.sundb...@kineticdata.com Subject: Re: Querys that kill my system To: arslist@ARSLIST.ORG ** So sorry about that last email -- my time travel machine brought me back to 2012 -- when I could have sworn I typed in 2021… My bad. Check for the new feature in 2018 or so -- I think that was it. Now this is weird -- who invented the feature??? -John On Mon, Sep 17, 2012 at 3:56 PM, John Sundberg <john.sundb...@kineticdata.com> wrote: 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 SundbergKinetic 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 -- John SundbergKinetic 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"