Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Switching your RAID array from a RAID 5 to a RAID 10 solution. Each write IO results in two writes using RAID 10 vs. 4 for RAID 5 (100% more efficient with writes).
  • As long as the RAID controller has some form of battery backup, then switch its cache mode from Write-through to Write-back, as this setting increases the system's ability to handle write IOs by an order of magnitude.
  • Adding more cache memory to the RAID controller.

...

Scroll pdf ignore
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >