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