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.
Read more...Tags: management, performance, script