Showing posts with label including. Show all posts
Showing posts with label including. Show all posts

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.c...p?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:
>
and[vbcol=seagreen]
an[vbcol=seagreen]
me[vbcol=seagreen]
>.
>sql

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
>.
>

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