It was a filter that I modified before. Since you were talking about forms I opened a form, added a char field, turned on logging and saved it, then stopped logging. Started logging at 12:58:50 Hit save button maybe at 12:58:52 The first instance of VIEW is at 1:00:04 all actions completed by 1:00:12 It's moving a bit faster then normal because it's lunchtime here, morning time it's at a crawl compared to now. -------------
Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, January 16, 2008 12:34 PM To: [email protected] Subject: Re: Log SQL in Admin ** Sql logs will log all sql to the db from arserver. Chances are the wait time between the select statements you have above are because whatever is doing those queries is waiting on other things; this is all irrelevant to you original issue though. Find the logs relevant to your operation. If you are modifying a regular form, grep the logs for 'VIEW'. This will take you to the place in the logs where the db view is dropped/created. Axton Grams On Jan 16, 2008 3:09 PM, Wheeler, Dylan <[EMAIL PROTECTED]> wrote: ** Thanks for that Frederick, didn't think it would log admin changes. I tried it out and I've got almost a full minute on some Remedy Application Service queries. <Queue: Admin > /* Wed Jan 16 2008 11:55:27.9490 */SELECT T106.C1,C6 FROM T106 WHERE ((T106.C400123100 = '0') AND (T106.C6 > 0)) ORDER BY 1 ASC <Queue: List > /* Wed Jan 16 2008 11:56:24.1980 */SELECT TOP 1001 T8.C1,T8.C1,T8.C1 FROM T8 WHERE (T8.C8 = 'Dispatch') ORDER BY 3 ASC <Queue: Admin > /* Wed Jan 16 2008 11:55:27.9490 */SELECT T106.C1,C6 FROM T106 WHERE ((T106.C400123100 = '0') AND (T106.C6 > 0)) ORDER BY 1 ASC <Queue: List > /* Wed Jan 16 2008 11:56:24.1980 */SELECT TOP 1001 T8.C1,T8.C1,T8.C1 FROM T8 WHERE (T8.C8 = 'Dispatch') ORDER BY 3 ASC Both of these are from modifying two different filters, neither of which touches T106 which is OBJSTR:Class on my system. T106 only has 243 rows of data so no clue why it should take so long to return a result. ------------- Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, January 16, 2008 10:47 AM To: [email protected] Subject: Re: Log SQL in Admin ** I just looked and the SQL log on the server shows the Admin commands that are executed (at least on Unix with Oracle). Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan Sent: Wednesday, January 16, 2008 11:36 AM To: [email protected] Subject: Log SQL in Admin ** Is it possible to log the sql queries the admin tool makes when you modify a form? I'm having major lag issues when I try and update anything in my admin tool and it's frustrating the heck out of me. It takes anywhere from 10 - 60 seconds for it to commit when I hit the save button even on a minor modification to an active link. I believe it's because the remote sql server is bogging down but I can't prove it and I can't get the sql admins to look at it without any proof. I have zero access to the sql server so I'm stuck without something to get them to take a look. Ideas anyone? Windows 2003 ARS 6.3 MS SQL 2000 ------------- Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Direct: 949.509.4565 Fax: 949.509.7841 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
