Post reply

Full Text Search/system resource usage

  • March 19, 2003 at 8:53 am

    #151804

    Under SQL 2000, how do I adjust to amount of memory used by Full Text Search ? I'm getting a performance spike when building a catalog. Its suggested, I can right click on Full Text and find a "System resource usage" under properties. I can find this under SQL 7.0 but not SQL 2000.

  • March 24, 2003 at 12:00 pm

    This was removed by the editor as SPAM

  • March 24, 2003 at 12:18 pm

    #451943

    You can use these to system functions/procs to tweak the resource usage:

    

    -- View Current settings...

    SELECT FULLTEXTSERVICEPROPERTY('ResourceUsage')

    -- Change current settings (1=background; 5=dedicated)

    exec sp_fulltext_service 'resource_usage','3'

    -Dan


    -Dan

  • April 2, 2003 at 1:04 pm

    #452901

    Thanks Dan....that's what I needed

Viewing 4 posts - 1 through 3 (of 3 total)

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