Even out data files

  • Good morning all,

    Consider the following setup:

    Database name Data with only a primary filegroup

    File NameFile Size MBFree space in File Growth allowedDisk size

    Data1.mdf281518.69 10272.13 100MB Lim 281519 304 GB

    Data2.ndf265555.00 5771.81 100 MB Lim 271054 304 GB

    Data3.ndf238897.00 21797.50100 MB Lim 238897 304 GB

    Data4.ndf111998.00 3613.75100 MB Lim 200000 304 GB

    Data5.ndf148108.009347.94100 MB Lim 200000 304 GB

    Data6.ndf92160.0023809.88100 MB Lim 200000 304 GB

    Data7.ndf92160.0043450.94100 MB Lim 200000 304 GB

    Data8.ndf92160.0043426.63100 MB Lim 200000 304 GB

    The original setup had 5 files and the disk sizes were all over the place.

    We added three more to bring it to vendor specs and made them all the same size.

    All drives are on SAN.

    What can we do to reorg these files so they are spread more evenly across the drives.

    Our vendor said to rebuild the indexes, but would this work unless we dropped all of them and then

    Rebuild them. What can of worms would this open. Can we keep the database accessible while this is happening?

    Just not sure what to do.

    Thanks.

    Mike

    “I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey

    ___________________________________________________________________

  • FYI, this is what we are doing to fix the issue and it seems to be working.

    Made sure we were using Instant file initialization.

    Added trace flag 1117 and -E parameter to startup.

    Resized all files to equal the biggest file we had.

    Set growth on all files to be identical.

    Currently running an index rebuild (using Ola's fine script).

    Seems to be redistributing to some degree.

    Mike

    “I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey

    ___________________________________________________________________

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

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