December 8, 2014 at 10:00 am
When adding an extra data file to a database, is there any (performance / backup / any other related) benefit to adding one of the same size?
I know in tempdb, the equal sizing is best practice.
Is this the same for user databases? If so, why?
BTW, this is for Sharepoint 2010 config databases in case it's relevant.
Thanks in advance.
December 9, 2014 at 4:20 am
snomadj (12/8/2014)
When adding an extra data file to a database, is there any (performance / backup / any other related) benefit to adding one of the same size?I know in tempdb, the equal sizing is best practice.
Is this the same for user databases? If so, why?
BTW, this is for Sharepoint 2010 config databases in case it's relevant.
Thanks in advance.
a Sharepoint config database is going to be fairly small based on the designed usage, content databases grow fairly large.
Why do you feel the need to start adding files to all your databases, its not a Best Practice as it is with TempDB
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply