April 2, 2013 at 8:31 am
We migrated from 2005 to 2008 and have several cubes. Despite having a better server, our performace has gone way down. Does anyone know a good source to read up on how to diagnose performance issues in SSAS? Our IT department did not set up server monitoring... despite the fact we had SQL Sentry on the old system.. and they are not even doing PerfMon... that is the battle I am now fighting, but would like to know what monitoring I should be doing on SSAS (or as PerfMon has it MSAS)
April 11, 2013 at 1:12 pm
Not sure how your shop is about open source software, but here are some nice tools for monitoring SSAS:
Monitoring Tool: http://asactivityviewer2008.codeplex.com/releases/view/15786
Development/Unit Testing: http://mdxscriptperf.codeplex.com/
Administration: http://ssashelper.codeplex.com/releases/view/66975
April 12, 2013 at 12:49 pm
I assume its the query response time, not the processing time that's increased.
Did you lose your aggregations?
Have you tried usage based aggregations?
April 12, 2013 at 7:25 pm
It is query time. The team that built the cube,would load data into the cache and use it all day long. But now MS will clean out cache items that have not been used for 30min. However I think that is due to bad cube design, but I need info about where the deadlock is. Looking at the server the Processor, memory,and Hard drives all are between 40% and 65% avg... even looking at spikes there is still 20% or more left.
I wonder if there is a problem with seek times on the hard drive, but looking at this from the SQL server side... there isn't any issues..So I need some way to tell what is creating the delay in processing a query in the cube.
April 15, 2013 at 8:05 am
This has gotten me out of some major SSAS jams with the caveat that it is fairily long:
http://www.microsoft.com/en-us/download/details.aspx?id=17303
It covers all tuning aspects from disk configuration (RAID 5 is usually preferred due to the random nature of SSAS reads), to writing the appropriate MDX.
Also, Greg Galloway of Artis consulting is REALLY good at this stuff.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply