none
The service cannot be started: The following system error occurred: Insufficient system resources exist to complete the requested service.

    Question

  • 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 SSRS
    • 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 Application log:

    Log Name:      Application
    Source:        MSOLAP$SHAREPOINTT
    Date:          8/28/2013 1:48:10 PM
    Event ID:      0
    Task Category: (289)
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      computername
    Description:
    The service cannot be started: The following system error occurred:  Insufficient system resources exist to complete the requested service. 
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="MSOLAP$SHAREPOINTT" />
        <EventID Qualifiers="49441">0</EventID>
        <Level>2</Level>
        <Task>289</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2013-08-28T20:48:10.000000000Z" />
        <EventRecordID>9322</EventRecordID>
        <Channel>Application</Channel>
        <Computer>computername</Computer>
        <Security />
      </System>
      <EventData>
        <Data>The following system error occurred:  Insufficient system resources exist to complete the requested service. </Data>
      </EventData>
    </Event>

    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:

    http://technet.microsoft.com/en-us/library/ms175672.aspx

    Memory and Processor Requirements

    Analysis Services needs more memory and processor resources in the following cases:
    When the number of instances of Analysis Services on a single computer increases.

    This lead us to think that we might have a resource problem, so we doubled the memory from 4GB to 8GB, but it made no difference.  Then we doubled the cores from 2 to 4 and still the same error.

    Is there a hard product limit to the number of instances of SSAS?

    http://technet.microsoft.com/en-us/library/ms365363.aspx doesn't mention hard instance limits.

    Wednesday, August 28, 2013 9:12 PM

Answers