dbTalk Databases Forums  

Cube Storage ---Advise

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Cube Storage ---Advise in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
 
Posts: n/a

Default Cube Storage ---Advise - 02-09-2004 , 05:04 PM






Hi,
Can anyone please advise me on this
I have 5 Dimensions with 5--7 members. and a Fact table
of 1.5 million rows. Ideally what should be my storage
size i.e what should i set my performance boost (I will
be using MOLAP as my storage mode). Shall I use 50%
performance boost. (In this case am I missing data at
run time).

Thanks

Steve

Reply With Quote
  #2  
Old   
Sean Boon [MS]
 
Posts: n/a

Default Re: Cube Storage ---Advise - 02-09-2004 , 05:10 PM






Hi Steve,

I'd recommend the following whitepaper for you. The topic is covered in
depth.

http://www.microsoft.com/technet/tre...e/ANSvcsPG.asp


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

<anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,
Can anyone please advise me on this
I have 5 Dimensions with 5--7 members. and a Fact table
of 1.5 million rows. Ideally what should be my storage
size i.e what should i set my performance boost (I will
be using MOLAP as my storage mode). Shall I use 50%
performance boost. (In this case am I missing data at
run time).

Thanks

Steve



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.