Groups | Blog | Home
all groups > sql server msde > may 2006 >

sql server msde : MSDE and Win2003 on same partition?


Cwhitmore
5/9/2006 2:45:01 PM
I'm setting up a Win2003 server on AD as a domain controller. I have two 68GB
SCSI disks mirrored (RAID 1), which only give me one virtual disk for the OS
and any data. Should I partition the virtual disk and put MSDE on one
partition and the OS on another or does it make any difference since they are
both running from the same physical disks?
Andrea Montanari
5/10/2006 12:29:21 PM
hi,
[quoted text, click to view]

the binaries (OS and SQL Server) do not get much benefit when spread across
different physical disks...
you could get better benefit if you spread the data and log database files
across several disk to increase IO activity becouse of the multi spindles,
so that each disk mechanich has fewer movements to perform...
for binaries only I'd not take all that care...
my $0.02
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

MeanOldDBA
5/14/2006 4:39:01 PM
As Andrea pointed out, since you only have two disks, it doesn't really
matter. Many people prefer to create a seperate partition strictly from a
management and standards perspective. It's preference though, unless you
have more disks. Be consistent though.
--
MeanOldDBA
derrickleggett@hotmail.com
http://weblogs.sqlteam.com/derrickl

When life gives you a lemon, fire the DBA.


[quoted text, click to view]
AddThis Social Bookmark Button