November 16, 2003 at 11:30 pm
Hi,
I am fairly new to sql2000 and have searched everywhere for the answers to these:
What is the recommended maximum datafile size for a single datafile in a filegroup?
and whats the recommended max number of datafiles for each filegroup?
Thanks muchly,
Jason
November 17, 2003 at 4:00 am
Well, you can have
- 256 filegroups per database
- 32,767 files per database
- with a file size of 32 TB
What you now do with it depends
- on your db
- the size of the tables
- the backup strategy
- hardware
- performance
- .....
So I guess there is not a single overall valid recommendation.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 17, 2003 at 6:13 am
Use one file per filegroup and one filegroup per drive array. Use up to 80% of disk capacity. If your arrays are twelve-drive RAID 10 on a four-channel controller using 18GB drives, then that would be 345GB each. If you use 14 147GB drives per channel configured as RAID 0, then you could have 6.6TB files. If you need to do filegroup backups, then let your backup hardware and time window determine the maximum size.
--Jonathan
--Jonathan
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply