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