Stuart Davies (7/23/2014)
murnilim9 (7/23/2014)
I have checked on that script ..but dont u think it is very complicated and difficult to be understood ? if i dont understand all the statements ..i dont dare to implement it ...
I agree with your sentiment of "I don't understand it so I won't implement it" - but a) it is a very good script and b) if you take your time and break it down into chunks, it is understandable.
It is daunting when you see a script of that length for the first time and tempting to put down the mental shutters - do persevere with it - it is a very good wheel that does not need re-inventing.
Hey ... I just applied OLA'script in my testing server and it works fine 🙂 but in his example of "EXEC stored proc such as :
EXECUTE dbo.IndexOptimize
@databases = 'AdventureWorks',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@Fillfactor = 70
@Indexes = 'AdventureWorks.Production.Product'
It will set fillfactor to all indexes in that particular table ..but what about if I want to set fillfactor to only 1 index in that table ?? because it is fragmented very very fast and cause high pagesplit/sec
Cheers