Wednesday, March 21, 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
Jim
Have a look at this:
http://www.sql-server-performance.co...?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[vbcol=seagreen]
>/Magnus
>"Jimbo" wrote:
and[vbcol=seagreen]
an[vbcol=seagreen]
me
>.
>
sql

No comments:

Post a Comment