Trouble shooting SQL server Analysis performance

• MarvinTheAndriod

  SSCarpal Tunnel

  Points: 4972

  More actions

  July 18, 2011 at 7:57 am

  #240946

  Hello,

  I am troubleshooting the performance of a server. The SQL server itself seems to have a very light load, but the Analysis Services is running on the server. I have troubleshooted SQL Servers before but not ones with analysis services. Do you have any recommendations on how to approach this ?

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  July 18, 2011 at 1:16 pm

  #1354450

  What kind of performance issue are you facing with SSAS. slow processing or low query speeds .

  You might want to check the size of the dimensions.

  Check if your using a warm cache

  Check the temp file created as part of dim processing.

  Are you using parallel processing.

  Are there partitions on the cube

  Are you using group by or distinct as part of the cube processing.

  Jayanth Kurup[/url]