June 13, 2008 at 2:18 am
Hi,
I'm a newbie when it comes to SQL Server 2005. I was asked this question once about the impact of filegroups on performance. Please point me to some links which will be give me some detailed info on how to decide about filegroups and how each decision will impact the performance.
Thanks
June 13, 2008 at 3:04 am
Soni (6/13/2008)
Hi,I'm a newbie when it comes to SQL Server 2005. I was asked this question once about the impact of filegroups on performance. Please point me to some links which will be give me some detailed info on how to decide about filegroups and how each decision will impact the performance.
Thanks
Books Online explains the basics quite well, have a look at http://msdn.microsoft.com/en-us/library/ms187087.aspx. Generally the answer depends much on the data you store in the database (how much data, in which tables, how frequently are these accessed, are they accessed together, etc.)
Regards,
Andras
June 13, 2008 at 5:28 am
Hi,
Also, keep in mind that if you are using a single disk, you will see little if any performance gain by using multiple file groups.
The purpose of Filegroups is primarily for managing data and doing so across different storage units.
Typically you should have multiple disk arrays in order to see the true performance benifits.
June 13, 2008 at 5:44 am
Hi,
Thanks for the reply.
When you say multiple disk arrays, are we talking about RAID..? I'm also looking into Books online article.
June 13, 2008 at 5:57 am
Hi Sony,
RAID is a technology that is available for use with a disk array yes.
Quite a big subject area to get stuck into however the following link may prove benificial when considering disk arrays.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply