Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Even out data files Expand / Collapse
Author
Message
Posted Monday, May 19, 2014 8:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:50 AM
Points: 2,576, Visits: 2,222
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.

Thanks.


Mike

The more you know, the more you know you don't know.

_____________________________________________________________________________

A word to the wise ain't necessary, it's the stupid ones who need the advice ...Bill Cosby
Post #1572305
Posted Wednesday, May 21, 2014 12:51 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:50 AM
Points: 2,576, Visits: 2,222
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

The more you know, the more you know you don't know.

_____________________________________________________________________________

A word to the wise ain't necessary, it's the stupid ones who need the advice ...Bill Cosby
Post #1573298
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse