Thursday, March 22, 2012

Database Size

Dear All,
I have been asked to disk space / show growth rates for
our database, including Tables, Indexes both Clustered and
Non clustered, plus anything else I can think of.
I can easily calculate the size of the table / page
however I cannot find out how to calculate the size of an
index. Can anyone help with either the formula or point me
to a resourse.
Thanks in Advance
JimHave a look at this:
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4924
/Magnus
"Jimbo" wrote:
> Dear All,
> I have been asked to disk space / show growth rates for
> our database, including Tables, Indexes both Clustered and
> Non clustered, plus anything else I can think of.
> I can easily calculate the size of the table / page
> however I cannot find out how to calculate the size of an
> index. Can anyone help with either the formula or point me
> to a resourse.
> Thanks in Advance
> Jim
>|||Thanks Magnus.
Jim
>--Original Message--
>Have a look at this:
>http://www.sql-server-performance.com/forum/topic.asp?
TOPIC_ID=4924
>/Magnus
>"Jimbo" wrote:
>> Dear All,
>> I have been asked to disk space / show growth rates for
>> our database, including Tables, Indexes both Clustered
and
>> Non clustered, plus anything else I can think of.
>> I can easily calculate the size of the table / page
>> however I cannot find out how to calculate the size of
an
>> index. Can anyone help with either the formula or point
me
>> to a resourse.
>> Thanks in Advance
>> Jim
>.
>

No comments:

Post a Comment