Home Forums SQL Server 2012 SQL 2012 - General Tables on seperate filegroups. RE: Tables on seperate filegroups.

  • August 15, 2014 at 6:51 pm

    #1738602

    senthil kumar d (8/13/2014)

    Sorry for the late response. I had asked for a discussion with my DBA on why they are doing SIMPLE recovery instead of Full recovery..

    But we have split our filegroups so that they are spread across 16 different drives.. So it should help distribute the IOs..

    If it's on a SAN, you have to ask the question... "Are they really 16 separate physical drives"?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)