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?