Solved

What is the purpose of filegroups in SQL Server?

Posted on 2009-04-07
6
443 Views
Last Modified: 2012-05-06
Hi all,

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

Thanks
0
Comment
Question by:Liam_H
6 Comments
 
LVL 12

Assisted Solution

by:udayakumarlm
udayakumarlm earned 62 total points
ID: 24085729
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
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24085771
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
 

Author Comment

by:Liam_H
ID: 24085798
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
[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

 
LVL 12

Expert Comment

by:udayakumarlm
ID: 24085809
yes
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 63 total points
ID: 24085821
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
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24085914
>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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now