SSAS - What is running ?

  • Hello everyone
    Our server SSAS it is crash every 3 days, I have no compethence necessary to have the root cause of this crash
    the only action done is to restart the service SSAS
    is there a method that allows me to detect the root cause of this blocking  ?

  • joujousagem2006 1602 - Tuesday, May 29, 2018 6:13 AM

    Hello everyone
    Our server SSAS it is crash every 3 days, I have no compethence necessary to have the root cause of this crash
    the only action done is to restart the service SSAS
    is there a method that allows me to detect the root cause of this blocking  ?

    Can you share more information please? I.e. what are the specs of the server, what else is running on that server, what are the configurations, what versions and patch levels (including the OS) etc.
    😎

    Checking all the OS logs, any error logs and the SSAS DMVs would be the first step.
    Does the service crash during normal operations or during processing?
    Are you running MDX or Tabular?

  • Hi You can do multiple things to monitor and trace the activity but it needs little more information to suggest whats wrong. for regular monitoring SSAS i use https://github.com/RichieBzzzt/SSASActivityMonitor this activity monitor. and you need to check the configuration settings for min and max memory and hard limit as well as page file size ( this needed to be tweaked until unless ).

    @JayMunnangi

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply