Auto growth on Index file

I have a index data file which is currently 160 GBs and is fifty percent used.  It is on a 200 GB drive.  I have an index rebuild job that checks for fragmentation and if it's above 80 % it will rebuild.  Currently the file is growing but still continuing to have fifty percent space used.  I do not want this file to grow to fill up the 200 GB drive.  If I stop the auto growth and fix the file size to 160 GB, will it use the free space inside the file or will this create a problem?
navajo26354Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
Just stoping growth will not automatically cause it to use the space allocated and will eventually lead to an error on unable to grow file.
You may want to check your Fill Factor on indexes.  Check to see if you have any set to something other than the default (0)
SELECT * FROM sys.indexes I WHERE I.fill_factor > 0

Open in new window

If so you may be leaving space unused, see this link at MS about Index fill factor http://msdn.microsoft.com/en-us/library/ms177459.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.