Tips on SQL 64K Clusters and Epicor SQL Services Database Bytes
Microsoft SQL likes to do all it’s input/output in 64k chunks, but Windows likes to format hard drives in 4K chunks called “clusters”. Studies have shown that formatting the volumes that store SQL databases and transaction logs benefit from 64k clusters – up to 35% better performance! To check what your cluster size is, open an Elevated Command Prompt and type “CHKDSK D:” (where D: is where your databases are stored). The line with “xxx bytes in each allocation unit” should say 65536, and not 4096.
If you find your server admin formatted with the default 4096 allocation unit, then changing is easy – just kick everyone out of Epicor, shutdown the SQL services and backup the entire volume. Then, reformat with 64k clusters and do a volume restore. Restart SQL services (and your Epicor Task Agent) and let the users back in!
Sound like too much for you to handle?
Give us a call or send us a message, our Database Admins’s would be happy to assist.
Have feedback or a specific questions, feel free to submit a comment in the form below.