Tuesday, March 27, 2012

Data File Did Not Automatically Grow

I have a data file that is set to automatically grow 10%. 11858 MB was allo
cated to the database, whose max growth was set to 15000 MB. There was 0 MB
space free for about an hour. I had to go into Enterprise Manager and chan
ge the space allocated from
11858 MB to 13000 MB and the data file grew fine.
I don't understand why it didn't automatically grow. All of our databases a
re set to auto grow and we have never had this problem. There is 8 GB free
on the drive that the data file resides.
Has anyone seen this issue before?
Thank you very much for your time.
MelanieSometimes autogrow doesn't catch up, quite simply. We see this from time to
time, and I've seen at least one technical description for a scenario where
this can happen (but I don't recall details). There might be KB articles
about specific scenarios, but fact still stand...
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Melanie" <anonymous@.discussions.microsoft.com> wrote in message
news:C6D5E793-85CB-4345-93BB-5FBAC9AD028D@.microsoft.com...
> I have a data file that is set to automatically grow 10%. 11858 MB was
allocated to the database, whose max growth was set to 15000 MB. There was
0 MB space free for about an hour. I had to go into Enterprise Manager and
change the space allocated from 11858 MB to 13000 MB and the data file grew
fine.
> I don't understand why it didn't automatically grow. All of our databases
are set to auto grow and we have never had this problem. There is 8 GB free
on the drive that the data file resides.
> Has anyone seen this issue before?
> Thank you very much for your time.
> Melanie

No comments:

Post a Comment