May 19, 2014 at 8:19 am
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
___________________________________________________________________
May 21, 2014 at 12:51 pm
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