Questions tagged [raid]
The raid tag has no usage guidance.
36
questions
1
vote
1
answer
63
views
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 ...
- 19
0
votes
1
answer
68
views
Dell Server Raid 1 drive quick replacement with 2 exact copies
Apologies if I am posting this to the wrong place.
We are unfortunately having to handle our own server administration in-house and no one here is an expert at servers in any way! (we are web app ...
1
vote
0
answers
52
views
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 ...
- 3,476
0
votes
1
answer
114
views
From spinners to SSD (SQL Database)
I have a SQL Server database running on a virtualized Windows Server 2012 R2 (VMware ESXi). I have a task from Accountancy to boost the performance of the database. The database has about 70GB and the ...
- 1
1
vote
1
answer
311
views
Should I partition a database file for performance improvement if a file sits on RAID?
I read a lot about performance improvement if instead of a single large .mdf file you partition it by multiple (.ndf) files.
But I also found from documentation that the same improvement can be ...
- 697
2
votes
0
answers
867
views
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. ...
- 21
0
votes
1
answer
138
views
Corruption on MS SQL Database due to 1 failed disk on RAID 6
Why is that when a single disk fails from a RAID 6 setup MS SQL 2014 database corrupts with the following error:
DESCRIPTION: SQL Server detected a logical consistency-based I/O error: torn page (...
Jordan
5
votes
2
answers
1k
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....
- 1,283
5
votes
1
answer
684
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,141
-1
votes
1
answer
260
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 ...
- 1
8
votes
2
answers
1k
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&...
- 1,283
15
votes
4
answers
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 ...
- 159
-1
votes
1
answer
40
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 ...
- 1,315
0
votes
2
answers
3k
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 ,
...
- 103
1
vote
1
answer
153
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 ...
- 11