Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Even out data files


Even out data files

Author
Message
mbricker-600840
mbricker-600840
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3430 Visits: 2383
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

“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

___________________________________________________________________
mbricker-600840
mbricker-600840
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3430 Visits: 2383
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

___________________________________________________________________
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search