Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > adding more data files to a database
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 11th April 04:35
gresham
External User
 
Posts: 1
Default adding more data files to a database


I think it has more to do with how you have your disk's
layed out. If you are putting these files on separate
disk drives then you should see improvement in overall
throughput.

For example, if you have a SCSI Disk Drives that has
an effective rate of 40mb/Second and have files on
separate you would see some improvement(unless there
is other activity going on with the other drive).

Also, if you have several datafiles on the same disk then
their will be increased contention as the heads have to
go to several spots on the disk to get the information you
need.

If you are using Raid and have striping then having seperate
files would be distributed across the number of drives you
have. Even one file would benefit from the striping. For
fault tolerance you would want RAID 10 for Mirroring as well.


Any corrections are welcome.

Dave
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666