Full Text Search

• Philip Barry

  SSCrazy

  Points: 2702

  More actions

  November 23, 2007 at 6:41 am

  #61465

  We have a production server, and one of our DBAs has set the resource_usage for sp_fulltext_service to 1 (background). I have two questions:

  1) Is there a way of finding out what the resource_usage is set to (with out being told by the DBA!)?

  2) If the service has been set to 1, will this still remain if the server is rebooted or if the server fails over to the other node in the cluster?

  I hope I have provided enough information, but if you require more then please write back!!!

  Thanks,

  Phil

  Regards,

  Phil

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  November 23, 2007 at 6:48 am

  #753625

  1. SELECT FULLTEXTSERVICEPROPERTY('ResourceUsage')

  2. Yes

  --Ramesh
  

  ---

• Philip Barry

  SSCrazy

  Points: 2702

  More actions

  November 23, 2007 at 6:50 am

  #753626

  Wow, that was a quick response!

  Thanks.

  Does this mean that the property is stored in the database somewhere?

  Regards,

  Phil

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  November 23, 2007 at 7:51 am

  #753639

  I searched the relevant objects from master and msdb databases but couldn't find the relevant information?

  Does anyone knows where these configurations are stored?

  --Ramesh
  

  ---