>>mmmmmmemory.....must have more mmmmmmmmmemory...
>>
>>Seriously, if SQL Server is slowing down my first thought is to add RAM. Also, if you aren't using 64bit, use it (and RAM). Both make serious performance differences. And yes - if that means a new box that handles more RAM, get it.
>
>It is only the full text indexing which is crawling. All the rest of the database is responding as fast as it as always been. Do you still think that this is full text indexing only related as far as memory goes, assuming I have reached a limit where I have to increase the RAM? If yes, that would mean I would have to increase the ram at every x amount of similar increase in size, which I do not think it is the issue.
>
>>How big is your database? How many records are in the table you are trying to full text index on? I'm not an expert on the internal limits of SQL Server, but I'd be suprised if you were really hitting limits.
>
>The MDF is 10 GB. The full text index file is 496 MB. Only one table makes use of it and it used a dedicated file for that storage.
>
>The number of records, having one field subject to the full text index is NVarChar(MAX), is 2 millions.

That isn't a very big database or index. I'm assuming the Server is running on decent hardware (more than 4GIG Ram, multicore processors, etc)?

Good Full Text performance tips and diagnostics are here.. http://technet.microsoft.com/en-us/library/ms142560(v=sql.105).aspx