Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

«September 2015»
MonTueWedThuFriSatSun
31123

Executing DBCC for SQL Server Analysis Services 2016

In the upcoming release of SQL Server Analysis Services 2016, one of the new features you’ll see is the ability to perform a database consistency check against your SSAS cubes and Tabular models. Just like in the database engine side of things, DBCC for SSAS checks for corruption across the entire database or individual objects within the database.

The DBCC command is shaped likes the XMLA Process command so there’s not a lot of complexity to it. Below here, you can see the basic syntax for the SSAS DBCC command. Its worthing noting that the syntax of the command will look the same whether you’re running it against an SSAS multidimensional database or Tabular model.

"http://schemas.microsoft.com/analysisservices/2003/engine">
    <Object>
        
        
        
        
    Object>

To run the DBCC command, just open a new MDX query window and use the code seen above. Enter in the IDs of your Database, cube, measure and/or partition.

When you’re running the DBCC command against a Tabular model, there are a couple things I’d like to point out.

In the element for the CubeID, you’ll need to specify the ID of the Model. And in the element for the MeasureGroupID, specify the ID for the table you want to check.

DBCC XMLA command for SSAS

If you want to check the whole database or model for consistency, simply remove the elements the lower elements. For example, if I wanted to check the whole model, I just would leave out the elements for MeasureGroupID and PartitionID.

To find the MeasureGroupID (Table ID) or PartitionID in a Tabular model, just navigate to the Properties for that object.

Find the SSAS Tabular MeasureGroup ID or Table ID

To find the Partition ID in a Tabular model, right click the table and select Partitions. Then highlight the partition you want to check and click the Settings icon.

Find the SSAS Tabular partition ID

If you run SQL Server Profiler against SSAS while executing the DBCC command, you can see the individual checking of the columns, tables, database and more.

SSAS Tabular Profiler trace DBCC

I also ran a trace against my SSAS 2016 OLAP instance to watch each segment of

Read more
456
78910111213
14151617181920
21222324252627
2829301234
567891011

My 2010 Year in Review

  • 9 March 2011
  • Author: briankmcdonald
  • Number of views: 2262
  • 0 Comments

 

While in Cincinnati for the first time since September of 2007, I heard on several occasions that I work too much and need to slow down to "smell the roses" or "enjoy the fruits of my labor". In fact, I've even heard that quite a few times from others as well, but I thought what a great way to see how much I do by writing a blog to review my work over the last year. As such, this blog is solely meant as a year in review of my presentations, articles and blogs that I have provided to the SQL Server Community.

 

Presentations

Due to my traveling schedule, I have only done a few sessions this year, but I am thankful for each and every opportunity that I have had to pass on some of the knowledge that I have gained over my many years in the IT industry.

 

 

As a reminder, I am set to present in Tampa, Florida on 1/15/2011 and will probably speak a handful of times this year. I even submitted a session to SQL Rally and I really hope that they approve my session. If approved, it should be another full house as in all of my other sessions and one that shouldn’t be missed. J

 

Writings – Articles/Blogs

As many of you know, 2010 has been the year that I chose to add blogging to my already busy lifestyle. Of course it did make it a bit easier since I haven’t been able to exercise due to my shoulder injury. J But now that I am in the groove, it is easy to keep going. You can find my blogs at BIDN of course, SQLServerCentral and SQLServerPedia. Which were named by SQL Server Magazine as the top three sites for SQL Server solutions in their December 2010 edition. At any rate, here is a list of my blogs and articles by month as well as links.

 

BLOGS

ARTICLES

http://www.bidn.com/blogs/briankmcdonald

http://www.bidn.com/articles/briankmcdonald

 

  • December 2010 (1)
  • October 2010 (2)
  • September 2010 (1)
  • July 2010 (4)
  • June 2010 (2)
  • May 2010 (3)

Total Blogs:  79

Total Articles: 13

 

Forum Posts

Throughout the year, I have also participated in assisting others through responding to their forum questions. Most of my responses are on BIDN.com, but others are the SQL Server Programming group on Google and SQL Server Central. If I had to take a stab at how many posts that I had, it would be between 75 and 100. I hope that I have provided good advice to those who have not marked the solution as accepted and look forward to assisting others with their problems.

 

If you don’t already, please be sure to follow me on twitter at @briankmcdonald. Also note that you can subscribe to an RSS feed of my blogs or find me at any of the below methods.

 

Goodbye 2010, Hello 2011 - Brian K McDonald 

Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant

Email: bmcdonald@sqlbbigeek.com

Blogs: SQLBIGeek | SQLServerCentral | BIDN Articles | BIDN Blogs | SQLServerPedia

Twitter: @briankmcdonald

LinkedIn: http://tinyurl.com/BrianKMcDonald

 

 

Print
Categories: Blogs
Tags:
Rate this article:
No rating

briankmcdonaldbriankmcdonald

Other posts by briankmcdonald

Please login or register to post comments.