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=”http://schemas.microsoft.com/analysisservices/2003/engine“>

<Object>

<DatabaseID>Work Metrics</DatabaseID>

<CubeID>Hourly Insights</CubeID>

</Object>

</DBCC>

The output looks like this:

As usual more info can be found from MSDN: https://msdn.microsoft.com/en-us/library/mt156975.aspx

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