Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server 2012 SSAS .. 'Yes we can' use one instance for both the tabular and multi dimensional models

As most of us are aware, each instance of SSAS 2012 may be run in either tabular or multidimensional mode (and not both). This necessitates having 2 instances should you wish to do both.

HOWEVER, I picked up something interesting at the PASS Nordic Rally. There is an UNSUPPORTED 'toggle' that you can change in the MSMDSRV.INI File which will allow you to use the same instance in both modes, albeit one mode at a time. Doing so DOES necessitate either a stopping and restarting of the service and/or restarting the box. The person that put me onto it works for a major US consulting firm and does this all the time.

Here is the link to the necessary documentation from the books online.

http://msdn.microsoft.com/en-us/library/gg471594.aspx

regards Steve

 

Comments

Posted by drewskyjones on 1 November 2012

What would be the use case for "toggling" the deployment mode?

Leave a Comment

Please register or log in to leave a comment.