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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
