Hi all,
Our supplier is upgrading our storage to VMAX LUN's and asked if we would consider formatting the disks to 64k.
We currently have 10.2BSp07 running a 4k database block size on 4k disks on windows server 2008.
I've just read the below:
Optimal NTFS block size for Progress 10.1C database? (Optimal NTFS block size for Progress 10.1C database?)
where RHD says:
I was wondering if this was still the case? I will argue to up the database block size to 8k. (we are going to 11.6.2 also! )
TIA
BS
Our supplier is upgrading our storage to VMAX LUN's and asked if we would consider formatting the disks to 64k.
We currently have 10.2BSp07 running a 4k database block size on 4k disks on windows server 2008.
I've just read the below:
Optimal NTFS block size for Progress 10.1C database? (Optimal NTFS block size for Progress 10.1C database?)
where RHD says:
AFAIK you can set the blocksize when you format a drive with NTFS.
The best: Database blocksize = Filesystem blocksize.
Never: Database blocksize < Filesystem blocksize !!!! (performance hit)
Might be dangerous: Databaseblocksize = n * Filesystem blocksize (Gus - wizard of wizards - once said that this might cause silent database corruption. Progress gives one block to write to the filesystem but the filesystem has to write more blocks - when something happens in between writing the blocks Progress might not be aware ...
AFAIK for Windoze and Linux best database blocksize is 4K, whereas 8K for Unix.
Therefor 4K is the winner on Windoze.
HTH, RealHeavyDude.
I was wondering if this was still the case? I will argue to up the database block size to 8k. (we are going to 11.6.2 also! )
TIA
BS