question

HSever-0909 avatar image
0 Votes"
HSever-0909 asked DSPatrick answered

Write caching disable/enable

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,

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
0 Votes"
DSPatrick answered

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--


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
0 Votes"
DSPatrick answered

Just checking if there's any progress or updates?

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.