DB Block Size

  • What is the recommended block size of operating system on dss systems?

    Also what is the recommended block size of oltp systems?

  • Assuming you mean the allocation unit size defined when you format a Windows drive then it will depend on the workload but 64 KB is usually a good place to start.

    Use SQLIO and test with your workload and underlying disk subsystem to find the optimal config.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply