The problem we face is posting performance issue, once the problem occur all posting will very slow, one invoice with 7 lines might take more than 3 mins to post. We are now resolve the problem by restart DB server then everything back to OK but we face this situation nearly once a week.
I would like to know what root cause is and how to prevent this situation, please kindly assist.
My customer had more than 22,000 sales invoice line per day and currently DB size is over 100G with 9 months operation. They are run Navision 4.0 on SQL2000. We are running on SAN and I think hardware is not issue.