The following key points highlight some considerations for host caching:
- Use the none caching mode for disks on which logs are stored, because logs will do intensive write operations Also, there is no benefit to using the read-only mode for logs. Therefore, none is the best fit in such a situation.
- Use the read-only caching mode for disks on which the SQL data needs to be queried frequently from the SQL database because that will help to lower the latency and data retrieval.
- Do not use read/write just for any applications, because the data is cached in the VM memory, and whenever a crash happens to the VM, the data will be lost. So, you have to read more about the application you are hosting in your VM to know which ...