dbTalk Databases Forums  

VLDMThreshold and 64 bit MAS

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


Discuss VLDMThreshold and 64 bit MAS in the microsoft.public.sqlserver.olap forum.



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

Default VLDMThreshold and 64 bit MAS - 11-05-2004 , 05:06 AM






Hello Everyone:

We are being told that increasing the size of VLDMThreshold (way beyond the
64 MB default) on the 64-bit MAS has a very positive effect on performance.

I was under the impression that the 64 bit platform did not use
the large dimension manager process (msmdvldm.exe).

Is the parameter VLDMThreshold used for anything else on the 64-bit MAS
or does changing this parameter make no difference on the 64-bit?

Please help with this subject as we cannot find much available
information.

Best regards,
Mario

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: VLDMThreshold and 64 bit MAS - 11-07-2004 , 02:05 AM






VLDM is disabled on 64-bit SSAS. Changing the registry setting will have
absolutely no effect.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Mario" <mtechera (AT) all-bi (DOT) com> wrote

Quote:
Hello Everyone:

We are being told that increasing the size of VLDMThreshold (way beyond
the
64 MB default) on the 64-bit MAS has a very positive effect on
performance.

I was under the impression that the 64 bit platform did not use
the large dimension manager process (msmdvldm.exe).

Is the parameter VLDMThreshold used for anything else on the 64-bit MAS
or does changing this parameter make no difference on the 64-bit?

Please help with this subject as we cannot find much available
information.

Best regards,
Mario



Reply With Quote
  #3  
Old   
Mario
 
Posts: n/a

Default Re: VLDMThreshold and 64 bit MAS - 11-08-2004 , 04:17 AM



Dave,

Thanks for the answer! That saves me plenty of testing and experimenting...

Regards,
Mario

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Quote:
VLDM is disabled on 64-bit SSAS. Changing the registry setting will have
absolutely no effect.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Mario" <mtechera (AT) all-bi (DOT) com> wrote in message
news:92cf72b5.0411050306.777070c1 (AT) posting (DOT) google.com...
Hello Everyone:

We are being told that increasing the size of VLDMThreshold (way beyond
the
64 MB default) on the 64-bit MAS has a very positive effect on
performance.

I was under the impression that the 64 bit platform did not use
the large dimension manager process (msmdvldm.exe).

Is the parameter VLDMThreshold used for anything else on the 64-bit MAS
or does changing this parameter make no difference on the 64-bit?

Please help with this subject as we cannot find much available
information.

Best regards,
Mario

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.