Share
Report
105 I have a customer who has a LOT of open unapplied documents at any given time (300,000 plus records). Their apply history table contains well over 1 million records.
When they open the Apply Sales Documents window and select a customer, the wait time is AT LEAST 30 seconds. When they click the lookup button to select a payment record, the wait time is often over 60 seconds before anything is displayed. When closing the apply window, the wait time is again at least 60 seconds before the window will close.
Their server appears to be working at a very high performance level. They have sufficient RAM, their databases are configured according to the recommendations from Microsoft, we are running nightly check dbs, recompile, update statistics, etc. The databases themselves are set to auto-update statistics as well. Tempdb is sufficiently large and is set to auto-grow properly.
I have turned off the full-text indexing option on their databases, but this has had no effect on performance.
At this point I am looking for suggestions on how to make the apply process work faster for them. Is there a way to add indexes to the RM tables or some hotfix or service pack that has corrected this issue? They are not on the latest service pack, but I was unable to find any reference to this issue in the fix list on any service pack, so I am now wondering if there is something I can do at the database level to improve the record access time.
*This post is locked for comments
All responses (
Answers (
