October 18, 2007 at 7:17 am
Hi,
In SQL Server 2000, if the data file size is 20 GB or more, is it better to split it into a number of (say 5 or even 10 or more), even if they are all residing on the same RAID-5 array. Or it is advisable to keep the data in a single file only.
thanks.
October 18, 2007 at 7:42 am
I'd tend to say you don't stand to gain any performance that way, since stripes are always spread across all drives. It's more likely that you would lose performance, since multiple files would tend to increase likelihood of file fragmentation on the OS side.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
October 18, 2007 at 8:35 am
I will agree with Matt except for the possibility that you may be able to reduce the size of your backups by moving relatively static data into file groups that you do not back up as often.
Beyond that, splitting the database into multiple file groups will usually only give you performance gains if you can spread the load of reading and writing over mutiple sets of drive heads. On a single logical drive, you cannot do that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply