Questions tagged [raid]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
1answer
28 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
270 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
27 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
43 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
185 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
53 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
165 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
414 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
137 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
6k 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
60 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
1answer
528 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
53 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
65 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
2k 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
66 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
127 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
639 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
661 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.