What is RAID?

What is RAID?

- RAID stands for Redundant Array of Inexpensive Disks.
- There are six RAID levels 0 through 5 offering different levels of performance and providing the RAID fault tolerance to the database servers.

It can be created by two ways:
1. Hardware RAID
2. Software RAID

- All the types of RAID are based on striping, mirroring, parity.

- Striping is the splitting the flow of data into blocks of a certain size.
- Mirroring is a storage technique where the copies of data are stored.
- Parity is a storage technique which is utilized striping and checksum methods.

1. Hardware RAID:
- It is created using separate hardware.
- It allows user to create boot partitions.
- It supports hot-swapping.
- It handles errors better, since communicates with the devices directly.

2. Software RAID:
- It is one of the cheapest RAID solutions.
- It is created which is mostly based on the user's computer.
- It does not implement the hot-swapping.
Reasons of poor performance of query
No indexes. Excess recompilations of stored procedures. Procedures and triggers without SET NOCOUNT ON........
Ways to troubleshoot performance problems in SQL Server
SET SHOWPLAN_ALL ON, SET SHOWPLAN_TEXT ON, SET STATISTICS IO ON.......
Steps to secure an SQL Server
Use NT authentication. Use server database and application roles to control access to the data. Secure the physical database files using NTFS permissions.......
Post your comment