Good morning all,
Consider the following setup:
Database name Data with only a primary filegroup
File Name File Size MB Free space in File Growth allowed Disk size
Data1.mdf 281518.69 10272.13 100MB Lim 281519 304 GB
Data2.ndf 265555.00 5771.81 100 MB Lim 271054 304 GB
Data3.ndf 238897.00 21797.50 100 MB Lim 238897 304 GB
Data4.ndf 111998.00 3613.75 100 MB Lim 200000 304 GB
Data5.ndf 148108.00 9347.94 100 MB Lim 200000 304 GB
Data6.ndf 92160.00 23809.88 100 MB Lim 200000 304 GB
Data7.ndf 92160.00 43450.94 100 MB Lim 200000 304 GB
Data8.ndf 92160.00 43426.63 100 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.
“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