title: Avoid deadlock in SSAS by preventing querying during process
body: <p>I have a <strong>SSAS cube</strong> which is <strong>processed</strong> on a regular basis to integrate newly available data in source tables.</p>
  
  <p>The issue is that sometimes it seems that the process interferes with some heavy queries causing <strong>locking conflicts</strong>. (one every 2 weeks)</p>
  
  <p>How can I avoid that?</p>
  
  <p>Is there a way to prevent SSAS from executing queries while it is processing the cube?</p>
  
  <p>This should not impact performance too heavily as the processing time is quite short in general.</p>
  
  <p>Moreover redesigning the cube to enhance performance and reduce the odds of this issue happening is not an option.</p>