even if it is one one big raid array you should have one file for each spindle in the array. This is just a sql best practice.
I had never heard of it until reading the book. Very good book by the way. On Mon, Dec 23, 2013 at 11:51 AM, Stephen Owen <[email protected]> wrote: > HI all, > > I've been rereading Kent Agerlund's *Mastering the Fundamentals* book > for Config Man 2012, and one of the things he recommends in the Post-SQL > Configuration section on page 32 is that: > > One of the recommended post installation tasks is to create additional >> SCCM database files[..] since the server has two CPUs with six cores each, >> you will create 11 additional files. The estimated size of the database is >> 30 GB, which will be split into 11 files of 3 GB each that will autogrow >> 1gb at a time. [PARAPHRASED] > > > The chapter continues on with a script that accomplishes the splitting > but doesn't explain why this is done. I've looked around and basically > can't figure out what any of this means, and can't find any blog posts or > recommendations or (most needed) an explanation of what this is doing and > why I'd want to do it. > > If you guys could shed some light on this, I would appreciate it. > >
