question

raadee avatar image
raadee asked

Sharepoint - Datafiles - MaxSize

Hi, I just want to double check the procedure for setting max file size on Sharepoint databases (2010). I'm going to go with recommended max file size (200GB Content db - 100GB site collection db), or maybe smaller for improved manageability. Usually i have a .mdf that i restrict to a certain size and create a .ndf that picks up the data when the .mdf is full. I guess it is standard procedure for Sharepoint also but can anybody just verify this? 1. I create .ndf - set max size 100GB 2. I set max size 100GB for the .mdf 3. .ndf takes over when maxsize reached for .mdf Also if I create 2 .ndf files at the same time, which one is chosen to take over? Is there any scenario where some kind of proportional fill is used between .mdf and .ndf or does it fill upp .mdf to maxsize and then proceed to .ndf?
sharepointfiledatabase-filessizesharepoint-2010
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
There is an additional abstraction layer in the storage engine that you have not mentioned so far - Database Filegroups. You group database files into a filegroup (you start with just one filegroup called "PRIMARY"). All files in that filegroup are then written to using a proportional fill routine. This means that your design will start proportionally filling the mdf and ndf files from the start.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raadee avatar image raadee commented ·
Proportional fill is in effect, thanks! Regarding not mentioning filegroups, Sharepoint only supports primary.
0 Likes 0 ·
raadee avatar image raadee commented ·
Accepting this as an answer since I can not find any other info or way to do it. Thank you William.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.