Hi, NAV5 with file database here.
a report runs for about 100 seconds on old HW with 10K HDDs and Win Server. The repotr is just doing some filters and iterations on some tables.
I have upgraded to a server several generations newer with shining CPU and memory, brought in plenty of SSDs, split database in files among them and guess what- it runs 180s in average now:(
However, I can't find the bottleneck - drives usage 5%, same for memory, cpu and network. Everyone is speaking about drives, but there is no big difference if I use 1 or 3 SSDs or even 15K HDD.
I just can't find out what's slowing it down.
Any ideas please?
Guessing is the worse thing you can do. investigate the actual performance using something like SQL Profiler or the NAV performance analyzer that was available back then. Or perhaps both.
I think the bottleneck could be on the client side, the report uses a lot of caching and virtual tables and using better CPU makes some difference. However, it could still be better, and the CPU core making the calculations is not getting used like it could.
The performance analyzer does not work with the native db. I don't recall what (if any) performance tools were available for that db. Honestly, it has just been too long.
How is performance for the rest of the system?
RIS Plus, LLC
MVP - Business Apps
The Server runs on 3 pairs of SSDs in RAID1. Yeah, I wish we could switch to SQL, but that would cost a lot- we have bunch of custom code that would need changes.
Not much difference. I think I got it where's the bottleneck though- one of the prcessor cores shows 100% usage while running the report. So I need the highest single core performance cpu to make it as fast as possible.
That old database did not support multiple cores. It was also limited to only 1 GB of memory. Performance was all about disk i/o.