CRM DB Index Rebuild RRS feed

  • General discussion

  • Hi All,

    We are getting timeout error in CRM job scheduler for index maintenance job. So we are planning to call CRM inbuilt stored procedure using SQL Agent for index maintenance. Can you please review below parameters and advise if any changes required on below input parameters.

    Currently the indexes fragmentation is very high and also advise is there any changes are required to decrease the fragmentation.

    Thanks in advance.

    DECLARE       @return_value int
    EXEC   @return_value = [dbo].[p_ReindexAll]
                  @AllIndexTypes = 1,
                  @MaxRunTime = NULL,
                  @FragRebuildPct = 95,
                  @MinPages = 25,
                  @Verbose = 1,
                  @Online = 1
    SELECT 'Return Value' = @return_value

    Saturday, September 17, 2016 11:33 AM