SQL 2000 - partition config?

[TheJFM]

I am rebuilding 2 SQL servers to their new spec. 250GB Raid 0.

I am in a dilemma over the best configuration.

Do I put tempdb in one partition? How much space do I allocate?

Do I put data, logs and indexes in separate partitions? If so what would be the optimum ratio of space 1:2:1 ? Here I risk wasting a lot of disc space.

Or do I just dump it all in one partition and maximise the disc space. Will I pay heavily in performance?

The servers will be read only by day – running queries, mostly in pre-aggregated tables.

A large single load and update at night.

Thanks


** Don't reach for the moon when you have the stars. ;-) TheJFM **

 

[JayKusch]

Answers to your questions listed depends heavily on the amount of data your currently have as well as the amount of data that will be entered into the system nightly. Also need to take into account how large your DBs may become in the future. Do you have any specs on the data?

Thanks

J. Kusch

 

[TheJFM]

We guessing at a data store of up to 100 GB with a daily update of 3 GB (data growth will be less)

Thanks

** Don't reach for the moon when you have the stars. ;-) TheJFM **