Home Forums SQL Server 2016 SQL Server 2016 - Administration Columnstore Indexes - do we need to perform any maintenance on them? RE: Columnstore Indexes - do we need to perform any maintenance on them?

  • February 11, 2019 at 7:33 am

    #2021647

    doodlingdba - Monday, February 11, 2019 3:02 AM

    Thanks for response Grant. I've not used ColumnStore Indexes before and taking a while to wrap my head around it.

    My next question is - any DBAs out there who have configured maintenance jobs for ColumnStore indexes and wish to share their insights? Is there something standard that we can implement?

    Thanks
    Doodles

    The single greatest resource on Columnstore apart from what Microsoft offers (and that is pretty good) is Niko Negebauer. Here is his 127 part (and growing) series on the topic. More information than you can shake a stick at. We also have some very good articles here on SQL Server, specifically in the Stairways series. I'd suggest going there too.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning