Questions tagged [raid]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
4
votes
2answers
96 views

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....
4
votes
1answer
65 views

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 ...
-1
votes
1answer
57 views

how can I solve RAID 5 corrupted data? [closed]

I installed Windows Server 2012 on my server using RAID 5. But a problem occurred on my server. I extracted the data from 10 hard disks with data recovery. When I attached the extracted data files in ...
8
votes
2answers
760 views

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

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&...
14
votes
4answers
5k views

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 ...
-1
votes
1answer
30 views

Raid Reconfiguration of SQL Server 2016 Box

I did raid reconfiguration of SQL Server 2016 box. All my systems databases files (mdf and ldf) are in D drive and SQL Server installation also is in D drive and i have them intact. I have lost user ...
0
votes
2answers
1k views

Raid 1 or Raid 1+0 for SQL Server Architecture

We are looking at new servers. Today our SQL Servers are built as follows: C/D on RAID 1 , E : Tempdb on RAID 1, F:log files on RAID 1 , G : Catalog data on RAID 1 , H: model data on RAID 1 , ...
1
vote
1answer
32 views

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 ...
1
vote
1answer
46 views

Dead Raid Card SQL Server Running in Memory

Wanted some opinions, on a predicament I’m currently facing. I just got thrown with this mess.. SQL Server database files saving to Raid volume, long story short raid card died so volume is not ...
-2
votes
2answers
358 views

RAID 5 configuration with two drives [closed]

I am new into RAID implementation. I have researched on RAID and learned about RAID levels. I have to install SQL Server into one of the server(server have two drives currently). I am told by ...
0
votes
0answers
57 views

Very slow disk readind on postgres server

I hava a server for postgres only, its very slow reading on hd, something about 16mb/s or less, checked in iotop while a server overload. Two scsi disks, i have to check every information by ssh, my ...
1
vote
1answer
178 views

SQL Server 2012 Rebuild RAID Array

We had a bunch of disks fail in the RAID 10 that holds the data, logs, and backups drives on a SQL Server 2012 on Win 2012R2 OS. The OS and DB Server instance are in a separate RAID array. Working ...
6
votes
1answer
1k views

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 ...
1
vote
3answers
169 views

postgres backup with raid1

I've found nothing relevant on the internet about backing up postgres DB with raid1. So here's my question My sys admin thinks that backing up the raid1 disk ,on which a Postgres database is sitting, ...
1
vote
1answer
7k views

MS SQL Server 2016 Oprimal Disk Configuration [closed]

New server build for SQL SERVER STANDARD 2016 install. Total of 12 disks: 6 standard 15K HDs and 6 SSDs. This is the disk setup I am going for. Could this setup be improved on, if so how what would ...
0
votes
1answer
71 views

In a data warehouse with small amount of writes, would RAID 1 be better than RAID 1+0? [closed]

We are using HP Vertica database 7.2 community version. 300GB of data on one node. Thats a small amount of data. HP officially recommends RAID 1+0. https://community.dev.hpe.com/t5/Vertica-...
0
votes
2answers
623 views

Is it good idea to use RAID 1 mirroring to back up database content

I'm working on web hosting project. The planned system structure is going to be like this: one main hard-drive will contain the binary of mysql. A second hard-drive will contain the datadir the ...
0
votes
1answer
54 views

Raid Configuration for MS SQL server [closed]

Please Help... What are the best RAID configuration for MS SQL server. High availability, redundancy and recovery are require. All I need is best performance. cost is not a factor for me but a 500-800 ...
0
votes
1answer
73 views

Suitability of mysql on a raid 5 server with raid card [duplicate]

I would like to ask is mysql ok to run a on a raid 5 server. The raid is done using hardware raid and not software. I saw some older links like this Is raid 5 suitable for a mysql installation? which ...
2
votes
1answer
3k views

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 ...
1
vote
0answers
67 views

Design of hard drive RAIDs

My task is to reconfigure a main server that houses the company's applications and data. The server is capable of handling everything. I wanted to find out if anyone has a suggestion on the best ...
1
vote
1answer
130 views

How to get postgres to resume processes after it hangs when the RAID drive hosting the tablespace times out

Nearly once per day I'm getting a timeout that shows up in console like: 7:1:36 PM kernel: Areca RAID volume scsi command timeout (target=0 lun=0) which corresponds exactly to when all postgres ...
5
votes
1answer
722 views

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 ...
4
votes
1answer
1k views

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:...
0
votes
0answers
27 views

I/O contention on RAID disk [duplicate]

I found all of the Oracle data files including redo, control, system, index and everything are in just one directory. That directory is on Raid5 disks. In this case do I need to do something for ...
2
votes
1answer
675 views

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 ...
1
vote
2answers
2k views

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 ...
3
votes
3answers
4k views

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 ...
-3
votes
1answer
91 views

What is Better SQL Server Configuration? [closed]

First think : MDF and LDF separate on raid 1 Second think : All in one raid5.