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.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
 
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
 
DcpKingCommented:
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
it seem it never suggest the SQL server to use RAID 5 or 6, but only RAID 1+0, how come ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
 
marrowyungSenior Technical architecture (Data)Author 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
 
marrowyungSenior Technical architecture (Data)Author 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
 
marrowyungSenior Technical architecture (Data)Author Commented:
Thanks you all.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.