July 29, 2009 at 5:02 am
Dear All,
I have a SQLServer 2005 64 bit database, around 600 GB size on windows 2003 64 bit server. The database has 2 file groups(primary and userdata). the primary filegroup has one datafile used for system objects and the userdata filegroup has 16 datafiles placed on different 16 physical drives used for user objects.
is this the good configuration to boost the performance?
or
do i need to create 16 separte file groups for each file?
Please help me.
Thanks,
sathyalan
July 29, 2009 at 6:27 am
since all the 16 files are a part of single filegroup, they'll be written proportionally which means all tables will span all files. you can have multiple filegroups and can have tables in one filegroup and non clustered indexes in other filegroup, this way read/write operation to tables and indexes will take place simulateneously as they'll be on different spindles and u'll definately gain performance improvement.
you can segregate your tables based on their size and usage in different filegroups.
July 31, 2009 at 9:15 am
depending on your data - I would consider multiple filegroups, especially when talking restore/recovery
Piecemeal restore could come in handy for you if a crash happens
/mSC
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply