We have observed a critical issue with CPU utilization on our SQL Server, resulting in server halts. After thorough investigation, it was discovered that the root cause of this problem is the fragmentation of ColumnStore indexes, particularly on priority tables with records exceeding 1000 page_count. Does script aims to checks fragmentation on ColumnStore indexes and automatically rebuilds them.
SQL Server version and edition
Execute SELECT @@VERSION
Microsoft SQL Server 2016 (SP2-CU17-GDR) (KB5014351) - 13.0.5893.48 (X64) May 24 2022 02:58:22 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: )
Version of the script
Check the header of the stored procedure
Version: 2018-06-27 20:44:12
Description of the issue
We have observed a critical issue with CPU utilization on our SQL Server, resulting in server halts. After thorough investigation, it was discovered that the root cause of this problem is the fragmentation of ColumnStore indexes, particularly on priority tables with records exceeding 1000 page_count. Does script aims to checks fragmentation on ColumnStore indexes and automatically rebuilds them.
SQL Server version and edition Execute (Build 14393: )
SELECT @@VERSION
Microsoft SQL Server 2016 (SP2-CU17-GDR) (KB5014351) - 13.0.5893.48 (X64) May 24 2022 02:58:22 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0Version of the script Check the header of the stored procedure Version: 2018-06-27 20:44:12
What command are you executing? EXECUTE dbo.IndexOptimize @Databases = 'USER_DATABASES', @FragmentationLow = NULL, @FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE', @FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE', @FragmentationLevel1 = 5, @FragmentationLevel2 = 30, @UpdateStatistics = 'ALL', @OnlyModifiedStatistics = 'Y', @SortInTempdb = 'Y'
What output are you getting? Update Statistics