also funny you say this, because my Remedy admin just came to me and and said there was some settings that he never herd of that can be made in AR.config that will track Long queries ..... LOL Thanks Guys
On Tue, Sep 18, 2012 at 6:46 AM, Chris Kelly <ctopke...@gmail.com> wrote: > This is true.... But its still funny.... > > > On Tue, Sep 18, 2012 at 6:41 AM, David Durling <durl...@uga.edu> wrote: > >> ** >> >> Just to add for anyone who casually followed this & didn’t get it, John >> was joking and “saying wouldn’t it be nice if there were something like >> this”, but:**** >> >> ** ** >> >> There is NOT an ars_track_long_queries or >> ars_track_long_queries_min_length for ar.cfg.**** >> >> ** ** >> >> Hope you don’t mind me explicitly adding that, John – but I got a little >> confused in there… could imagine someone looking this up in the archives & >> being frustrated when it didn’t work…**** >> >> ** ** >> >> David**** >> >> ** ** >> >> David Durling**** >> >> University of Georgia**** >> >> ** ** >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg >> *Sent:* Monday, September 17, 2012 8:43 PM >> >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Querys that kill my system**** >> >> ** ** >> >> ** 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**** >> >> **** >> >> **** >> _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"
