Browsed by
Category: SSAS

Avoid SELECT *

Avoid SELECT *

Buffer Usage The Data Flow Task (DFT) of SSIS uses a buffer (a chunk of memory) oriented architecture for data transfer and transformation.  When data travels from the source to the destination, the data first comes into the buffer – required transformations are done in the buffer itself and then written to the destination. The size of the buffer is dependent on several factors – one of which is the estimated row size.  The estimated row size is determined by…

Read More Read More

Kill a Session, SPID or Connection to Analysis Service Cube

Kill a Session, SPID or Connection to Analysis Service Cube

A very common requirement when administering an SSAS instance or cube is killing a particular connection, SPID or Session, this could be due to a lengthy operation exceeding the expected time to completing, or merely cancelling a transaction that was issued by mistake. This post goes through the XMLA required for killing an SSAS command, as well as the Analysis Service DMVs that can be utilized to identify the required IDs. In order to cancel a command on an SSAS…

Read More Read More