Performance issue: Navision 3.7 and Native DB disk read rate

Sundance
Sundance Member Posts: 5
edited 2008-05-21 in NAV/Navision Classic Client
HI, a quick question, I hope someone can help me.

We have a Navision 3.7 on native DB, DB size 75 Gb, located on Raid1 (mirror), on 2x 125G SAS 15kRPM HP HDD-s.

These are FAST. Copying to/from the RAID array runs at about 25-30 Mbytes/sec. Not bad. Of course, sequential reading is fast.

However, Navision DB reading (via the service) is NEVER more than 1-1.2 Mbytes/sec! I also tried to create "test" reports that try to collect data from parts of the DB which I think is quite "sequentially readable" (i mean it's not fragmented) but no, the read rate is NEVER, ever more than 1.2 Mbytes/sec, which is just odd.....

Is there any reason to this? Did I miss something in the config? (DBMS cache is 1G, commit cache is on, device write cache is off (Win2k3 does not allow me to change this).....

Thanks in advance....

Comments

  • Malajlo
    Malajlo Member Posts: 294
    1) optimize database
    2) defragment disk

    Reading 1.2 Mbps could be network botlleneck (100MBps).
    What are your readings if you read database in single-user mode (directly opened, so you have to make a hotcopy of database)?
  • Sundance
    Sundance Member Posts: 5
    1. done
    2. how? :shock: Disk has 1 file on it (database.fdb)

    network: no. all tests were done locally.
    Single-user mode opening from client: 1.2 Mbyte/s also....
  • bbrown
    bbrown Member Posts: 3,268
    Split the database into multiple partitions (files) and place each on it's own RAID 1 array. I would split a 75 GB database io a minimum of 4 files.
    There are no bugs - only undocumented features.
  • Sundance
    Sundance Member Posts: 5
    That means 4*2 HDD's, am I alright?

    Sadly, the server can only handle 6 HDDs (we curently haver 2 for SYS, 2 for DB)....
    We might need a SAN.....
  • bbrown
    bbrown Member Posts: 3,268
    Sundance wrote:
    That means 4*2 HDD's, am I alright?

    Sadly, the server can only handle 6 HDDs (we curently haver 2 for SYS, 2 for DB)....
    We might need a SAN.....

    Yes, that is right. But also remember that is a minimum suggestion. If you need to add disk to suppor that then also consider expansion.

    Or maybe it's time for a new server. I would go for DAS over SAN with the native database. There are a number of servers out there that hold a fair number of drives. Another option is to add external DAS to the existing server.
    There are no bugs - only undocumented features.
  • bbrown
    bbrown Member Posts: 3,268
    Sundance wrote:
    We have a Navision 3.7 on native DB, DB size 75 Gb, located on Raid1 (mirror), on 2x 125G SAS 15kRPM HP HDD-s.
    ....

    I'm not familiar with HP making a 125 GB SAS drive (is that the formated capacity?). Of course they may make some products for other countries.

    Don't use such large drives. Go with more, smaller drives.
    There are no bugs - only undocumented features.
  • Sundance
    Sundance Member Posts: 5
    bbrown wrote:
    Sundance wrote:
    We have a Navision 3.7 on native DB, DB size 75 Gb, located on Raid1 (mirror), on 2x 125G SAS 15kRPM HP HDD-s.
    ....

    I'm not familiar with HP making a 125 GB SAS drive (is that the formated capacity?). Of course they may make some products for other countries.

    Don't use such large drives. Go with more, smaller drives.

    OKay, my mistake, 150G :)
    OK, I'll consider changing to (approx) 8-10 smaller drives.
    Thanks for your help!
  • kriki
    kriki Member, Moderator Posts: 9,121
    Sundance wrote:
    However, Navision DB reading (via the service) is NEVER more than 1-1.2 Mbytes/sec! I also tried to create "test" reports that try to collect data from parts of the DB which I think is quite "sequentially readable" (i mean it's not fragmented) but no, the read rate is NEVER, ever more than 1.2 Mbytes/sec, which is just odd.....
    I think it is not that odd.
    The Navision DB is NOT like a SQL DB.
    SQL puts all the data together based on the clustered index. And if you don't have a clustered index, SQL puts the data where it happens to be fastest to write it.
    The Navision works like that. The Navision-DB is a large heap. The records of 1 table are not necessarily together on the disk.
    So even if you read a table, the disk is not doing a sequential read, but is doing random reads on the disk.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • David_Singleton
    David_Singleton Member Posts: 5,479
    There is a Vision Navision_Server_Configuration.vsd that gives a suggestion for how to configure a Native NAV server.
    David Singleton

Categories