Contact  |  Site Map  |  Privacy      Call for more info
 
OLAP Performance Advisor 

OLAP Performance Advisor is now available for download and testing.

Latest version: 3.0.2010.413

OLAP Performance Advisor features
Monitoring SSAS Servers Recording and analyzing traces

 Monitor Analysis Services sessions, last session commands and its performance statistics

 CPU Time for sessions and applications

 Reads/Writes statistics

 Sessions memory usage 

 Cache hits/misses

Recording new traces in files and tables

Trace repository and Server Explorer: manage your traces

Analyzes statistics per SSAS objects: for cubes, dimentions,  measure groups, etc.

Analysis visualization

Advisory report

Finding storage engine/formula engine bottlenecks

Trace events data decoding
                                
  • Version 1.1.2010.209:
    - Fixed bugs. 

  • Version 1.1.2010.205:
    - OLAP Performance Advisor can record traces. 

  • Version 1.1.2010.129:
    - Integrated SSAS servers monitor    :
        - Monitor Analysis Services sessions, last session commands and its performance statistics
        - CPU Time for sessions and applications
        - Reads/Writes statistics
        - Sessions memory usage
        - Cache hits/misses statistics

  • Version 1.1.2009.811:
    - Advisory pane added. Set of recommendations based on current analysis results and server information:



    - Save your analysis report as XML for further analysis without trace:



    - Many minor enhancements and bug fixes.

  • Version 1.1.2009.503:
    - Trace Event properties dialog added (called from Executions list):

    - Worst executions filter added:


  • Version 1.1.2009.429:
    - Database/Cube properties are displayed on Analysis Report pane if Analysis Services server is connected;
    - Fixed several bugs.


  • Version 1.1.2009.424:
    - You can record new traces from OLAP Performance Advisor using "New trace" button:



    See Quick Start Guide's "Recording Traces" section for more information about trace recording.

    - EventSubclass filter now shows correct descriptive values instead of event IDs.

    - Fixed several bugs.

  • Version 1.1.2009.422:
    Fixed several bugs. Analysis statistics can be grouped by database: