database free spaces

I have a database total size 2710 MB. It is 2699 MB used and 11 MB free.
This is what I see it in the view taskpad of the database. I did setup the
database for unrestrict growth. But the free spaces so small, do I need to
adjust it? If I do, I need it done in a hurry. Can someone provide
sugestions? Thanks.
--
GigiFist, the report might be based on old information. Read up on DBCC UPDATEUS
AGE. And to increase the
file size, you use ALTER DATABASE ... MODIFY FILE... Or, use EM to specify
a size larger than the
current size.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Gigi" <gigi@.discussions.mcirosoft.com> wrote in message
news:45B66CA4-FE21-4019-88EF-C9E3507C47EB@.microsoft.com...
>I have a database total size 2710 MB. It is 2699 MB used and 11 MB free.
> This is what I see it in the view taskpad of the database. I did setup th
e
> database for unrestrict growth. But the free spaces so small, do I need t
o
> adjust it? If I do, I need it done in a hurry. Can someone provide
> sugestions? Thanks.
> --
> Gigi

database free spaces

I have a database total size 2710 MB. It is 2699 MB used and 11 MB free.
This is what I see it in the view taskpad of the database. I did setup the
database for unrestrict growth. But the free spaces so small, do I need to
adjust it? If I do, I need it done in a hurry. Can someone provide
sugestions? Thanks.
Gigi
Fist, the report might be based on old information. Read up on DBCC UPDATEUSAGE. And to increase the
file size, you use ALTER DATABASE ... MODIFY FILE... Or, use EM to specify a size larger than the
current size.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Gigi" <gigi@.discussions.mcirosoft.com> wrote in message
news:45B66CA4-FE21-4019-88EF-C9E3507C47EB@.microsoft.com...
>I have a database total size 2710 MB. It is 2699 MB used and 11 MB free.
> This is what I see it in the view taskpad of the database. I did setup the
> database for unrestrict growth. But the free spaces so small, do I need to
> adjust it? If I do, I need it done in a hurry. Can someone provide
> sugestions? Thanks.
> --
> Gigi
sql

database free spaces

I have a database total size 2710 MB. It is 2699 MB used and 11 MB free.
This is what I see it in the view taskpad of the database. I did setup the
database for unrestrict growth. But the free spaces so small, do I need to
adjust it? If I do, I need it done in a hurry. Can someone provide
sugestions? Thanks.
--
GigiFist, the report might be based on old information. Read up on DBCC UPDATEUSAGE. And to increase the
file size, you use ALTER DATABASE ... MODIFY FILE... Or, use EM to specify a size larger than the
current size.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Gigi" <gigi@.discussions.mcirosoft.com> wrote in message
news:45B66CA4-FE21-4019-88EF-C9E3507C47EB@.microsoft.com...
>I have a database total size 2710 MB. It is 2699 MB used and 11 MB free.
> This is what I see it in the view taskpad of the database. I did setup the
> database for unrestrict growth. But the free spaces so small, do I need to
> adjust it? If I do, I need it done in a hurry. Can someone provide
> sugestions? Thanks.
> --
> Gigi

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

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
>