Solved

Installing Multi Dimension instance and Tabular instance in a single machine SQL server

Posted on 2016-11-01
6
27 Views
Last Modified: 2016-11-10
Hi,

Is anyone knows that two instance ( Tabular and Multi-Dimension) that can install  a single server? if so, is there any limitation this will be deprecated  beyond 2014?
0
Comment
Question by:ken hanse
  • 3
  • 3
6 Comments
 
LVL 23

Expert Comment

by:Pawan Kumar
ID: 41869515
1. Yes its possible. You can have a default instance and a named instance. You have to install SSAS as a new instance.

You just have to simply install another instance of SSAS.

2. By the way, It is not a good practice :) to install the both on the same server.

I dont think we have any limitation beyond 2014.
1
 
LVL 23

Expert Comment

by:Pawan Kumar
ID: 41871574
Hi ken hanse,
Do you have more question(s) on this?

Regards,
Pawan
0
 

Author Comment

by:ken hanse
ID: 41873116
installation both in a single server is not recommended by Microsoft?

Does it's impact performance of the server?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:ken hanse
ID: 41876406
Hi Pawan Kumar Khowal

is installation both in a single server not recommended by Microsoft?

Does it's impact performance of the server?

thanks
0
 
LVL 23

Accepted Solution

by:
Pawan Kumar earned 500 total points
ID: 41876573
If both are actually used on the server then its difficult to manage hardware configuration, because one setting may or may not optimal for the other one.

Basically organizations either choose - Tabular and Multi Dimensional, both are used for the same purpose with few differences.

E.g. - For tabular you need large amount of RAM as queries will be executed in the RAM, internally all the data from the tables loaded in the RAM and then the query executes and returns the result.

If your hardware is really really good then Multi-instance can scale-up by installing multiple server instances on the same Server. Basically it requires lot of testing with real time data.

Microsoft say that we can have tabular and multi dimensional on the same server. Read more through the below url-

For more details-
https://msdn.microsoft.com/en-us/library/hh230806.aspx

Hope it helps !
0
 

Author Closing Comment

by:ken hanse
ID: 41882956
thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Cloud-based technologies and services will continue to grow in popularity in 2017 thanks to the simple, scalable and cost-effective solutions they deliver. Here are three areas where cloud adoption is poised to really take off.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

939 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now