We are running SQL Server 2014 and SSAS on the same box. Every now and then our SSAS service appears to freeze. When it does I check the
msmdsrv.log file and it tells me that spid x is blocking transaction on spid y.
Is it possible to log the results from SSAS
$System.discover_sessions to a database on the SQL Server on a regular interval? I'd like to capture the current session so that when these issues come up I can see the commands that are running and the SSAS instance refuses to allow me a connection when this occurs.