Upgrade/Installation Planning FAQ
The following are some frequently asked questions about upgrade and installation planning:
| Q1: | My company typically purchases hardware RAID 5 servers for SQL Server. However, I'm bringing up an application that is purely transaction based (lots of writes, updates, and deletes). Is RAID 5 the best hardware configuration from a performance standpoint for transaction-based systems? (Note: I want fault tolerance!) |
| A1: | When it comes to pure transaction-based systems with fault tolerance, a RAID 10 (disk mirroring) is better from a performance standpoint than RAID 5. RAID 5 is slower than RAID 10 when performing writes (because of the checksum computation and additional write), but faster than RAID 1 when performing ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
