| Author |
Memory Requirement for Attributes of Members of Hierarchy
|
|
| Raja Nadar 2005-11-29, 3:23 am |
| Hey,
Can anyone tell me what are the implications on memory usage on adding a
attribute to a member of a dimension.
I have added Year attribute to Quarter Member of Date Dimension, Year and
Quarter to Month and so on. i need to know how much effect on memory storage
will this have?
Thanks
Raja Nadar
| |
| Denny Lee 2005-11-29, 3:23 am |
| Hmm, you can view the dimension memory calculation for Analysis Services
2000 at:
http://www.ambresso.com/docs/ Enter...ide%202
5
--
HTH!
Denny Lee
< dennyglee_at_hotmail
_dot_com>
Blog at:: http://spaces.msn.com/members/denster/
"Raja Nadar" <RajaN@MAQSoftware.com> wrote in message
news:%23Y1$a5K9FHA.912@TK2MSFTNGP10.phx.gbl...
> Hey,
>
> Can anyone tell me what are the implications on memory usage on adding a
> attribute to a member of a dimension.
>
> I have added Year attribute to Quarter Member of Date Dimension, Year and
> Quarter to Month and so on. i need to know how much effect on memory
> storage will this have?
>
> Thanks
> Raja Nadar
>
| |
| Raja Nadar 2005-11-29, 3:23 am |
| Thanks for the ppt Denny.
Sorry i forgot to mention i am working on SQL Server 2005, but still the
document is really useful. If you know any resource in 2005 do let me know
Thanks once again
Raja Nadar
"Denny Lee" <dennyglee@hotmail.com> wrote in message
news:%23uX$VpL9FHA.3880@TK2MSFTNGP12.phx.gbl...
> Hmm, you can view the dimension memory calculation for Analysis Services
> 2000 at:
> http://www.ambresso.com/docs/ Enter...ide%202
5
>
> --
> HTH!
> Denny Lee
> < dennyglee_at_hotmail
_dot_com>
>
> Blog at:: http://spaces.msn.com/members/denster/
>
>
>
> "Raja Nadar" <RajaN@MAQSoftware.com> wrote in message
> news:%23Y1$a5K9FHA.912@TK2MSFTNGP10.phx.gbl...
>
>
| |
| Darren Gosbell 2005-11-29, 7:23 am |
| You should note that AS2k5 does not cache every dimension in RAM at
startup like AS2k does. It will load and cache them as needed.
--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <u5NUNKM9FHA.1184@TK2MSFTNGP12.phx.gbl>,
RajaN@MAQSoftware.com says...
> Thanks for the ppt Denny.
>
> Sorry i forgot to mention i am working on SQL Server 2005, but still the
> document is really useful. If you know any resource in 2005 do let me know
>
> Thanks once again
> Raja Nadar
>
>
> "Denny Lee" <dennyglee@hotmail.com> wrote in message
> news:%23uX$VpL9FHA.3880@TK2MSFTNGP12.phx.gbl...
>
>
>
| |
| Sumit Pilankar 2005-11-29, 7:23 am |
| Thanks Darren
Also, as per the link that Denny gave and another link
http://www.stlssug.org/docs/advance...pert
ies,
the inference is member properties just introduce increase in storage for
structure, but it does not increase with increase in number of records.
Bye
Sumit Pilankar
"Darren Gosbell" <jam@newsgroups.nospam> wrote in message
news:MPG. 1df6cc63c4d01bfe9897
f8@news.microsoft.com...[color=darkred]
> You should note that AS2k5 does not cache every dimension in RAM at
> startup like AS2k does. It will load and cache them as needed.
>
> --
> Regards
> Darren Gosbell [MCSD]
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <u5NUNKM9FHA.1184@TK2MSFTNGP12.phx.gbl>,
> RajaN@MAQSoftware.com says...
|
|
|
|