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: arslist@ARSLIST.ORG
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"
<>