Skip to content

NonClustered Columnstore index maxdop 1 #950

@mdhavi18

Description

@mdhavi18

Running index optimize and I'm seeing that the nonclustered columnstore indexes are getting rebuilt with maxdop = 1 instead of maxdop = 8 as i would expect.

Microsoft SQL Server 2019 (RTM-CU32-GDR) (KB5058722) - 15.0.4435.7 (X64) Jun 9 2025 18:36:12 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2019 Datacenter 10.0 (Build 17763: ) (Hypervisor)

Version: 2025-08-23 17:25:24

EXECUTE [dbo].[IndexOptimize]
@databases = 'idbcfin',
@LogToTable = 'Y',
@UpdateStatistics = 'ALL',
@OnlyModifiedStatistics = 'Y',
@SortInTempDB = 'Y',
@Maxdop = 8,
@FragmentationMedium = NULL,
@FragmentationLevel2 = 50

Command: ALTER INDEX [IXSCH__xtCustomer__20250417_01] ON [dbo].[xtCustomer] REBUILD WITH (ONLINE = ON, MAXDOP = 1, RESUMABLE = OFF)
Comment: ObjectType: Table, IndexType: NonClustered Columnstore, ImageText: No, NewLOB: No, FileStream: No, AllowPageLocks: No, PageCount: 2143, Fragmentation: 98.5849

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions