x

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

more ▼

asked Jul 16, 2010 at 12:41 PM in Default

avatar image

ezee2
1 1 1 1

What exactly is wrong with the performance? Whats happening? any errors you are getting? Which version of SQL Server are you on?

Jul 16, 2010 at 01:56 PM DaniSQL
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Jul 19, 2010 at 12:17 AM

avatar image

ramesh 1
2.2k 66 69 73

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Jul 19, 2010 at 05:25 AM

avatar image

Cyborg
10.8k 37 55 51

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x310
x52
x27
x24

asked: Jul 16, 2010 at 12:41 PM

Seen: 1551 times

Last Updated: Jul 16, 2010 at 12:41 PM

Copyright 2017 Redgate Software. Privacy Policy