SSAS Diagnostics Analyzer

The SSAS Diagnostics Tool (SSASDiag.exe) in its most recent release provides a significant Analysis feature. Initially it implements two highest priority analyzers.

General features of the Analyzer

The Analyzer feature automatically exposes available analyses for each of its collected data types. After initial analysis or load of data is performed by a specific data type's analyzer, subsequent analysis does not require the initial load to be immediately accessed again. This can be a significant time savings for large traces that may be multiple GB in size. The analyzers automatically save their analysis and imported data back into any .zip file generated by the tool from which they are obtained, or into a folder adjacent the files if obtained from a folder or specific file selection. The tool supports opening .zip files or folders generated by the Collector, for all of their contained data, or specifically opening a file of any of its supported file types for analysis.

Network Trace Analyzer

The Network Trace Analyzer tool scans a network trace and reports summary statistics, but also searches for a variety of errors and issues that can commonly disrupt network communications, listing their occurrences and locations in the trace.
ssasdiag network analysis.png

Profiler Trace Analyzer

The Analysis Services Profiler Trace analyzer feature imports a SQL Profiler trace against Analysis Services into a local database for analysis, and exposes 11 initial analysis queries exposing deep insights into the trace. These queries' results subsequently expose right-click functionality to support various extended analyses beyond the initial queries, allowing 60 unique combinations of paths through the data. By combining these there are unlimited combinations of questions the user can ask and answer about the content in the trace.
ssasdiag profiler analysis.png
Currently the Profiler Trace Analyzer component of the tool requires the SQL 2016 Management Tools, and a local SQL instance (of any release 2008 or greater) on which the user is a SQL administrator, in order to perform its analyses. This dependency may be removed in a future release of the tool. Data capture may still be performed without any 2016 dependencies, and analysis can be performed on any machine with the necessary requirements. The 2016 Management Tools are available for direct download without any SQL license requirement at https://go.microsoft.com/fwlink/?LinkID=840946.

Key Features of the Profiler Trace Analyzer

ssasdiag start load.png
 

ssasdiag load time for long trace.png
 
ssasdiag sql callout.png
 

Future Goals


User feedback has been one primary mechanism for improvements and discovery of issues, so please provide your suggestions if you have ideas or feedback about the tool!