one physical data file vs two files
-
over 200 tables in one 29GB data file on a RAID group.
Is it beneficial (performance wise) to have second data file (~1GB) hosting 5 most active tables on the same RAID group?
There is only one RAID group on the current SQL server!
Thanks,
-
29GB does not sounds that big!
what RAID level do you have?
how many spindles/disks are you using on the RAID?
do you have the log in a separated drive?
are indexes Ok where they are needed?
there are many other things to try before you split the filegroup. specially at 30GB size
* Noel -
RAID 5 with 3 disks.
Data and log files are on the same partition.
Indexes shall be OK.
Just wondering how SQL server reads the data file? Will it read table from 1 GB file faster than read table from 29GB file? Or, it doesn't matter, since it's one RAID group.
Thanks,
-
if data and log are on the same partition you have the first problem there.
Filesize is not as much an issue as TABLE size
and you coud try to increase the number of disks to increase stripe size because 3 sounds like minimum
* Noel
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply