Consistency Check an Analysis Services Database

— By Lori Brown @SQLSupahStah

I am migrating a client to SQL 2016 and had to restore the SSAS databases and do what amounts to a DBCC CHECKDB against it. The command is done while connected to SSAS in Management Studio. You open an XMLA query (not MDX)…


…and run the following:

<DBCC xmlns=”>


<DatabaseID>Work Metrics</DatabaseID>

<CubeID>Hourly Insights</CubeID>



The output looks like this:


As usual more info can be found from MSDN:

For more information about blog posts, concepts and definitions, further explanations, or questions you may have…please contact us at We will be happy to help! Leave a comment and feel free to track back to us. Visit us at!

Both comments and trackbacks are currently closed.
%d bloggers like this: