Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [raid]

36 questions
15
votes
4 answers

RAID0 instead of RAID1 or 5, is this crazy?

I'm considering using a RAID0 setup for one of our SQL Server clusters. I'll outline the situation and am looking for why this may be a bad idea. Also if someone you have use cases, white papers or other documentation you can point me to on this…
zsqlman
  • 159
  • 1
  • 6
8
votes
2 answers

Why is it not recommended to use RAID 5 for a log file?

While reading SQL Server Query Performance Tuning written by Grant Fritchey, I found it difficult to understand the following part: avoid RAID 5 for t-logs because, for every write request, RAID 5 disk arrays incur twice the number of disk I/Os…
Rauf Asadov
  • 1,313
  • 14
  • 36
7
votes
1 answer

Difference between Replication and Erasure coding techniques

I hope I am asking in the right community, If not, any suggestion will be appreciated. I am doing a survey paper where I am doing a comparison between erasure coding and replication techniques. At this stage, I am comparing them regarding specific…
Krebto
  • 123
  • 1
  • 8
5
votes
2 answers

is there any point of moving tempdb files into different disk drive if all LUNs are from the same RAID pool?

According to best practices, it is recommended to move all tempdb (not just tempdb) files into different physical disk. I have a virtual server which had originally 4 LUNs from the same RAID 10 pool. By the help of volume manager, I converted those…
Rauf Asadov
  • 1,313
  • 14
  • 36
5
votes
1 answer

Continuously Adding SSDs to an existing PostgreSQL Server

An Ubuntu 18.04 server dedicated to running a PostgreSQL 11.2 server (with TimescaleDB extension) will be running out of disk space soon so new SSD disks will need to be added to the machine to support the growing database size. The data is…
Nyxynyx
  • 1,131
  • 6
  • 18
  • 29
5
votes
1 answer

Oracle ASM vs RAID 10

I have oracle ASM 11gR2 on oracle linux 5.8 and i want to install oracle database. I have some disks and i want to use the redundancy strategies of oracle ASM or RAID 10 . I do not know which one is better ? Oracle ASM redundancy or RAID 10 ?
saeed.sh
  • 216
  • 2
  • 6
  • 17
4
votes
1 answer

Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL

It's months that I'm trying to solve a performance issue with PostgreSQL. SYSTEM CONFIGURATION Our deployment machine is a Dell PowerEdge T420 with a Perc H710 RAID controller configured in this way: VD0: two 15k SAS disks (ext4, OS partition, WAL…
pietrop
  • 756
  • 1
  • 7
  • 16
3
votes
3 answers

Best practices for configuring the Drive/Filegroup setup for Microsoft SQL 2008

I am a software developer for a small company. I wish we had a dba but that is not on the cards at this point. I was working on migrating our 75GB SQL Server 2000 database to SQL Server 2008 R2. The new (Windows 2008 R2) server has 64GB RAM and 8 x…
RandyMorris
  • 131
  • 1
  • 5
2
votes
1 answer

SQL Hard Drive Config?

I am setting up new server and am a little confused in my research of HD configuration. My main question is : Is it recommended to have the Trans Logs and DB logs (ldf) on separate spindles or can they be on the same? Do Trans Logs and ldf logs…
PBK
  • 51
  • 1
  • 4
2
votes
0 answers

What is the recommended host and VM block sizes, and RAID ARRAY strip size for a PostgreSQL OLTP database?

What I learn is: PG block size >= ni * VM block size >= nj * host block size But what happens when the DB in a VM is on an SSD RAID ARRAY? The ARRAY strip size changes the game and puzzle me. What should be the strip size for an ARRAY of SSDs for an…
lessj
  • 21
  • 2
2
votes
1 answer

MSSQL database physical design: RAID or spreading filegroups across different physical drives?

I'm going to build a Microsoft SQL server database which could end up being more than 40 TB in size. There are some quite large tables in the DB with more about 1010 .. 11 records. Every table has typical primary key index. Also most of the tables…
Demo80
  • 21
  • 1
2
votes
1 answer

RAID 10 array configuration for SQL Server

I have a question regarding RAID 10 and SQL Server. My plan is to purchase an HP DL380 G9 with the 24 drive config. The question is how to break up the array. The drives will be divided between the 3 bays to even out the traffic on the controller.…
Fatty McButterpants
  • 23
  • 1
  • 3
1
vote
2 answers

MySQL RAID configuration

I attached 4 10GB disks to MySQL Server and I used RAID 0: but still MySQL performance is the same. Do I have to change configuration in my.cnf to let MySQL know about RAID 0? This are my mount results: This is not development box, it is my…
KJA
  • 111
  • 1
  • 3
1
vote
1 answer

Raid 0 nvme disk configuration is slower

I installed MySQL db for storing my simulation data in phd. First I used a pc with i7-8700 cpu, 24 gb ram and 1 TB nvme disk. Then I transferred data to a newer pc with i7-12700 cpu, 48 GB ram and 2x1 nvme 1 TB disk in soft raid0 configuration.…
HakanA
  • 29
  • 1
1
vote
0 answers

Is the recommendation to have different files on separate disks valid for SQL server in a SAN (RAID) network?

Link: https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-files-and-filegroups?view=sql-server-ver15#Recommendations To maximize performance, create files or filegroups on different available disks as possible. Put objects…
variable
  • 3,590
  • 4
  • 37
  • 100
1
2 3