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 vs. Table unused space

Hi,
I've had a query from an analyst regarding database free space and table
unused space. We have a database made up of 3 filegroups; with total sizes
of 100GB, 25GB, & 27GB , and free space is reported as 65MB, 70MB, & 2MB
respectively.
Now, if he executes "sp_spaceused" against one specific table that he's
working with (trying to reduce size by improving purging routines, etc), the
n
it reports the data and index sizes, but also reports over 2GB of "unused
space". This is after running an updateusage, etc.
What is this referring to? Can it be freed to the OS? Why does it not show
in the database free space (as obviously 2GB unused space can't fit in this
database's free space)? Any light shed on this would be appreciated.
Thanks,
daveThe unused value reported by sp_spaceused are pages on extents that are owne
d by that particular
objects, but the pages are currently not in use. So the pages can be used by
the object that owns
the extent in question but not by other extents.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DavidCur" <cdf_nospam_@.webmail.co.za> wrote in message
news:2F6AA526-E215-4EC7-AEBA-7C454F937FC4@.microsoft.com...
> Hi,
> I've had a query from an analyst regarding database free space and table
> unused space. We have a database made up of 3 filegroups; with total size
s
> of 100GB, 25GB, & 27GB , and free space is reported as 65MB, 70MB, & 2MB
> respectively.
> Now, if he executes "sp_spaceused" against one specific table that he's
> working with (trying to reduce size by improving purging routines, etc), t
hen
> it reports the data and index sizes, but also reports over 2GB of "unused
> space". This is after running an updateusage, etc.
> What is this referring to? Can it be freed to the OS? Why does it not sh
ow
> in the database free space (as obviously 2GB unused space can't fit in thi
s
> database's free space)? Any light shed on this would be appreciated.
> Thanks,
> dave|||"Tibor Karaszi" wrote:

> The unused value reported by sp_spaceused are pages on extents that are ow
ned by that particular
> objects, but the pages are currently not in use. So the pages can be used
by the object that owns
> the extent in question but not by other extents.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
Yes, I understand that - but I wanted to know if there was a way to free
that unused space up? What governs how much unused space a table has? Has
it got something to do with the FILLFACTOR of indexes? I'm just trying to
understand how this table can have so much (>2GB) unused space.
Thanks,
dave|||Higher fillfactor will mean less pages. But I don't think that less fuller p
ages will add to the
unused value. I believe that only not allocated pages on uniform extents wil
l. Check out the source
code for sp_spaceused (etc.) to be certain. I guess that an index rebuild (o
r reorg) can less the
unused value.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DavidCur" <cdf_nospam_@.webmail.co.za> wrote in message
news:EDD26B2C-1B3C-43AF-911D-2BAD4486C373@.microsoft.com...
> "Tibor Karaszi" wrote:
>
>
> Yes, I understand that - but I wanted to know if there was a way to free
> that unused space up? What governs how much unused space a table has? Ha
s
> it got something to do with the FILLFACTOR of indexes? I'm just trying to
> understand how this table can have so much (>2GB) unused space.
> Thanks,
> dave