Solved

What is the purpose of filegroups in SQL Server?

Posted on 2009-04-07
6
445 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 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