Solved

What is the purpose of filegroups in SQL Server?

Posted on 2009-04-07
6
452 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:udaya kumar laligondla
udaya kumar laligondla 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 12

Expert Comment

by:udaya kumar laligondla
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 143

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Review MS SQL cluster diagram 9 100
Not selecting duplicate data 6 60
Sql Query join multiple table and distinct records 7 31
Anyway to make these 2 SQL statements into one? 13 42
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 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