How SSAS Cube Processing Affects Running Queries – SQL Server Analysis Services

Leave a comment (0) Go to comments

One of my training participant has asked me a question,

Will my cube will be available during processing ?

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 (cube go offline when the final step of write back happens (final stages) of processing. But this period is less in comparison to the processing time )
  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

Another participant has asked a question, Can I kill a user query during a cube processing ?

The answer is yes, you can this do this by specifying ForceCommitTimeout in a SQL Server Analysis Services properties window.

The default value for this property is 30 seconds (30000 milliseconds), which indicates that other commands will not be forced to timeout when the current command times out.

How SSAS Cube Processing Affects Running Queries   SQL Server Analysis Services


If the query is being cancelled, the end user, will get a message "the operation has been cancelled" errors from a long running query (one that takes more than 30 seconds) while a cube or partition is being processed.

EOF - How SSAS Cube Processing Affects Running Queries – SQL Server Analysis Services, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

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>

Notify me of followup comments via e-mail. You can also subscribe without commenting.