SQL Server Database Primary Data File - Growing Exponentially

I received a notification on a disk drive hosting a SQL Server 2008 Standard/Windows 2008 R2 Standard - .mdf file.  The notification states that the server is running out of disk space.  12 hours ago, the available disk space was at 125 GB available.  Now there is only less than 50GB available and that .mdf file keeps growing.  is there any maintenance that can be run on the database side, rather than expanding the volume, and have the issue recur again?
jduran04Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mr KnackeredCommented:
If its the MDF file then you need to find out what is causing the increasing space. Check the storage size on the tables suspected of causing this and see what is going on. Something is eating up your disk and you need to isolate what it is before being able to decide on how to fix it.

You can implement file groups (.ndf files) and move large tables into these which will allow you to move the ndf files onto different volumes if your unable to increase the disk space in its current location. You could also move your temp db and log files onto different volumes which will free up space if the MDF growth is expected. If the growth was temporary you can shrink the MDF down but it will only grow again if the cause of the growth is going to happen again.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lcohanDatabase AnalystCommented:
Please do the following to help you get closer to the reason this file is growing however is just more data or indexes that are getting into the database tied to that MDF file.
Open SQL SSMS, connect to that SQL in cause, Expand databases, Right Click the DB in cause, select Reports, select Standard, then chose following two from the list:

Disk Usage
Disk Usage by top tables

If you right click on any of these reports you can then save as Excel and keep so you can compare and see which tables are growing fast.
ZberteocCommented:
Change the growth method from pecentage, which is defaulted at 10%, to a fixed value, say 512MB. In the Management Studio, expand database node > right click on the database > Properties > Choose Files in the left panel Files and change the Autogrouwth. 10% from 125GB is 12GB and that is a lot!
Here:
db_growth.JPG
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.