Archive

Posts Tagged ‘Analysis Services’

Exposing the SSAS file system with the Metadata Sniffer

April 19, 2014 Leave a comment

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.

Read more…

SSAS – Out of memory exception during processing

March 3, 2014 Leave a comment

For a while now I been analysing a situation and i have got it down to a fine art now where by I do the following

  1. Create a memory a memory intensive situation where i am using 85% of available memory and SSAS is working hard to free memory.
  2. Process add a dimension and capture statistics.
  3. Review statistics, contemplate the results and then tweak something.
  4. Start at step 1 again.

The other day when i did my process add I was presented with the following error.

The following exception occurred while an operation was being performed on a data source view: The type initializer for ‘System.Xml.Schema.XmlSchemaComplexType’ threw an exception.;Exception of type ‘System.OutOfMemoryException’

Read more…