Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Analysis About Dimensions


Analysis About Dimensions

Author
Message
Ramunas Balukonis
Ramunas Balukonis
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rbalu



Duane Lawrence
Duane Lawrence
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 113
I would really like to follow the direction provided, but I don't have a copy of the "food mart 2000" database.  Thus your article brings no value to me.  I can't learn by doing, it does not explain what analysis service is about.  It is just step by step instructions.
Ramunas Balukonis
Ramunas Balukonis
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 1

You can try with any other cube of your database.

Ramunas





wardemonous
wardemonous
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 4
Hi, the file fn_resolve_dataset.txt seems to be missing, may I have a copy of it?

I'm doing performance tuning in a SQL Server w/ Analysis Services 2000 (all 32bit) in a Windows 2000 Advanced Server. Is there any way I can query the biggest Dimensions there is amongst the different databases in Analysis Services? Or this can only be done by looking at the "dimension files" in each database folder? (a bit tedious because there are around 100 analysis services databases)

Also, can I query if each dimensions or cubes are MOLAP, ROLAP or HOLAP? I just need to know the count for each in all databases available.

Lastly, a performance tuning question, say I have a Windows 2000 Advanced Server with /3GB switch enabled with 4GB of physcail RAM, and with the following settings:

HighMemoryLimit / Memory Conservation Threshold = 2600 mb
MinimumMemoryLimit / Minimum Allocated Memory = 800 mb
Read-Ahead Buffer Size = 16mb
Process Buffer Size = 256 mb
VLDMThreshold = 50 mb
I also have SQL Server Enterprise 2000 and Analysis Services 32-bit installed in the same server.

Now, my question is, will the Analysis Service's HighMemoryLimit account each memory for every dimensions exceeding VLDMThreshold value? Or the HighMemoryLimit is just for the main process (msmdsrv.exe)?

Another thing that I'm a bit confused about is that for example, Analysis Services takes up say 2000mb, and SQL Server takes up 1700mb, so that's 3700mb (out of 4000mb physical ram usage). Now if each large dimensions that exceeds the VLDMThreshold value is not part of the HighMemoryLimit, then say I have 10 dimensions exceeding the VLDMThreshold value with 50mb each, so that's 500mb, then the total memory used is now 3700+500 = 4200mb (out of 4000mb physical ram). Will this be an issue? Or will Analysis Services just page out unused memory? In this scenario, will it help if I place say a total of 8000mb of physical ram in a Windows 2000 Advance Server - given that more and more VLD will come into play? (noting that AWE is not supported by Analysis Services) ; or is it just that I have reach the architectural limit for both Windows 2000 Advanced Server and Analysis Services 32-bit?

And most importantly, any advice on how to not crash our servers due to "out of memory" issues?

Will decreasing the HighMemoryLimit help? So that the "cleaner thread" will begin cleaning in a more earlier time? Right now the goal is "availability", rather than query performance. Or will decreasing VLDMTreshold value help as this will spawn several msmdvldm.exe that has its own virtual memory space, saving the main process msmdsrv.exe from getting out of memory?


Best Regards,
Henry Wu
ashaysutaria
ashaysutaria
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 21
Can somebody provide me the copy of the store proc. fn_resolve_dataset.txt


Its urgent!!!!!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search