Report Portal

Exposing the SSAS file system with the Metadata Sniffer

Very recently I encountered a production issue and to assist me in the root cause analysis I needed information/clues that are not exposed by any SSAS interfaces so I created the metadata sniffer. I had been informed that a query had encountered a file system error, specifically some indexes were missing. Initially the impacted partition had its indexes rebuilt but then another report came in and I suspected something more serious. At this point in time I wanted to examine the file system at a SSAS database level to determine how many partitions might have missing indexes.


Tags: management, performance, script


2007-2015 VidasSoft Systems Inc.