Tips for best partitionning

[brimar123]

Hi,

I am new to SMS 2003 and I install SMS for the first time. I would like tips for partitionning my disk for best performance...

I have server with CPU 3.06Ghz, 1.5Gig RAM and "MIRROR 70Gig" and I envisage to install Windows Server 2003 Standard with SQL 2000 on the same server for approximately 600 PC, I have another server for software distribution.

My fist idea is ...

Partition A (30 Gig) : O/S, SMS 2003 and SQL Software
Partition B (10 Gig) : SQL Transactions Logs
Partition C (30 Gig) : SQL Database


Any help would be greatly appreciated.

Thank you
Martin

Sorry for my english i speak just a little bit in english !!!

 

[tbrennans]

depends on how much you want to spend!
if one channel with Hardware controller perhaps

one array (RAID 5) partitioned into volumes OS, SQL, SMS and logs

if two channels with HD controller then
Channel 1 RAID 1 (OS)
Channel 1 RAID 5 (SQL)

Channel 2 RAID 5 (SMS)
Channel 2 RAID 5 (Logs)

With your current setup and only 600 clients it will work (not great but it will probably do the job) but there wouldnt be any reason at all (that I can think of) to make any partitions....1 c: drive would be the same and less work for you.

Tim B