Post reply

Full Text Indexing build very slow

  • June 2, 2016 at 5:05 pm

    #316898

    HI,

    We are creating a full text index in the document table, which is using filestream to store doc or pdf files. the filestream size is about 150GB, the full index population took way long. It started about 2 weeks ago, but still not finished.

    The fdhost.exe is using only 1-2% CPU and 20MB ram. The server have 14GB ram and I set the max server memory to 8GB.

    The full text index is using "auto change tracking".

    Any help?

    Thanks

    SLu

  • June 2, 2016 at 7:30 pm

    #1882975

    Siqing LU (6/2/2016)

    HI,

    We are creating a full text index in the document table, which is using filestream to store doc or pdf files. the filestream size is about 150GB, the full index population took way long. It started about 2 weeks ago, but still not finished.

    The fdhost.exe is using only 1-2% CPU and 20MB ram. The server have 14GB ram and I set the max server memory to 8GB.

    The full text index is using "auto change tracking".

    Any help?

    Thanks

    SLu

    That's an awfully underpowered machine for what you have it doing.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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