How to determine % of free space

Ok I can't seem to find an answer to this question. I have a NDF file in a
second file group and want to know how much space it used or how much space
is free. Can I do this? If so how? I've just got to be missing it.
Thanks,
PaulWThis isn't documented, but easy to use:
DBCC SHOWFILESTATS
For 2005, there are also a bunch of dynamic management views, and I assume that one of them can give
you the answer.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Widner" <paul_widner@.hotmail.com> wrote in message
news:uC3vnSltGHA.1224@.TK2MSFTNGP03.phx.gbl...
> Ok I can't seem to find an answer to this question. I have a NDF file in a second file group and
> want to know how much space it used or how much space is free. Can I do this? If so how? I've
> just got to be missing it.
> Thanks,
> PaulW
>|||Maybe not what you wanted but - DBCC SHOWFILESTATS will show it in
extents, but not KB....
Paul Widner wrote:
> Ok I can't seem to find an answer to this question. I have a NDF file in a
> second file group and want to know how much space it used or how much space
> is free. Can I do this? If so how? I've just got to be missing it.
> Thanks,
> PaulW|||Sorry about that Tibor, I should have hit refresh! ;)
SGCSNA wrote:
> Maybe not what you wanted but - DBCC SHOWFILESTATS will show it in
> extents, but not KB....
>
> Paul Widner wrote:
> > Ok I can't seem to find an answer to this question. I have a NDF file in a
> > second file group and want to know how much space it used or how much space
> > is free. Can I do this? If so how? I've just got to be missing it.
> >
> > Thanks,
> > PaulW|||No problem. Happens to all of us, all of the time. Also, refresh might not help, as you might be
connected to a different news server than I am, and replication between the news server incurs a
delay. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SGCSNA" <sean.gorman@.computershare.com> wrote in message
news:1154540131.071946.269940@.m79g2000cwm.googlegroups.com...
> Sorry about that Tibor, I should have hit refresh! ;)
> SGCSNA wrote:
>> Maybe not what you wanted but - DBCC SHOWFILESTATS will show it in
>> extents, but not KB....
>>
>> Paul Widner wrote:
>> > Ok I can't seem to find an answer to this question. I have a NDF file in a
>> > second file group and want to know how much space it used or how much space
>> > is free. Can I do this? If so how? I've just got to be missing it.
>> >
>> > Thanks,
>> > PaulW
>|||Are those extents in 8k pages?
Paul
"SGCSNA" <sean.gorman@.computershare.com> wrote in message
news:1154540044.752066.187980@.b28g2000cwb.googlegroups.com...
> Maybe not what you wanted but - DBCC SHOWFILESTATS will show it in
> extents, but not KB....
>
> Paul Widner wrote:
>> Ok I can't seem to find an answer to this question. I have a NDF file in
>> a
>> second file group and want to know how much space it used or how much
>> space
>> is free. Can I do this? If so how? I've just got to be missing it.
>> Thanks,
>> PaulW
>|||An extent is 64K. A page is 8k or 8192 bytes. Pages go into extents.
Paul Widner wrote:
> Are those extents in 8k pages?
> Paul
> "SGCSNA" <sean.gorman@.computershare.com> wrote in message
> news:1154540044.752066.187980@.b28g2000cwb.googlegroups.com...
> > Maybe not what you wanted but - DBCC SHOWFILESTATS will show it in
> > extents, but not KB....
> >
> >
> > Paul Widner wrote:
> >> Ok I can't seem to find an answer to this question. I have a NDF file in
> >> a
> >> second file group and want to know how much space it used or how much
> >> space
> >> is free. Can I do this? If so how? I've just got to be missing it.
> >>
> >> Thanks,
> >> PaulW
> >