question

ezee2 avatar image
ezee2 asked

can i disable full text filter in production

i think full text filter may be causing performance issues, is it ok to turn it off while the server is live and being used heavily
performancefull-textfilestreamfilter
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL avatar image DaniSQL commented ·
What exactly is wrong with the performance? Whats happening? any errors you are getting? Which version of SQL Server are you on?
0 Likes 0 ·

2 Answers

·
ramesh 1 avatar image
ramesh 1 answered
hey dude, i don't think what exacly is going on with you, please make sure that full text search in pmplemented in you project. if you disable it when using ,your server will pay for that, can you plz explain which server version is working over now.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Cyborg avatar image
Cyborg answered
Hello ezee2 First i recommend you to find what performance issues you are facing like, whether bottlenecks on your Hardwares (CPU, Memory or Hard Disk), Locking , or any poorly written quires, or poor indexes are causing the performance problems, if the full text is loosing proper index then definitely it will hurt the performance. Conduct a full health checkup of your server and find the source of causing performance.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.