Increase invoice posting performance

dietmarruef

Hello folks,

I have currently a customer project in which it is necessary to post 150.000 invoices in <= 6 hours. We have very well servers and a storage system with raid 10.

So the hardware performance shouldn't be the problem. I need now to increase performance on the software side. I have some ideas but it would be very helpful to hear something from you guys. We are using SQL Server 2005 and NAV 5 SP1.

Please send me some suggestions.

Thanks in advance,

Dietmar

DenSter

dietmarruef wrote:

We have very well servers and a storage system with raid 10. So the hardware performance shouldn't be the problem.

That's not always the case though. Good servers and a RAID10 storage system good of course, but it's much more important that it is all set up correctly, that your database files are stored properly. How many processors, what type of processors, how much memory, what kind of network infrastructure.

You are talking about a batch job, or do you have a team of people posting invoices manually? Over 6 hours that translates to about 42 invoices a minute. Depending on how many lines and dimensions, customizations, things like that it depends what your strategy would be.

For sure you could tune your indexes to speed up write performance. You could defragment indexes. You don't have to worry about SIFT tables with 5.0 SP1. There are many discussions about this type of issue already posted.

Marije_Brummel

The best solution is to perform a benchmark. We do this together with HP and Microsoft in the HP lab's where a special NAV room is reserved.

Please contact us for more information. Doing a benchmark will prove if it works or not.

Contacts:

* ludo -at- sqlperform.be
* mknevel -at- microsoft.com