I want to get the Database used space info (Count in the
Gray bar NOT the blue) in daily bases. How can I find this
info to put it into a query/script to run it every day. I
don't want the log info, just the dataspace used. Anyone
has an idea or a script to share.
Thanks for any help.Undocumented command DBCC SHOWFILESTATS. I think that is how Enterprise
Mangler populates the graph. I originally found this by reverse engineering
a third-party monitoring tool. I wrote a quick wrapper and dumped the
results to a table (WITH TABLERESULTS works) and report on percentages, etc.
As always, use undocumented DBCC commands at your own risk.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"George" <anonymous@.discussions.microsoft.com> wrote in message
news:011101c3d614$c6dc9260$a401280a@.phx.gbl...
> I want to get the Database used space info (Count in the
> Gray bar NOT the blue) in daily bases. How can I find this
> info to put it into a query/script to run it every day. I
> don't want the log info, just the dataspace used. Anyone
> has an idea or a script to share.
> Thanks for any help.|||I think that is it......
Thanks.
>--Original Message--
>Undocumented command DBCC SHOWFILESTATS. I think that is
how Enterprise
>Mangler populates the graph. I originally found this by
reverse engineering
>a third-party monitoring tool. I wrote a quick wrapper
and dumped the
>results to a table (WITH TABLERESULTS works) and report
on percentages, etc.
>As always, use undocumented DBCC commands at your own
risk.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>
>"George" <anonymous@.discussions.microsoft.com> wrote in
message
>news:011101c3d614$c6dc9260$a401280a@.phx.gbl...
>> I want to get the Database used space info (Count in the
>> Gray bar NOT the blue) in daily bases. How can I find
this
>> info to put it into a query/script to run it every day.
I
>> don't want the log info, just the dataspace used. Anyone
>> has an idea or a script to share.
>> Thanks for any help.
>
>.
>|||This should help.
http://www.databasejournal.com/features/msaccess/article.ph
p/1467791
Best Regards
Thirumal Reddy Maram
>--Original Message--
>I want to get the Database used space info (Count in the
>Gray bar NOT the blue) in daily bases. How can I find
this
>info to put it into a query/script to run it every day. I
>don't want the log info, just the dataspace used. Anyone
>has an idea or a script to share.
>Thanks for any help.
>.
>
