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,