February 18, 2016 at 7:28 am
We have 2 TB Production Database, in which already created one file group for indexes only, which contains 10 files each size 130 GB as Initial size. initial size is already filled-up for all files but auto growth has set to unlimited so as of now no issue.
is it recommended all files set to unlimited data growth ?
or do we need to put the limit the growth and create same 10 new files with same size ?
which one is best practice ?
February 18, 2016 at 8:20 am
Best practice is to monitor space and add space before it is needed. Adding space can interfere with your workload and slow the server down. You also get fragmented files. Grow your space in the mdf/ndf files to the amount you need for 3-4 months and monitor.
In terms of files in a filegroup, read this. It can help, but the effect will depend on your workload.
http://www.sqlskills.com/blogs/paul/benchmarking-do-multiple-data-files-make-a-difference/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply