How to cancel long running queries in Analysis Services 2005

 

Here are steps to kill spid.

1-Open management Studio.

2-Connect AS instance

3-Choose XMLA command (shown below)

4-Execute following xmla command to find out spids

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">

  <RequestType>DISCOVER_SESSIONS</RequestType>

  <Restrictions>

    <RestrictionList>

    </RestrictionList>

  </Restrictions>

  <Properties>

    <PropertyList>

    </PropertyList>

  </Properties>

</Discover>

5-Output will be similar to following:

6-Copy SPID number and run following XMLA command (Change your spid number to your own spid number):

<Cancel xmlns="https://schemas.microsoft.com/analysisservices/2003/engine">

  <SPID>28147</SPID>

</Cancel>