Forum Discussion

SrinivasaManiPrabhakar's avatar
SrinivasaManiPrabhakar
Copper Contributor
Nov 14, 2019

Error in Starting SSAS Tabluar Service in Windows Server 2012 R2

Hi All,

 

I am facing issue while starting up Sql Server Analysis service in Windows Server 2012 R2.  My Sql Server version is Sql Server 2016 Enterprise edition.  I am getting error "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details." when i am running form Sql server configuration manager.

 

For the service account which running by Analysis services it is part of local Administrators group.

 

Please help me to solve this.

 

Thanks in advance.

  • renefk's avatar
    renefk
    Copper Contributor
    Nov 20, 2019
    Hey,

    Please ensure there is enough memory available for the Service to start, If there are other services on the Server, ex. SQL, then leave 10+ G memory free for the SSAS service.. depending on your configuration

    /regards
      • renefk's avatar
        renefk
        Copper Contributor
        Nov 20, 2019
        yes, but can you elaborate on the amount allocated to other resources?


        Function Test-MemoryUsage {
        [cmdletbinding()]
        Param()

        $os = Get-Ciminstance Win32_OperatingSystem
        $pctFree = [math]::Round(($os.FreePhysicalMemory/$os.TotalVisibleMemorySize)*100,2)

        if ($pctFree -ge 45) {
        $Status = "OK"
        }
        elseif ($pctFree -ge 15 ) {
        $Status = "Warning"
        }
        else {
        $Status = "Critical"
        }

        $os | Select @{Name = "Status";Expression = {$Status}},
        @{Name = "PctFree"; Expression = {$pctFree}},
        @{Name = "FreeGB";Expression = {[math]::Round($_.FreePhysicalMemory/1mb,2)}},
        @{Name = "TotalGB";Expression = {[int]($_.TotalVisibleMemorySize/1mb)}}

        }
        Test-MemoryUsage

        can you run above Powershell command and return the result ?

Resources