-
Couldn't load subscription status.
- Fork 822
Description
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