|
Posted by ceadtinneh on 09/29/05 22:54
Hello Folks,
Last evening, as a result of our autogrow settings, our production
database grew from 102 GB to 107 GB. What puzzled me is that, prior to
the growth, we still had a good 10% free space left in the data file.
My understanding is that SQL Server will automatically grow a database
when worker thread decides that more space is necessary to fulfill a
request. We don't suspect the app of sending over a request which
would require that much more space.
Any ideas on why the file grew unexpectedly?
Thanks,
Joe
Navigation:
[Reply to this message]
|