Forum Discussion

SrinivasaManiPrabhakar's avatar
SrinivasaManiPrabhakar
Copper Contributor
Nov 13, 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 f...
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
SrinivasaManiPrabhakar's avatar
SrinivasaManiPrabhakar
Copper Contributor
Nov 20, 2019

Thank you for reply renefk 

 

Server has 48 GB memory on the server, but still no luck 😞

  • 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