I don't know much about SQLServer.

But I will say something.

Don't partition you drives.
Use one drive letter per physical device.

yes, you should span you datafiles over multiple physical device.

-----Original Message-----
From: Sexton, Kevin [mailto:kevin.[Email Address Removed] Thursday, February 28, 2002 4:19 PM
To: LazyDBA.com Discussion
Subject: system redesign


We build data warehouses using SQLServer 2000 Standard on WIN2K Advanced
Server (I know this is an Oracle list but these are design questions)

We are lucky enough to be building a new backend with an EMC Clarion at
the backend. This is my opportunity to redesign a lot of things. These
are the ideas I have and I would appreciate feed back

* Logical groupings of data files, file groups and drive
partitions
* read from the RAW file group and write to the DDM file group
* Should the development environment be striped and production
RAID5
* Can we set it up so all processes write to different partitions
(if we are logging everything those should be written to a different
drive letter)
* Would we see a gain from partitioning tables. Should I cluster
servers and build my cubes that way for performance reasons?

-Kevin


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page