July 15, 2016 at 1:23 pm
We are frequently receiving Primary file group is running out of space alerts in last week. We still have nearly 12% of space available in D drive. And available Free space for data file showing 4 GB (0%). I do have autogrowth enabled and increased the file size by 2 GB from earlier setting.
What would be the cause of frequently file group running of space?
Any thoughts?
Thanks for help in advance.
July 15, 2016 at 1:59 pm
Uh, you are adding in new data maybe?? :w00t:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 15, 2016 at 2:08 pm
We are adding, dropping and updating data on daily basis. But, it doesn't seems to be that much 😉
July 15, 2016 at 2:23 pm
1) If you have HEAP tables deleting data from them does not release the space, even when a page is emptied.
2) Someone was silly and set FILLFACTOR to a very low number on some/all indexes.
3) Using GUIDs, thus fragmenting indexes badly and wasting lots of space.
4) Are you trending table/index sizes? Not hard to do...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 21, 2016 at 11:28 am
Few days ago, we had nearly 200 GB of space available and now we have only 30-40 GB space left.
Is there any script/method to find out who is filling the data drive?
July 21, 2016 at 1:13 pm
SSMS can show you table/index sizes and rowcounts. F7 on the table folder, select columns for what you need. You can profile the SSMS queries fired off to learn about how to see that stuff for yourself.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply