Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 470
  • Last Modified:

The MS SQL server data volume

Dear all,

Any suggestion on the RAID level MS SQL server master, msdb, model, tempdB, user database should use ?

Sequencial data pattern should use RAID 10 ?

DBA100.
0
marrowyung
Asked:
marrowyung
  • 4
  • 2
2 Solutions
 
DcpKingCommented:
0
 
marrowyungAuthor Commented:
it seem it never suggest the SQL server to use RAID 5 or 6, but only RAID 1+0, how come ?
0
 
Scott PletcherSenior DBACommented:
RAID1 or RAID10 for tempdb (or even RAID0 if you feel you can risk it).

RAID10 for log files for databases.

RAID5 or RAID10 for data files for databases.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
marrowyungAuthor Commented:
for master dB, msdb and model, RAID 1 or RAID 10 as they don't change frequently.

RAID 10 for log and tempdB.

for statices data tha't don't have any change, like reporting data, RAID 5.

For dynamic data that change everyday, every minutes, RAID 10 also, right?\
0
 
Scott PletcherSenior DBACommented:
msdb typically changes quite frequently, as job statuses are updated.

I don't see any reason to distinguish master and msdb from other dbs.

model will indeed likely change extremely rarely.

tempdb is, of course, a special case because of the extremely large activity on it.


yes, raid5 is typically better for data that is read much more often.  then again, almost all db data is read much more often than it is inserted/updated.
0
 
marrowyungAuthor Commented:
"then again, almost all db data is read much more often than it is inserted/updated. "

how can you know ? analysis data always invole a lot of read and insert and delete.
0
 
marrowyungAuthor Commented:
Thanks you all.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now