So you finally decided to upgrade to SQL Server 2008 but it's been awhile since you looked at options for your Raid configurations. Here's a summary of what your options are:
Raid 0 - data is spread in different disk (disk stripping) but lacks redundancy
PROS - performs well on read and write
CONS - Failure of disk means data is lost
Raid 1 - known as disk mirroring no disk stripping. Data is hosted on a single drive then copied to another drive for fault tolerance. Recommended for Transaction Logs.
PROS - Redundant so failure of a drive will not stop database access
CONS - Cost since you'll need to double the size of your disk.
Raid 5 - uses disk stripping with parity. Data is spread but also stores parity information so it can be used in case of disk failure. Best for read-based not many write operations. Also avoid for transaction log because it's primarily sequential write.
PROS - Fault Tolerance at a low price.
CONS - Write Performance. Additional time is required to compute parity info before it's written to disk.
Raid 10 - cross between Raid 0 and 1. Data is striped evenly accross all drives then mirrored.
PROS - Write performance is far superior than Raid 5 and read performance is similar to Raid 5. Offers Fault Tolerance.
CONS - Cost since you'll need twice the number of disk like Raid 1.
Subscribe to:
Post Comments (Atom)
Digital Transformation unleashed
You're the CIO/CDO sitting in your weekly update executive meeting with the CEO, CFO, COO, and others. You start the meeting with the pr...
-
The first time that you log in to Microsoft Dynamics GP 9.0, you can select to have default information that is specific to your job display... -
This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here . Most of the improvements were geare...
-
Did you hear about the latest trend in databases? If not then you should read this article about NoSQL or "not only SQL". NoSQL...
3 comments:
I was wondering if I could speak with the site admin or one of the authors. I was hoping that I could contribute something to the site. let me know if this is possible.
Locus Academy is an exclusive training centre for Microsoft Products. We have huge number of enquiries from Corporate and individuals on Microsoft Dynamics CRM 4.0 (Technical/Functional),Microsoft Dynamics Axapta 2009 (Technical/Functional) & Microsoft Business Intelligence (MSBI). Our class room (100% practical) training will make you industry experts and can challenge any implementation @ any level. Courses are designed to give students the best combination of skills, experience and training to gain employment with IT giants.
We are proud to deliver right-talents in IT industry [ http://academy.locusit.com ]
Our Features:
♦ Hands on Training
♦ Real-time industry experts from MNCs
♦ Case studies and real-world examples
♦ Customizable
♦ Lab exercises
♦ Mock Projects
♦ Interview Preparation
♦ Experts advice
Other Courses Training from Locus Academy
*Asp.Net *C# *VB.Net *SQL Server 2005 *VBA *MSBI(Microsoft Business Intelligence) *Share Point and all other Microsoft products.
Thanks for given information. this is very useful for me. Visit our Website
Post a Comment