what can cause file growth in data file (other than autogrow % formula) when there is less/no data activity?
Posted on 2016-08-29
the data growth setting on the data file is 10%
looking at sysfiles system view, there is plenty of unused space yet in the data file.
current data file size 460 GB, used space 370GB, free 90GB.
we wanted to keep the data file size to 410GB since data growth is relatively slow on this database.
so i shrunk the file to 410GB which worked fine.
but today, i see that the file has grown back to 460 GB.
so obviously it has grown more than 10%, and data usage is still @ 370 GB.
what could cause more than 10% growth?