Disk cluster size - how important is this for SQL Anywhere

[Former Member]

Also how might it relate to Page Size in SQL Anywhere.

Thanks!

[MarkCulp · Accepted solution]

Take a look at my answer to a similar question that asked about what NTFS allocation size should be used for an 8k database page size.

Short answer is that it doesn't really matter if you are not that concerned about getting optimal performance. If you want best performance and best probability that your file system is not going to corrupt your database file then it is likely best to match your page size to the file system page size (and natural disk sector size).... but you need to be careful if your file system sector size is too large (16K or 32K) since other effects can kick in - e.g. wasted cache memory due to using a page size which is too large for your database schema and application usage pattern. I.e. if your file system sector size is 16K or 32K then I would suggest that you do a performance evaluation between using a 16K (or 32K) database page size and an 8k (and/or 4K) page size.

[Former Member · Accepted solution]

Thanks, I did see and read that answer after posting! Now I need to do some leg work to see what DB page size is ideal for my case then select an appropriate cluster size from that.