What is the purpose of filegroups in SQL Server?

Hi all,

I'm just wondering what the purpose of Filegroups is in SQL Server. What do they do? How do they work?

Thanks
Liam_HAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Yes. And its a best practice to

1. Keep MDF files and LDF files in different partition to increase the performance of the Server.
2. Its advisable to have NDF files ( Secondary Files) to improve the Performance of the Primary File further.

having filegroups as mentioned above will improve the IO speed for reading and writing data into SQL Server.
0
 
udaya kumar laligondlaConnect With a Mentor Technical LeadCommented:
filegroups provide an opportunity for fine-tuning performance by allowing you to move specific tables and indexes from one physical drive array to another

read more at
http://www.sql-server-performance.com/tips/filegroups_p1.aspx
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Database objects and files can be grouped together in filegroups for allocation and administration purposes.

http://msdn.microsoft.com/en-us/library/ms179316(SQL.90).aspx
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
Liam_HAuthor Commented:
So if I understand this correctly, it's a way to group tables together - that work together, and can potentially speed up and increase the performance of the database? So you would have tables in a filegroup that have a lot of interaction with each other, and are generally large in size?
0
 
udaya kumar laligondlaTechnical LeadCommented:
yes
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>So if I understand this correctly, it's a way to group tables together - that work together, and can potentially speed up and increase the performance of the database?
actually, it's just the other way round.
tables (and indexes) that are used together should go into different filegroups, so that the I/O for the same action/query can be effectively shared among distinct files, aka drives.

putting those tables "together" will not give you any advantage.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.