|
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.
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?............
Temporary Stored Procedure is stored in TempDB database. It is volatile and is
deleted once connection gets terminated or server is restarted......
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......
Master database is system database. It contains information about server’s
configuration. It is a very important database and important to backup
Master.....
SQL Profiler is a tool that stores events from the server. SQL Profiler saves
the events in the trace file......
|
