Best practices for File groups in OLTP Database?

  • SQLKnowItAll (2/1/2012)


    Can you give an example of a situation where you would choose not to do it

    Just about all of them.

    I would consider doing that if I had requirements that in case of restore a small portion of the DB be online fast, and the rest later, and it would *start* with 1 filegroup for just the system tables and then additional filegroups (not one additional filegroup)

    In fact, I can't think of any cases where I would only have primary and only one other filegroup unless I knew for an absolute fact that I would be adding more filegroups later for the above scenario.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks Gail!

    Jared
    CE - Microsoft

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply