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.
This blog was created to help Program leads, solution architects and administrators of different enterprise solutions including ERP, CRM, SCM, WMS, PLM, Business Intelligence and many more.
Subscribe to:
Post Comments (Atom)
e-Commerce discount types
In the world of retail today every retailer is trying to find ways and be creative to attract online customers. To attract your attention an...
-
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...
-
I've filled out the survey and chose the functionalities I think would benefit a lot of industries. Below is a summary of the survey I s...
-
This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here . Most of the improvements were geare...
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