Solved

Auto growth on Index file

Posted on 2013-01-14
1
460 Views
Last Modified: 2013-01-15
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?
0
Comment
Question by:navajo26354
1 Comment
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 500 total points
ID: 38776628
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question