Write caching disable/enable

Question

On one environment running SQL 2014 Ent, I found in Win 2012 for each drives the Write caching is disabled. The environment is used for DSS, typically running large queries and transactions. I have seen old recommendations to leave this disabled, which we kept in the past Now the system is not HDD based, but our storage is SSD based. Wondering if the recommendations to disable write caching still stands for the new systems, or any experience that you have for actually improving the performance if enabling write caching.

Thank you,

Answer 1

It's probably more a question of the disk controller. It should have some battery backup. These batteries are used to protect the contents of a disk controller's write cache from being lost, in the event of a power-outage.

--please don't forget to upvote and Accept as answer if the reply is helpful--

Answer 2

Hi,

Not familiar with the Write caching of the disk drive, please check the following articles if help.
https://support.microsoft.com/en-us/topic/information-about-using-disk-drive-caches-with-sql-server-that-every-database-administrator-should-know-7e5e74c5-e244-1680-b0d2-793cf69dcc00
https://longwhiteclouds.com/2017/01/05/disable-windows-disk-write-cache-for-data-integrity-and-better-performance/

Answer 3

Just checking if there's any progress or updates?

--please don't forget to upvote and Accept as answer if the reply is helpful--