is there any guidance on how to size NAV14/BC SQL servers or how to benchmark good or poor performance? A customer asked us to analyze some kind of poor performance on their NAV14 production environment. They are complaining about slow general ledger journal import from csv and slow journal posting.
On an isolated test system I was able to tune the import of 3k rows to 36 seconds and post (check lines, check balance, post, delete) the 6k journal lines in 270 seconds, which breaks down to ~10ms for importing a row and ~78ms for posting a line. From analyzing waits and locks, there is absolutely no bottleneck in storage, memory or cpu.
The customer uses to import journals with 50k rows and "feels", that this takes too much time. So I am trying to find out which are good measures for this task.
Is there any advice you can give me?
I am very experienced in ERP systems, especially with AX, but I am new to NAV. I also don't know if the journal import functionality is standard or customized by the implementation partner.
And just to say: I was wondering if it's common use in NAV to post such large journals in a dialog. In AX we mainly imported journals with batch jobs and queued them for posting at night or whenever nothing is to do...
I would be thankful for any advice