November 29, 2012 at 3:34 am
Hello there,
Have a database that the data file is growing really fast at the moment it is 100GB and I need more space all the time on the drive. This is a production db so I wouldnt do shirnk since it can cause fragmentation. What else can i do expect from more space ? Is there any other way?
Thank you
November 29, 2012 at 3:43 am
If the data file is growing rapidly, you need to check is this normal behavour? do you have a run away process which is looping through the same task causing the growth? can anything be purged from the database?
Other than that add more space to the drive or move the data file to a bigger drive.
November 29, 2012 at 3:47 am
How can i find out if something goes in a loop?
I do believe that another drive will be the solution myself.
November 29, 2012 at 3:52 am
Check to see what your biggest tables are, monitor them for duplicate entries if something is stuck importing the same file over and over etc it will upload the same data.
User profiler to see what else is going on and if you can spot any differences between your baseline and today.
November 29, 2012 at 3:53 am
Run a report on table size, that may give you a clue on where the space is being taken up. If you compare this report now to later on you'll see which tables are growing the fastest. Then talk to your devs and they may have a good idea as to where the problem lies.
Thanks,
Simon
November 29, 2012 at 4:29 am
Thank you for the recommendations
R
November 29, 2012 at 8:04 am
data will need space its his nature plus our requirement too , you need to see the growth percentage and based on that you need space additionally soon you will see same behavoiur with log drive too and tempdb too , so better take some proactive approach there 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply