How to Kill SSAS Cube Stuck in Processing

In this post, I will show you how to kill an SSAS cube which is stuck in processing and cannot be stopped normally. In addition to that, you can also use this method for killing other SSAS related operations.

In order to kill a processing cube we need the following information:

  • Connection ID
  • Session ID
  • Session SPID

To acquire this information we will use the below MDX scripts:

Upon executing the above scripts you can extract the below information required to kill the cube processing.

Once we have the above information, we can use the below XMLA to kill the session.

Leave a Reply

Your email address will not be published. Required fields are marked *