| Author |
database file does not auto grow
|
|
| Richard 2006-11-16, 5:20 am |
| Sql 2000 Enterprise SP3
Our current database is 25gb large but grows no longer automatic.
How this are possible?
Properties:
Automaticlly grow file
File growth by percenrtage 10 %
Maximum file size
Unrestricted file growth
| |
| Hari Prasad 2006-11-16, 5:20 am |
| Hi,
YOu have specified 10% auto growth and currently your database is 25 GB.
That means the autogrowth will be >2.5 GB. So just see if you have more than
2.5 GB free space
in hard disk.
Thanks
Hari
"Richard" <Richard@discussions.microsoft.com> wrote in message
news:F97E1700-B6D7-476E-9D00- 0B4E596A5BF8@microso
ft.com...
> Sql 2000 Enterprise SP3
> Our current database is 25gb large but grows no longer automatic.
> How this are possible?
>
> Properties:
> Automaticlly grow file
> File growth by percenrtage 10 %
> Maximum file size
> Unrestricted file growth
>
>rowth wi
| |
| Uri Dimant 2006-11-16, 5:20 am |
| Richard
It is possible that the data file has enough free space . How big is your
..BAK file? How long have you noticed that database does not grow?
"Richard" <Richard@discussions.microsoft.com> wrote in message
news:F97E1700-B6D7-476E-9D00- 0B4E596A5BF8@microso
ft.com...
> Sql 2000 Enterprise SP3
> Our current database is 25gb large but grows no longer automatic.
> How this are possible?
>
> Properties:
> Automaticlly grow file
> File growth by percenrtage 10 %
> Maximum file size
> Unrestricted file growth
>
>
| |
| Richard 2006-11-16, 5:20 am |
| 49gb free
"Hari Prasad" wrote:
> Hi,
>
> YOu have specified 10% auto growth and currently your database is 25 GB.
> That means the autogrowth will be >2.5 GB. So just see if you have more than
> 2.5 GB free space
> in hard disk.
>
>
> Thanks
> Hari
>
> "Richard" <Richard@discussions.microsoft.com> wrote in message
> news:F97E1700-B6D7-476E-9D00- 0B4E596A5BF8@microso
ft.com...
>
>
>
| |
| Richard 2006-11-16, 5:20 am |
| Bak file = 20,3 gb
the problem is about 2 months old
"Uri Dimant" wrote:
> Richard
>
> It is possible that the data file has enough free space . How big is your
> ..BAK file? How long have you noticed that database does not grow?
>
>
>
>
> "Richard" <Richard@discussions.microsoft.com> wrote in message
> news:F97E1700-B6D7-476E-9D00- 0B4E596A5BF8@microso
ft.com...
>
>
>
| |
| Uri Dimant 2006-11-16, 5:20 am |
| Richard
> Bak file = 20,3 gb
So , roughly you have 5GB free within data files
> the problem is about 2 months old
I don't think that's problem at all
"Richard" <Richard@discussions.microsoft.com> wrote in message
news:E6001F5E-CF5C-4E8F-B64D- 4EABCB4E8C93@microso
ft.com...[color=darkred]
> Bak file = 20,3 gb
> the problem is about 2 months old
>
> "Uri Dimant" wrote:
>
| |
| Richard 2006-11-16, 5:20 am |
| Properties
General tab
space available = 116mb
"Uri Dimant" wrote:
> Richard
>
> So , roughly you have 5GB free within data files
>
>
> I don't think that's problem at all
>
>
> "Richard" <Richard@discussions.microsoft.com> wrote in message
> news:E6001F5E-CF5C-4E8F-B64D- 4EABCB4E8C93@microso
ft.com...
>
>
>
| |
| Uri Dimant 2006-11-16, 5:20 am |
| Run
DBCC UPDATEUSAGE (0)
sp_spaceused
"Richard" <Richard@discussions.microsoft.com> wrote in message
news:B3B31B8F-6561-407E-9D84- DF75038E60DD@microso
ft.com...[color=darkred]
> Properties
> General tab
> space available = 116mb
>
> "Uri Dimant" wrote:
>
| |
| Richard 2006-11-16, 5:20 am |
| sp_spaceused
database_size 22256.56 mb unallocated space -2050.81 mb
reserved 22594752 kb data 17937184 kb index_size 2045344 kb unused 2612224 kb
"Uri Dimant" wrote:
> Run
> DBCC UPDATEUSAGE (0)
> sp_spaceused
>
>
>
>
> "Richard" <Richard@discussions.microsoft.com> wrote in message
> news:B3B31B8F-6561-407E-9D84- DF75038E60DD@microso
ft.com...
>
>
>
| |
|
| 10% auto growth is not OK for larger databases. Increment size is 2.5GB in
that case so your disk system would have to write 2.5GB in 30 seconds on
disk. That's almost 100MB/second. Is your disk subsystem that fast? After 30
seconds clients get time-outs (by default) and file growth is canceled. You
can manualy expand file size to desired size or specify smaller fixed
increment size (256MB..)
Tom
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:uiEfXEWCHHA.3540@TK2MSFTNGP03.phx.gbl...
> Run
> DBCC UPDATEUSAGE (0)
> sp_spaceused
>
>
>
>
> "Richard" <Richard@discussions.microsoft.com> wrote in message
> news:B3B31B8F-6561-407E-9D84- DF75038E60DD@microso
ft.com...
>
>
| |
| Uri Dimant 2006-11-16, 5:20 am |
| Richard
http://www.sql-server-performance.c...se_settings.asp
"Richard" <Richard@discussions.microsoft.com> wrote in message
news:506BA27E-4C9D-4D37-BD1E- 7075074257DA@microso
ft.com...[color=darkred]
> sp_spaceused
>
> database_size 22256.56 mb unallocated space -2050.81 mb
> reserved 22594752 kb data 17937184 kb index_size 2045344 kb unused 2612224
> kb
>
> "Uri Dimant" wrote:
>
|
|
|
|