Hi Randy, Have you tried capturing api+sql (combined logs)?
My experience is that the combined logs gives a better insight. Best Regards, Uday Joshi Delivery Manager - BSM Tech Support Technology Infrastructure Services - BSM Unit ------------------------------------------------------------------- Wipro Technologies, Hinjewadi, Pune 411057 India Tel: +91 20 39104092 VOIP 842-5103 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mckinnish, Randy Sent: Thursday, September 18, 2008 11:45 PM To: [email protected] Subject: arimportcmd question ** Greetings listers, We recently swapped our application server as the older was at end of lease. This was a like for like swap except that the newer box has twice the processing power of the old one. Everything seems completely normal but one thing; our nightly data imports (from various sources) have slowed to a crawl. For example, I have a nightly load of sector information of around 19k-20k records. This import used to load in around 14-15 minutes but is now taking better than 2 hours. I have tried various logging to try and catch the problem but so far I have found nothing. The speed issue (or lack thereof) seems to be the same whether it's running from the command line or through the actual import tool. None of the files have changed in size or format, the scheduling of the imports is the same as it was on the old server. Has anyone ever experienced anything like this? Thank you. AR Server 6.3 P23 Win 2003 MSSQL 2000 Randy Mckinnish Technical Systems Developer Compass Group The Americas Division DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<ATSLogo.JPG>>
