Fulltext´takes too much resource

If the fulltext takes too much resource you can set the priority in difference levels. 1-5 is the different levels, 3 is the most common.

To change the priority to e.g. 1 use this code;

EXEC sp_fulltext_service 'resource_usage',1