1
vote
2answers
302 views

SQL Server Full Text Search resource consumption

When SQL Server builds a fulltext index computer resources are consumed (IO/Memory/CPU) Similarly when you perform full text searches, resources are consumed. How can I get a gauge over a 24 hour ...
1
vote
0answers
219 views

Alter Fulltext Catalog Reorganize: Any issues to run this during daytime?

I have been going thru documents on Alter Fulltext Catalog Reorganize. But unlike Alter Index Reorganize, BOL(Books Online) documentation does not mention whether it's possible to run it without ...
2
votes
2answers
352 views

What is the big difference between Fulltext-Search on SQL2000 and SQL2008

my first test to get a given database with activated fulltextsearch running on a sql2008 failed with the result that it creeps. sql2008 took several the time of sql2000, but why?