Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 New server, working out disks..

Author  Topic 

aberbotimue
Starting Member

26 Posts

Posted - 2009-02-25 : 16:40:50
Hi all,

I have a new server, all shiney and ready for me to scratch it getting it into a corner of our data center.. or should i call it a cupboard with aircon!

I have 6 disks to play with.. and was considering a set up somthing like this..

disk 1 and 2 18 gig, mirrored for the OS and the base install of sql server
disk 3 and 4 and 5 72 gig each - raid 5, striped for the data
disk 6 9 gig, temp, and logs

I know spliting stuff up is good, but am i chasing the right split here, and is it the best use of our limited disks, etc..

any push in the right direction would be good!

Nathan
(Aberbotimue)

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-25 : 17:56:17
Isn't 9 GB for disk 6 (TempDB and Log) too less? You need to have more space available for Log and TempDB as SQL 2005 uses more TempDB than SQL 2000.
Go to Top of Page

aberbotimue
Starting Member

26 Posts

Posted - 2009-02-26 : 11:42:42
Thanks for that, So i should look to make that disk bigger.. I will have a look,,.

is the split i have planed a good one?

N
Go to Top of Page
   

- Advertisement -