Analysis Services crashes sporadically

  • stewwe

    SSC Rookie

    Points: 32

    Hello!

    On our Microsoft SQL Server we provide tabular models that are executed as services in SQL Server/Analysis Services/Integration Services. Unfortunately, it happens again and again that our analysis service hangs sporadically and is thus terminated. Although the crashed service is started automatically via the Windows services, it is no longer accessible via the network for "SSMS" and "On-premises data gateway". This means that the entire server must be restarted.

    In our attachment you can see the eventlog with error messages to the crash.

    About our system:

    Software: OS Windows Server 2016 „1607“, SQL Server 2017 (14.0.3238.1) CU17

    Hardware: Vshpere VM, 12 x CPU „12 Sockets“, 96 GB RAM

    HDD size: (C: > OS, total 211 GB/free 138 GB), (D: > SQL DB, total 55 GB/free 33 GB), (E: > SQL Logs, total 60 GB/free 20 GB), (J: > SQL DB-Temp, total 20 GB/free 17 GB )

    Our SQL Server provides four tabular models for reporting purposes, which are updated periodically via SQL Server Agent.

    The Analysis Service crash occurs sporadically, sometimes after two weeks and sometimes daily. We've had the bug for several months. Since CU13, the latest CU updates are always installed, but the error persists.

    Thank you so much for your help

    Stewwe

     

    Attachments:
    You must be logged in to view attached files.
  • Site Owners

    SSC Guru

    Points: 80373

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

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