On a Windows Server 2012 virtual machine (vmware) with 4GB of memory and 2 virtual processors (1 socket) we installed the following SQL Server 2012 SP1 instances:
3x SSAS tabular mode
3x SSAS multidimensional mode
1x SSAS PowerPivot mode
3x database engines
3x SQL agents
1x SQL Browser
3x full-text filter daemon launcher
No data nor databases in any instances yet. We can use SQL Server Configuration Manager to start everything except for one of the SSAS tabular mode instances. If we attempt to start the one instance that is stopped, we get this error in the Windows
Log Name: Application
Date: 8/28/2013 1:48:10 PM
Event ID: 0
Task Category: (289)
The service cannot be started: The following system error occurred: Insufficient system resources exist to complete the requested service.
<Provider Name="MSOLAP$SHAREPOINTT" />
<TimeCreated SystemTime="2013-08-28T20:48:10.000000000Z" />
<Data>The following system error occurred: Insufficient system resources exist to complete the requested service. </Data>
If we stop any one of the other tabular instances, we can start the instance that had the error when starting. So we can only have 2 of 3 tabular mode SSAS instances running at one time. Also, if we stop the PowerPivot instance, we can start
all three tabular mode instances simultaneously. Also, if we stop all 3 of the multidimensional instances, we can start all three tabular and the one Power
We searched for guidance on the number of SSAS instances, and didn't find much. The closest specification we could find was this page:
If the memory and processor resources are not enough to start SQL instance, we will get the error message you posted above. In this case, please open "Task Manager" to check that you have sufficient memory and processor resources. If not, please increase
memory and processor to avoid this issue.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.