Index Maintenance - Reorganize After BIG SQL Server Shrink
0
votes
1
answer
1102
views
I'm planning to execute the below index maintenance created by Ola Hallengren in a 1TB Database.
EXECUTE [dbo].[IndexOptimize]
@Databases = 'USER_DATABASES',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE',
@FragmentationHigh = 'INDEX_REORGANIZE',
@FragmentationLevel1 = 50,
@FragmentationLevel2 = 80,
@UpdateStatistics = 'ALL'
,@FillFactor = 100
So basically I know that shrinking is a very bad idea and not a common practice,
I'm Shrinking because is really needed and it has been working good.
So due to the fragmentation that the shrinking is causing, I'm planning to use the mentioned stored procedure to **Reorganize** all the affected indexes and avoid getting the freed space back with a **Rebuild**
So the specific question would be, does this look like a good approach or have you faced something similar and used another approach for it ?, or if you have suggestions are gonna be highly appreciated.
Asked by user141153
Aug 22, 2018, 02:35 AM
Last activity: Dec 7, 2023, 05:08 PM
Last activity: Dec 7, 2023, 05:08 PM