SQL 2K8R2, DB file was 450GB, 19% free space, then the file grew to 500GB, with 19% still free. Autogrow set to 1024MB increments. Does anyone know why auto grow is still occurring? #sqlhelp
3
0
0
0
0
My confusion is, despite the fact that the file has a lot of free space, it is still growing. My experience suggests that the file should get very full (95 - 99%) before an autogrow is triggered.
@MyHumbleSQLTips #sqlhelp I'm assuming you're talking the data file and not the log file. If log file, my guess a reindex or something (or worse transaction backups aren't being done for a FULL Recovery mode DB)