Home > Archive > MS SQL Server OLAP > March 2006 > Cube size









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Cube size
gayu

2006-03-23, 7:43 am

Hi all,

Where can I look for the actual space consumed by a cube on the disk?

Thanks,
Gayatri.

Dave Wickert [MSFT]

2006-03-24, 11:39 am

Use Windows Explorer on the folder. There is no internal property in AS that
exposes this information.
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"gayu" <gayatri.kulkarni@gmail.com> wrote in message
news:1143114448.893782.38200@e56g2000cwe.googlegroups.com...
> Hi all,
>
> Where can I look for the actual space consumed by a cube on the disk?
>
> Thanks,
> Gayatri.
>



ktrock

2006-03-24, 8:26 pm

Can you not get the space consumed by looking at the 1st screen within Design
Storage?

Ken

"Dave Wickert [MSFT]" wrote:

> Use Windows Explorer on the folder. There is no internal property in AS that
> exposes this information.
> --
> Dave Wickert [MSFT]
> dwickert@online.microsoft.com
> Program Manager
> BI Systems Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "gayu" <gayatri.kulkarni@gmail.com> wrote in message
> news:1143114448.893782.38200@e56g2000cwe.googlegroups.com...
>
>
>

Dave Wickert [MSFT]

2006-03-24, 8:26 pm

That is an *estimate* based on a statistical algorithm based on an
conservative-estimated data distribution. After all, you haven't processed
anything yet. The actual distribution can vary greatly. It is not the
physical space taken.
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"ktrock" <ktrock@discussions.microsoft.com> wrote in message
news:BD916C02-F099-47B7-9147- F038BDDC9698@microso
ft.com...[color=darkred]
> Can you not get the space consumed by looking at the 1st screen within
> Design
> Storage?
>
> Ken
>
> "Dave Wickert [MSFT]" wrote:
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com