According to this Microsoft article, caching is not recommended on disks hosting SQL/Server log files. If the workload is heavily utilizing the underlying disks (any other application than SQL/Server), disk caching should also be set to none.

Please refer to for more information.

To change the value:

  1. Go to the specific instance

  2. Select disks

  3. Click on the name of the data disk

  4. Change host caching to the specific value

  5. Click save

When tested on both cluster nodes with large numbers of files copied onto a 100GB volume, no degradation was detected. We also performed switchovers and paused and continued the mirror and no degradation was detected.


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment