Subject | Re: [firebird-support] Re: How much percentage of a database space is a table contents taking. |
---|---|
Author | Thomas Steinmaurer |
Post date | 2015-11-30T06:40:50Z |
rgilland1966@... [firebird-support] schrieb am 30.11.2015 05:10:
So, basically, with gstat you get everything you need:
* DB total allocated pages
* Allocated pages per table
* Allocated pages per index (might be important contributors size-wise)
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
> Thanks Helen,That information is also available on the database header page, which can be extracted by gstat -h
>
> I finally taught myself how to use isql.exe in order to access this
> information.
> What a strange tool.
>
>
> Then I found that both IBOConsole.exe and Upscene's Database Workbench show
> this information in Database Properties. And it is called "Allocated DB Pages"
So, basically, with gstat you get everything you need:
* DB total allocated pages
* Allocated pages per table
* Allocated pages per index (might be important contributors size-wise)
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.