Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

2nd OLAP instance need other disk resource Expand / Collapse
Author
Message
Posted Wednesday, October 23, 2013 7:57 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
I have an enterprise edition SQL Server on an active/passive cluster with OLAP and RSS and SQL Server. I need to install another OLAP instance for tabular model. Am I correct that when setting up another instance of OLAP I will need another network name and another disk resource setup for this instance


Post #1507629
Posted Wednesday, October 30, 2013 7:32 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 9:48 PM
Points: 3,100, Visits: 788
Yes, it sucks but on a cluster that is the case. It is for failover and usually cluster setups should have a new instance on a different cluster node.

The plus is you will not have to install a new instance, only the server and disk resource for a second SSAS install (Multidimension can be on default/named instance and Tabular on a new instance with no sql server service).

Thomas


Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #1509770
Posted Wednesday, October 30, 2013 7:36 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
is there a way to limit the memory of this 2nd instance of OLAP. I know how to do this in the database engine side, but how can I do this on a 2nd instance of OLAP?


Post #1509774
Posted Wednesday, October 30, 2013 7:39 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 9:48 PM
Points: 3,100, Visits: 788
yes, this guide should help you

http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc

thomas


Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #1509781
Posted Wednesday, October 30, 2013 7:45 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
thanks would this be applicable to 2012?


Post #1509784
Posted Wednesday, October 30, 2013 9:23 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 9:48 PM
Points: 3,100, Visits: 788
yes

Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #1509837
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse