Post reply

sp_configure 'max full-text crawl range'

  • September 17, 2009 at 12:33 pm

    #138207

    When using the above command on a dual QUAD core machine, do i specify the number of processors as two or eight ?

    Is this something worth changing to improve the performance of FTI or should one stick with the MS default settings ?

    Thanks

  • September 17, 2009 at 4:34 pm

    #1055289

    ifila (9/17/2009)

    When using the above command on a dual QUAD core machine, do i specify the number of processors as two or eight ?

    Is this something worth changing to improve the performance of FTI or should one stick with the MS default settings ?

    Thanks

    Technet Article

    It appears that you can set it to either the number of processors or to the number of cores. But to get max benefit it would be cores.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply