Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tommccann
Starting Member
5 Posts |
 Posted - 2011-11-23 : 06:04:54
|
| I've read about a dozen articles on FILEGROUPS. I understand how to create them, how to put new files in them, how to assign tables to them, etc, etc. However, I fail to see why they exist.The reason for having them it seems is to separate log files from data, from backups, operating system files, etc, by placing each type of data on a separate physical drive, assuming you have lots of physical drive in an ideal world.OK. So far so good. I understand the concept. However, I am free to create multiple secondary data files and put each one in the PRIMARY filegroup but with each file on a different drive. So, what good are FILEGROUPS if I can achieve the same thing anyway?I can't see anything in SSMS or T-SQL that ties a particular FILEGROUP to using a particular drive.I realise that I'm probably missing something really obvious here and will probably be embarassed when it's pointed out. :-( Many thanks for your help.Tom |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-23 : 06:25:59
|
| http://www.sql-server-performance.com/2003/optimize-filegroup-performance/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tommccann
Starting Member
5 Posts |
Posted - 2011-11-23 : 07:04:44
|
| thanks for the article. it gives me lots of information about filegroups, but still doesn't answer my question. |
|
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-23 : 07:05:57
|
| Very good article by Jonathan Kehayiashttp://sqlskills.com/blogs/jonathan/post/Looking-at-multiple-data-files-and-proportional-fill-with-Extended-Events.aspx |
|
|
|
tommccann
Starting Member
5 Posts |
Posted - 2011-11-23 : 07:25:16
|
| guys, thanks for the articles. i read them but i'm not really short of articles. i can use google to produce thousands of articles about filegroups. what i am short of is an answer to the question. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-11-23 : 07:40:46
|
| They are used mainly to improve performance. You can put your heavily used tables on a seperate filegroup (or filegroups), this then frees up access to the other tables within your DB. This way file access speeds aren't affected as much as they would be if you had them all in one filegroup. |
|
|
|
|
|
|
|
|
What use are FILEGROUPS?