title: SSAS Processing Slow - SQL Server 2012
body: <p>I have two SQL Server Agent jobs that run XMLA to process SSAS objects in a SQL 2012 SSAS server.<br/><br/>
  <strong>ProcessCubeFull</strong> This runs after the related SQL database has been reloaded from scratch, this is a weekly job. This job does the following:<br/>
  1. Process Dimensions, ProcessFull, uses  MaxParallel="4", Time: <strong>20 minutes</strong><br/>
  2. Process Partitions, ProcessFull, uses  MaxParallel="4", Time: <strong>85 minutes</strong><br/>
  3. Process Cubes, ProcessFull, uses  MaxParallel="4", Time: <strong>100 minutes</strong><br/><br/></p>
  
  <p><strong>ProcessCubeUpdate</strong> This runs after the related SQL database had its daily update, this is a daily job. This job does the following:<br/>
  1. Process Dimensions, ProcessUpdate, uses  MaxParallel="4",Time: <strong>100 minutes</strong><br/>
  2. Process Partitions, ProcessData, uses  MaxParallel="4", ,Time: <strong>15 minutes</strong><br/>
  3. Process Indexes, ProcessIndexes, uses  MaxParallel="4", Time: <strong>55 minutes</strong><br/>
  4. Processes Cubes, ProcessDefault, uses  MaxParallel="4", Time: <strong>1 minute</strong><br/></p>
  
  <p>The performance of these jobs is very slow and getting slower. 
  It also seems odd that for the dimensions ProcessFull is a lot faster than ProcessUpdate.<br/></p>
  
  <p>I would like to know how I can speed these jobs up, or if they need some additional steps?</p>