How SSAS Cube Processing Affects Running Queries

Posted on May 29, 2009 by Clay Lenhart

SSAS cube processing can kill running queries. That’s right, it may kill queries in order to commit changes to the cube.

Here is what happens during SSAS cube processing.

  1. The cube finishes calculating the next version of the cube
  2. Before the data can be made available, SSAS prevents new queries from running
  3. Any currently running queries are allowed to finished normally for 30 seconds
  4. After 30 seconds, SSAS kills any running queries
  5. SSAS commits the new version and allows new queries to hit the updated data

The 30 second time out is a configuration setting that you can read about here.

So, that’s right, SSAS may kill long running queries.

About Clay Lenhart

I am a DBA/Technical Architect for Latitude Group and love technology.
This entry was posted in SSAS and tagged , . Bookmark the permalink.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>