Database level lock: grows

Showing posts with label grows. Show all posts

Tuesday, March 27, 2012

database grows abnormally

there are 350 tables in database.in each hour 60 records appended to each
table.there is a unclustered index on each table.
but database size grows abnomarly (fragmentation) .i exported and imported
it then the size was normal .but again after inserting records
the size of grows abnormally.
this db is used in real time system so time is impossibe.when i used
clustered index the insertion action was very slow.so i used unclustred
index.
i used dbreindex , defrag whitout any advantage for defragmanting.
thanks of all.
Message posted via http://www.sqlmonster.com
sepideh iranpour via SQLMonster.com wrote:
> there are 350 tables in database.in each hour 60 records appended to
> each table.there is a unclustered index on each table.
> but database size grows abnomarly (fragmentation) .i exported and
> imported it then the size was normal .but again after inserting
> records
> the size of grows abnormally.
> this db is used in real time system so time is impossibe.when i used
> clustered index the insertion action was very slow.so i used
> unclustred index.
>
> i used dbreindex , defrag whitout any advantage for defragmanting.
> thanks of all.
Is it possible the database is just auto-growing to accommodate the
newly inserted data? i don't think fragmentation would itself be the
cause of abnormal growth. Is it just the data file size that's growing
and not really the underlying data in the file(s)?
David Gugick
Imceda Software
www.imceda.com
sql

database grows abnormally

there are 350 tables in database.in each hour 60 records appended to each
table.there is a unclustered index on each table.
but database size grows abnomarly (fragmentation) .i exported and imported
it then the size was normal .but again after inserting records
the size of grows abnormally.
this db is used in real time system so time is impossibe.when i used
clustered index the insertion action was very slow.so i used unclustred
index.
i used dbreindex , defrag whitout any advantage for defragmanting.
thanks of all.
--
Message posted via http://www.sqlmonster.comsepideh iranpour via SQLMonster.com wrote:
> there are 350 tables in database.in each hour 60 records appended to
> each table.there is a unclustered index on each table.
> but database size grows abnomarly (fragmentation) .i exported and
> imported it then the size was normal .but again after inserting
> records
> the size of grows abnormally.
> this db is used in real time system so time is impossibe.when i used
> clustered index the insertion action was very slow.so i used
> unclustred index.
>
> i used dbreindex , defrag whitout any advantage for defragmanting.
> thanks of all.
Is it possible the database is just auto-growing to accommodate the
newly inserted data? i don't think fragmentation would itself be the
cause of abnormal growth. Is it just the data file size that's growing
and not really the underlying data in the file(s)?
--
David Gugick
Imceda Software
www.imceda.com

database grows abnormally

there are 350 tables in database.in each hour 60 records appended to each
table.there is a unclustered index on each table.
but database size grows abnomarly (fragmentation) .i exported and imported
it then the size was normal .but again after inserting records
the size of grows abnormally.
this db is used in real time system so time is impossibe.when i used
clustered index the insertion action was very slow.so i used unclustred
index.
i used dbreindex , defrag whitout any advantage for defragmanting.
thanks of all.
Message posted via http://www.droptable.comsepideh iranpour via droptable.com wrote:
> there are 350 tables in database.in each hour 60 records appended to
> each table.there is a unclustered index on each table.
> but database size grows abnomarly (fragmentation) .i exported and
> imported it then the size was normal .but again after inserting
> records
> the size of grows abnormally.
> this db is used in real time system so time is impossibe.when i used
> clustered index the insertion action was very slow.so i used
> unclustred index.
>
> i used dbreindex , defrag whitout any advantage for defragmanting.
> thanks of all.
Is it possible the database is just auto-growing to accommodate the
newly inserted data? i don't think fragmentation would itself be the
cause of abnormal growth. Is it just the data file size that's growing
and not really the underlying data in the file(s)?
David Gugick
Imceda Software
www.imceda.com

Thursday, March 22, 2012

database file does not auto grow

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 growthHi,
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@.microsoft.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|||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@.microsoft.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
>|||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@.microsoft.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
>
>|||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@.microsoft.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
> 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@.microsoft.com...
> 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@.microsoft.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
>> >
>> >
>>|||Properties
General tab
space available = 116mb
"Uri Dimant" wrote:
> 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@.microsoft.com...
> > 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@.microsoft.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
> >> >
> >> >
> >>
> >>
> >>
>
>|||Run
DBCC UPDATEUSAGE (0)
sp_spaceused
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:B3B31B8F-6561-407E-9D84-DF75038E60DD@.microsoft.com...
> Properties
> General tab
> space available = 116mb
> "Uri Dimant" wrote:
>> 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@.microsoft.com...
>> > 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@.microsoft.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
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||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@.microsoft.com...
> > Properties
> > General tab
> > space available = 116mb
> >
> > "Uri Dimant" wrote:
> >
> >> 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@.microsoft.com...
> >> > 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@.microsoft.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
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||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@.microsoft.com...
>> Properties
>> General tab
>> space available = 116mb
>> "Uri Dimant" wrote:
>> 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@.microsoft.com...
>> > 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@.microsoft.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
http://www.sql-server-performance.com/database_settings.asp
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:506BA27E-4C9D-4D37-BD1E-7075074257DA@.microsoft.com...
> 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@.microsoft.com...
>> > Properties
>> > General tab
>> > space available = 116mb
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> 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@.microsoft.com...
>> >> > 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@.microsoft.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
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

Tuesday, March 27, 2012

database grows abnormally

database grows abnormally

database grows abnormally

Thursday, March 22, 2012

database file does not auto grow

database file does not auto grow

database file does not auto grow

Database level lock

Blog Archive

About Me