Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to Monitor SSAS


How to Monitor SSAS

Author
Message
dwilliscp
dwilliscp
SSC-Addicted
SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)

Group: General Forum Members
Points: 426 Visits: 767
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)
sneumersky
sneumersky
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2170 Visits: 487
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
Ed B
Ed B
Mr or Mrs. 500
Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)

Group: General Forum Members
Points: 596 Visits: 1775
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?
dwilliscp
dwilliscp
SSC-Addicted
SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)

Group: General Forum Members
Points: 426 Visits: 767
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.
sneumersky
sneumersky
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2170 Visits: 487
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search