October 11, 2010 at 3:37 pm
Hi
What is the difference between having partitions of a single disk as Drives i.e having a large disk partitioned into C,D,E etc.. and having dedicated disks as those drives for SQL Server ?
My problem is size of disks available i.e I need to have a C drive of only 10 GB but don't have such small disks available but have only large disk avaiable like 120 GB.
Should I use 120 GB dedicated disk for C drive or Partition 120 GB into multiple drives like C, D, and E.
Any help would be greatly appreciated.
Thanks,
SQLRocks
October 11, 2010 at 3:57 pm
Partitioning a disk into multiple logical drives is pointless for SQL. You may as well leave it as one large drive and put everything on it.
Multiple disks gives you multiple spindles (reading/writing in parallel) and, depending how it's set up (RAID) less risk of complete failure. With partitions on a single disk you have one spindle and if the drive fails everything's gone.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 11, 2010 at 4:05 pm
Thank you very much for your help Gail. Much Appreciated!
--
SQLRocks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply