Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Monitor SSAS Expand / Collapse
Author
Message
Posted Tuesday, April 02, 2013 8:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 11:21 AM
Points: 293, Visits: 499
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)
Post #1437932
Posted Thursday, April 11, 2013 1:12 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
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
Post #1441452
Posted Friday, April 12, 2013 12:49 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 2:57 PM
Points: 535, Visits: 1,629
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?
Post #1441848
Posted Friday, April 12, 2013 7:25 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 11:21 AM
Points: 293, Visits: 499
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.
Post #1441990
Posted Monday, April 15, 2013 8:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
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.
Post #1442315
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse