What is RAID (Redundant Array of Inexpensive disks)?


Interview questions

What is RAID (Redundant Array of Inexpensive disks)? Explain its level.

What is RAID (Redundant Array of Inexpensive disks)? Explain its level.
What is RAID controller technology?
What is RAID and what are different types of RAID configurations?

SQL Server RAID - March 04, 2009 at 18:00 PM by Rajmeet Ghai

What is RAID (Redundant Array of Inexpensive disks)? Explain its level.

RAID is a mechanism of storing the same data in different locations. Since the same data is stored, it is termed as redundant. The data is stored on multiple disks which improves performance. The drive’s storage is divided into units ranging from a sector (512 bytes) up to several megabytes. This is termed as disk stripping.

There are NINE types of RAID plus an additional non-redundant array (RAID-0). However, RAID levels 0, 1, and 5 are the most commonly found.

  • RAID 0: This level does involve stripping but no redundancy of data. Offers the best performance at the cost of NO fault tolerance.
  • RAID 1: This level is termed as data mirroring consisting of at least two drives that duplicate the storage of data. No stripping involved. Often used for multi user system for best performance and fault tolerance.
  • RAID 2: It involves stripping with some disks storing error checking and correcting (ECC) information.
  • RAID 5: Consists of 3 or more disks in a way that protects data against loss of any one disk.
  • RAID 6: Has stripped disks with dual parity.
  • RAID 10: uses both striping and mirroring.
  • RAID 53: Merges the features of RAID level 0 and RAID level 3

What is RAID controller technology?

RAID controller is used when one drive fails and the other is still running well. The controller will automatically rebuild the data from the other devices and restores the same to the crashed system. Hence the RAID controller technology, depending on the importance of the data, is used to restore the data automatically from the other systems.

SQL Server RAID - March 04, 2009 at 18:00 PM by Nishant Kumar

What is RAID and what are different types of RAID configurations?

RAID, Redundant Array of Inexpensive Disks, used to provide fault tolerance to database servers. We have 0 through 5 RAID levels that offers different levels of performance and fault tolerance.

Write your comment - Share Knowledge and Experience

SQL Profiler

What are the tasks performed by SQL Profiler?
How can you use the SQL Profiler to ensure database security?
How can you reduce the amount of data collected by a trace?
What is SQL Profiler?
When do you use SQL Profiler?............

Define temporary and extended stored procedure.

Temporary Stored Procedure is stored in TempDB database. It is volatile and is deleted once connection gets terminated or server is restarted......

What are the lock types?

Shared Lock allows simultaneous access of record by multiple Select statements. Shared Lock blocks record from updating and will remain in queue waiting while record is accessed for reading......

Describe in brief system database.

Master database is system database. It contains information about server’s configuration. It is a very important database and important to backup Master.....

Describe in brief SQL Server monitoring ways.

SQL Profiler is a tool that stores events from the server. SQL Profiler saves the events in the trace file......  


Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring