none
Full-Text Search - performance cost? RRS feed

  • Question

  • I am conducting performance tuning & optimization of a SQL2K5 database. The server has Full-Text Search Service enabled and running. However, I don't believe the applications are actually using this Service and I am considering disabling it to conserve resources since apps are performing high transactions that are consuming significant resources (memory, CPU).

    How much of a performance cost does Full-Text search service impose on the server and is this a recommended way of conserving resource consumption if the Service is not being used or needed by the application?

    I haven't found much in Technet, KB or MSDN to address this topic.

    Thanks,
    Phil 

    Thursday, March 22, 2007 5:04 PM

All replies