November 10, 2008 at 2:31 pm
I have to install SQL Server on Window 2000. There are 6 hard drives, 2 will be used to install the OS with 0+1 RAID.
So I will have 4 to install the databases. The largest drive has 146 GB.
Should I put all system databases - master, msdb and model in one drive, tempdb in a second drive, user defined databases in the third drive and the transaction log in the fourth drives?
Which drive is good for backup?
Thanks
November 10, 2008 at 5:10 pm
Loner (11/10/2008)
I have to install SQL Server on Window 2000. There are 6 hard drives, 2 will be used to install the OS with 0+1 RAID.So I will have 4 to install the databases. The largest drive has 146 GB.
Should I put all system databases - master, msdb and model in one drive, tempdb in a second drive, user defined databases in the third drive and the transaction log in the fourth drives?
Which drive is good for backup?
Thanks
I think RAID 0+1 requires 4 disks. Do you mean RAID1?
None of the other disks will be redundant? I would be very nervous about stand alone disks.
If you have to use stand alone disks, I would keep my backups on the RAID disks.
November 13, 2008 at 6:47 am
Place the tempdb on the RIAD 1+0 to increase throughput. Then the data files on RAID 1+0 also. The backups can go to RAID 5.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 13, 2008 at 7:49 am
The_SQL_DBA (11/13/2008)
Place the tempdb on the RIAD 1+0 to increase throughput. Then the data files on RAID 1+0 also. The backups can go to RAID 5.Thanks!!
How do you propose doing 2 RAID 10 arrays (each requiring minimum 4 disks) and 1 RAID 5 array (requiring minimum 3 disks) with only 6 drives?
Loner: How active is this system? How much TempDB activity? How frequent are the modifications to the user databases and how many are there?
How critical are these databases? How much down time can be tolerated if a drive fails?
Where are you planning on putting the backups?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 13, 2008 at 7:59 am
GilaMonster (11/13/2008)
The_SQL_DBA (11/13/2008)
Place the tempdb on the RIAD 1+0 to increase throughput. Then the data files on RAID 1+0 also. The backups can go to RAID 5.Thanks!!
How do you propose doing 2 RAID 10 arrays (each requiring minimum 4 disks) and 1 RAID 5 array (requiring minimum 3 disks) with only 6 drives?
I thought I was answering 'what is the Best disk configuration for installing the database'. I see Loner has just 6 disks :hehe:
Thanks for the catch Gila...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 13, 2008 at 9:55 am
There are a lot of activity in the tempdb.
Right now my plan is put OS in one disk, all data files in another disk and they both configure to RAID10.
I was going to put log file in another disk and tempdb on its own disk but my network administrator told it does not have enough space to put in RAID 10 in both disks so I plan to put the log file and tempdb both on the same disk with RAID 10.
The backup will be on the OS disk.
Let me know if it is ok.
November 13, 2008 at 9:58 am
Loner (11/13/2008)
I plan to put the log file and tempdb both on the same disk with RAID 10.
Not a good idea if there's a lot of TempDB activity.
How busy are the databases and how many are there?
How much downtime is tolerable in the case of a drive failure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply