Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
 Posted - 2008-06-30 : 14:26:24
|
| I got this is a document from a vendor:"For maximum performance, Microsoft recommends disabling write caching on all SQL Server disk drives."I have heard of disabling write caching for data safety, but never for performance reasons. Anyone ever hear of disabling write caching for SQL Server performance? It seems counter-intuitive to me, and I would not be surprised if this vendor was just dead wrong again.CODO ERGO SUM |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-30 : 14:50:58
|
| Check this out:http://www.sql-server-performance.com//tips/hardware_tuning_p4.aspx |
 |
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-06-30 : 15:15:16
|
| We have physical drive write cache disabled, which is the default setting on our HP smart array controllers. As per HP, the physical drive write cache should be disabled as it is not battery-backed.Maninder |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-06-30 : 15:20:22
|
| I understand that you might want to disable write caching for safety, but has anyone ever heard of disabling it for performance reasons?This seems to say the opposite:http://support.microsoft.com/kb/86903CODO ERGO SUM |
|
|
|
maninder
Posting Yak Master
100 Posts |
|
|
Haywood
Posting Yak Master
221 Posts |
|
|
|
|
|
Disabling Write Caching