Database level lock: grow

Showing posts with label grow. Show all posts

Tuesday, March 27, 2012

Database growth and Replication

We have two database instances replicating between them.
We are currently trying to manually grow the database files, when we
do they are reverting back to the original size.
Using Enterprise Manager we enter the properties and insert the new
file size. When we come out SQL pauses and when the screen refreshes
shows the new size.
If we exit enterprise manager and then go back in the original size is
being used.
We have tried ammending the publisher then the subscriber and vice
versa.
Do we need to stop merge replication prior to a database file growth?
Thanks
Graz"graz79" <graz79@.yahoo.co.uk> wrote in message
news:1178020439.331730.41150@.l77g2000hsb.googlegroups.com...
> We have two database instances replicating between them.
> We are currently trying to manually grow the database files, when we
> do they are reverting back to the original size.
> Using Enterprise Manager we enter the properties and insert the new
> file size. When we come out SQL pauses and when the screen refreshes
> shows the new size.
> If we exit enterprise manager and then go back in the original size is
> being used.
> We have tried ammending the publisher then the subscriber and vice
> versa.
> Do we need to stop merge replication prior to a database file growth?
>
Not that I'm aware.
But it almost always sounds like you have auto-shrink enabled.

> Thanks
> Graz
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||That was it. Missed the autoshrink option.
Thanks|||"graz79" <graz79@.yahoo.co.uk> wrote in message
news:1178110568.993714.26180@.o5g2000hsb.googlegroups.com...
> That was it. Missed the autoshrink option.
> Thanks
>
You're welcome.
And yet another reason to avoid auto-shrink ;-)
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Database growth and Replication

We have two database instances replicating between them.
We are currently trying to manually grow the database files, when we
do they are reverting back to the original size.
Using Enterprise Manager we enter the properties and insert the new
file size. When we come out SQL pauses and when the screen refreshes
shows the new size.
If we exit enterprise manager and then go back in the original size is
being used.
We have tried ammending the publisher then the subscriber and vice
versa.
Do we need to stop merge replication prior to a database file growth?
Thanks
Graz
"graz79" <graz79@.yahoo.co.uk> wrote in message
news:1178020439.331730.41150@.l77g2000hsb.googlegro ups.com...
> We have two database instances replicating between them.
> We are currently trying to manually grow the database files, when we
> do they are reverting back to the original size.
> Using Enterprise Manager we enter the properties and insert the new
> file size. When we come out SQL pauses and when the screen refreshes
> shows the new size.
> If we exit enterprise manager and then go back in the original size is
> being used.
> We have tried ammending the publisher then the subscriber and vice
> versa.
> Do we need to stop merge replication prior to a database file growth?
>
Not that I'm aware.
But it almost always sounds like you have auto-shrink enabled.

> Thanks
> Graz
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||That was it. Missed the autoshrink option.
Thanks
|||"graz79" <graz79@.yahoo.co.uk> wrote in message
news:1178110568.993714.26180@.o5g2000hsb.googlegrou ps.com...
> That was it. Missed the autoshrink option.
> Thanks
>
You're welcome.
And yet another reason to avoid auto-shrink ;-)
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Database growth and Replication

We have two database instances replicating between them.
We are currently trying to manually grow the database files, when we
do they are reverting back to the original size.
Using Enterprise Manager we enter the properties and insert the new
file size. When we come out SQL pauses and when the screen refreshes
shows the new size.
If we exit enterprise manager and then go back in the original size is
being used.
We have tried ammending the publisher then the subscriber and vice
versa.
Do we need to stop merge replication prior to a database file growth?
Thanks
Graz"graz79" <graz79@.yahoo.co.uk> wrote in message
news:1178020439.331730.41150@.l77g2000hsb.googlegroups.com...
> We have two database instances replicating between them.
> We are currently trying to manually grow the database files, when we
> do they are reverting back to the original size.
> Using Enterprise Manager we enter the properties and insert the new
> file size. When we come out SQL pauses and when the screen refreshes
> shows the new size.
> If we exit enterprise manager and then go back in the original size is
> being used.
> We have tried ammending the publisher then the subscriber and vice
> versa.
> Do we need to stop merge replication prior to a database file growth?
>
Not that I'm aware.
But it almost always sounds like you have auto-shrink enabled.
> Thanks
> Graz
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||That was it. Missed the autoshrink option.
Thanks|||"graz79" <graz79@.yahoo.co.uk> wrote in message
news:1178110568.993714.26180@.o5g2000hsb.googlegroups.com...
> That was it. Missed the autoshrink option.
> Thanks
>
You're welcome.
And yet another reason to avoid auto-shrink ;-)
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Database Grow Problems

I am having problems when I try to grow my database. It seems to be taken a
long time (1 hour and still going) and is also making the system
unresponsive. The CPU is at 0 but the computer is so slow nothing can be
done. This is a dual processor system with 2ghz processors. I am using the
express version and am trying to grow a database from 45 mb to the maximum
of 4096 mb.
Is this normall or is there something wrong with the hard drive, system or
database? I ran the dbcc tool and it did not report any problem with the
tables or index.
The reason I decided to grow it to the max is because my incremental grows
were slowing down my application. I figured if I set it to the maximum it
would speed things up. I didn't know growing it would take this long.
Bob
That seems excessive for just 4GB of growth but by default it will have to
zero initialize every bit in the file. This normally takes a while and
depends heavily on the hardware as to how long. If you are running on
Windows XP or Windows 2003 then you may be able to take advantage of Instant
file initialization. From BOL:
Instant file initialization is only available if the SQL Server
(MSSQLSERVER) service account has been granted SE_MANAGE_VOLUME_NAME.
Members of the Windows Administrator group have this right and can grant it
to other users by adding them to the Perform Volume Maintenance Tasks
security policy. For more information about assigning user rights, see the
Windows documentation.
Andrew J. Kelly SQL MVP
"Bob" <msgdev@.hotmail.com> wrote in message
news:%23RvjnVQVGHA.5288@.TK2MSFTNGP14.phx.gbl...
>I am having problems when I try to grow my database. It seems to be taken
>a long time (1 hour and still going) and is also making the system
>unresponsive. The CPU is at 0 but the computer is so slow nothing can be
>done. This is a dual processor system with 2ghz processors. I am using
>the express version and am trying to grow a database from 45 mb to the
>maximum of 4096 mb.
> Is this normall or is there something wrong with the hard drive, system or
> database? I ran the dbcc tool and it did not report any problem with the
> tables or index.
> The reason I decided to grow it to the max is because my incremental grows
> were slowing down my application. I figured if I set it to the maximum it
> would speed things up. I didn't know growing it would take this long.
>
> Bob
>

Database Grow Problems

I am having problems when I try to grow my database. It seems to be taken a
long time (1 hour and still going) and is also making the system
unresponsive. The CPU is at 0 but the computer is so slow nothing can be
done. This is a dual processor system with 2ghz processors. I am using the
express version and am trying to grow a database from 45 mb to the maximum
of 4096 mb.
Is this normall or is there something wrong with the hard drive, system or
database? I ran the dbcc tool and it did not report any problem with the
tables or index.
The reason I decided to grow it to the max is because my incremental grows
were slowing down my application. I figured if I set it to the maximum it
would speed things up. I didn't know growing it would take this long.
BobThat seems excessive for just 4GB of growth but by default it will have to
zero initialize every bit in the file. This normally takes a while and
depends heavily on the hardware as to how long. If you are running on
Windows XP or Windows 2003 then you may be able to take advantage of Instant
file initialization. From BOL:
Instant file initialization is only available if the SQL Server
(MSSQLSERVER) service account has been granted SE_MANAGE_VOLUME_NAME.
Members of the Windows Administrator group have this right and can grant it
to other users by adding them to the Perform Volume Maintenance Tasks
security policy. For more information about assigning user rights, see the
Windows documentation.
Andrew J. Kelly SQL MVP
"Bob" <msgdev@.hotmail.com> wrote in message
news:%23RvjnVQVGHA.5288@.TK2MSFTNGP14.phx.gbl...
>I am having problems when I try to grow my database. It seems to be taken
>a long time (1 hour and still going) and is also making the system
>unresponsive. The CPU is at 0 but the computer is so slow nothing can be
>done. This is a dual processor system with 2ghz processors. I am using
>the express version and am trying to grow a database from 45 mb to the
>maximum of 4096 mb.
> Is this normall or is there something wrong with the hard drive, system or
> database? I ran the dbcc tool and it did not report any problem with the
> tables or index.
> The reason I decided to grow it to the max is because my incremental grows
> were slowing down my application. I figured if I set it to the maximum it
> would speed things up. I didn't know growing it would take this long.
>
> Bob
>sql

Database Grow Problems

I am having problems when I try to grow my database. It seems to be taken a
long time (1 hour and still going) and is also making the system
unresponsive. The CPU is at 0 but the computer is so slow nothing can be
done. This is a dual processor system with 2ghz processors. I am using the
express version and am trying to grow a database from 45 mb to the maximum
of 4096 mb.
Is this normall or is there something wrong with the hard drive, system or
database? I ran the dbcc tool and it did not report any problem with the
tables or index.
The reason I decided to grow it to the max is because my incremental grows
were slowing down my application. I figured if I set it to the maximum it
would speed things up. I didn't know growing it would take this long.
BobThat seems excessive for just 4GB of growth but by default it will have to
zero initialize every bit in the file. This normally takes a while and
depends heavily on the hardware as to how long. If you are running on
Windows XP or Windows 2003 then you may be able to take advantage of Instant
file initialization. From BOL:
Instant file initialization is only available if the SQL Server
(MSSQLSERVER) service account has been granted SE_MANAGE_VOLUME_NAME.
Members of the Windows Administrator group have this right and can grant it
to other users by adding them to the Perform Volume Maintenance Tasks
security policy. For more information about assigning user rights, see the
Windows documentation.
Andrew J. Kelly SQL MVP
"Bob" <msgdev@.hotmail.com> wrote in message
news:%23RvjnVQVGHA.5288@.TK2MSFTNGP14.phx.gbl...
>I am having problems when I try to grow my database. It seems to be taken
>a long time (1 hour and still going) and is also making the system
>unresponsive. The CPU is at 0 but the computer is so slow nothing can be
>done. This is a dual processor system with 2ghz processors. I am using
>the express version and am trying to grow a database from 45 mb to the
>maximum of 4096 mb.
> Is this normall or is there something wrong with the hard drive, system or
> database? I ran the dbcc tool and it did not report any problem with the
> tables or index.
> The reason I decided to grow it to the max is because my incremental grows
> were slowing down my application. I figured if I set it to the maximum it
> would speed things up. I didn't know growing it would take this long.
>
> Bob
>

Sunday, March 25, 2012

Database free space: big discrepancy between sp_spaceused and EM taskpad view

I am monitoring free space in my database so I can manually grow the
data file rather than relying on autogrow. I get the free space by
using the 'unallocated space' value returned by sp_spaceused.
Today I was alerted that there was less than 2% free space remaining
in my database. I verified with sp_spaceused and it was reporting ~8GB
unallocated space in a ~500GB database. Then I checked the free space
by looking at the taskpad view for my database in Enterprise Manager.
This showed ~60GB free. I ran a profiler trace to see what EM is doing
to calculate free space but I can't tell what calculations it does,
other than to see that in addition to sp_spaceused it uses the
following two commands:
select sum(convert(float,size)) * (8192.0/1024.0) from dbo.sysfiles
and
DBCC showfilestats
Am I wrong in thinking that the 'unallocated space' and free space
reported by EM should be similar? Is one a more reliable indicator
than the other?
ThanksHi
Before using sp_spaceused run DBCC UPDATEUSAGE command
<pshroads@.gmail.com> wrote in message
news:1184779707.553225.56190@.d30g2000prg.googlegroups.com...
>I am monitoring free space in my database so I can manually grow the
> data file rather than relying on autogrow. I get the free space by
> using the 'unallocated space' value returned by sp_spaceused.
> Today I was alerted that there was less than 2% free space remaining
> in my database. I verified with sp_spaceused and it was reporting ~8GB
> unallocated space in a ~500GB database. Then I checked the free space
> by looking at the taskpad view for my database in Enterprise Manager.
> This showed ~60GB free. I ran a profiler trace to see what EM is doing
> to calculate free space but I can't tell what calculations it does,
> other than to see that in addition to sp_spaceused it uses the
> following two commands:
> select sum(convert(float,size)) * (8192.0/1024.0) from dbo.sysfiles
> and
> DBCC showfilestats
> Am I wrong in thinking that the 'unallocated space' and free space
> reported by EM should be similar? Is one a more reliable indicator
> than the other?
> Thanks
>

Database free space: big discrepancy between sp_spaceused and EM taskpad view

Thursday, March 22, 2012

Database file size question please

Hi,

I have set the DB to auto grow by 30 %. As well I have set it to
unrestricted size... However , I see the available size continually being
reduced to now less then .54 MB... Why is there not enough available ?

Gtime_to_go (camper_66@.hotmail.com) writes:
> I have set the DB to auto grow by 30 %. As well I have set it to
> unrestricted size... However , I see the available size continually being
> reduced to now less then .54 MB... Why is there not enough available ?

Where do you see thie available size?

Auto-grow does not set in, until there are no free extents at all, and a
new extent is needed.

Note that if there is no free disk space for these 30%, auto-grow will
fail.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Hi,

I see the available space in the general tab > space allocation. it shows
used as 35.5 MB and availble .53. I have checked disk space available and
it is sufficient.

r,
g
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns96C0C9EE71401Yazorman@.127.0.0.1...
> time_to_go (camper_66@.hotmail.com) writes:
> > I have set the DB to auto grow by 30 %. As well I have set it to
> > unrestricted size... However , I see the available size continually
being
> > reduced to now less then .54 MB... Why is there not enough available
?
> Where do you see thie available size?
> Auto-grow does not set in, until there are no free extents at all, and a
> new extent is needed.
> Note that if there is no free disk space for these 30%, auto-grow will
> fail.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||time_to_go (camper_66@.hotmail.com) writes:
> I see the available space in the general tab > space allocation. it shows
> used as 35.5 MB and availble .53. I have checked disk space available and
> it is sufficient.

Have you experienced any errors which claims that you are out of space?

Also, try running DBCC UPDATEUSAGE and then sp_spaceused in Query Analyzer.
Enterprise Manager is not always trustable for size information.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

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 growth and Replication

Database growth and Replication

Database growth and Replication

Database Grow Problems

Database Grow Problems

Database Grow Problems

Sunday, March 25, 2012

Database free space: big discrepancy between sp_spaceused and EM taskpad view

Database free space: big discrepancy between sp_spaceused and EM taskpad view

Thursday, March 22, 2012

Database file size question please

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