• HowardW (7/25/2014)


    murnilim9 (7/24/2014)


    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

    Most people would use these scripts without specifying a FillFactor parameter, so it maintains the fill factor that the index was originally created with. As you say, there's often no "one size fits all" fill factor and it'll depend on the nature of the key.

    thx for your response but could you be more specific ? the example maybe ?