Write-Caching On or off? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Write-Caching On or off?

We have a 2005 cluster/san with write-caching turned on. It has the latest and greatest H/W. What’s the latest advice on running SQL Server 2005 with write-caching on. Yes, it has a battery backup. It should differ from years past,where we’d always turn it off, no? So, ON/OFF? tia
there are alot of opinions,
best to run the test scripts in my post, or use IOMeter or the MS utility SQLIOStress http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=16995

]]>