Post reply

Primary file and secondary files

  • November 3, 2015 at 3:35 am

    #301998

    Hi,

    I am at a new client they have a database which has:

    One primary file (mdf)

    and three secundary files (ndf)

    All of the files are on the same disk.

    For the sanaty of performance shouldn't they be at diferent disks?

    I mean, why separate objects through the creation of several data files if they are not on different disks?

  • November 3, 2015 at 3:37 am

    #1837304

    Are they all in the same filegroup or different filegroups?

    If different might be done for piecemeal restores.

  • November 3, 2015 at 9:30 am

    #1837408

    river1 (11/3/2015)

    I mean, why separate objects through the creation of several data files if they are not on different disks?

    To allow for piecemeal restores?

    Because some consultant told them to and didn't explain why?

    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

  • November 3, 2015 at 2:17 pm

    #1837483

    or they just read somewhere that it's a best practice

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 4 (of 4 total)

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