Forum Discussion

mohammadjavaher's avatar
mohammadjavaher
Icon for Helper I rankHelper I
3 years ago

Analysis Services stops frequently

Hi. I receive these lines frequently in msmdsrv.log (error is in the last line and type, category and event ID are always the same):   (8/13/2023 1:35:02 PM) Message: Resource tracking started. (...
Need Help
mohammadjavaher's avatar
mohammadjavaher
Icon for Helper I rankHelper I
2 years ago

So, I managed to overcome this situation as follows:

  1. Wrote a view to show latest refresh status of each report.
  2. Wrote a stored procedure which force-refreshes each failed refresh plan using AddEvent SP already present in RS instance, and then sends an email alert using already-configure database mail profile.
  3. Wrote a Windows service using VB.Net which checks report refresh failures in cofigurable periods. If any failure from AS engine is detected, it restarts Power BI RS service, waits for a configurable couple of seconds so RS reaches full functionality, and then calls that SP on step 2 to force refresh failed reports.

This way, I'm at least sure server will come back online whenever AS engine fails. I have a report which is refreshed every 5 minutes and this guarantees that AS engine failure is detected shortly.

Hope this helps someone else.

Regards.