May 31, 2012 at 5:17 am
Hello!
I have a fairly large dimension, about 74,000,000 rows. The dimension has two attributes:
> Keyword: using a "NameColumn" of type string and of size NVARCHAR(125)). the "KeyColumns" is an INT (KeywordID).
> IsBrand: using a "KeyColumns" of type boolean.
There is no custom hierarchies and IsBrand has a many-to-one Flexible relationship with the Keyword attribute.
The dimension had no problems and it was processing absolutely fine, but when the size of the .aastore file exceeded the 4GB limit, it started to through errors when being processed.
According to MS, to resolve this issue I needed to change the StringStoresCompatbilityLevel to 1100 instead of 1050 (which only allowed 4GB max) on the dimension itself (the cube DB had that property already set to 1100), when I did that and tried to reprocess the cube, the dimension just sat there for hours (literally 16hrs) and did not finish processing.
I tried to deploy the cube on a new DB, no luck, same issue.
My system is a VM box:
> Win08 R2 SP1
> 6 GB Memory
> 4 CPUs
> SSAS + SQL 2012
I've been monitoring the resources on that box throughout the operation and there are alot of reads to the dimension's files, writes happen very infrequently when the sizes of the files grew beyond the following:
> aastore file is 4,600 MB
> ahstore file is 1,150 MB
> khstore file is 1,100 MB
Does any1 know why this is happening? driving me nuts!
It seems if I put back the StringStoresCompatbilityLevel to 1050 and cut down the dimension data (below 4GB) it works ok, but I actually need to have all that data in the dimension, is there a work around? maybe somehow split a dimension onto multiple files instead of changing the stores?. any help is really appreciated as iv spent days on this and got nowhere.
Thanks!
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply