hi,

I have response problem with Full Text Index which is 600MB in Size and
growing incrementally. Previously we had 128MB Ram and 350MB of index size
then size of index increases to 600MB due to insertion of data after this
performance degraded so we increased the RAM to 256MB now performance is
better but the issue is that the database is continuously growing and we are
facing the same problem again so tell me I must increase the RAM or is there
any remedy for this problem because keep on increasing the RAM is not a good
solution.



Kindly help me in this regard how I optimize this, I am using default
settings of SQL Server.



Configuration:

SQL Server 2000: (Desktop version) with (Service Pack 3a)

Windows 2000: Professional with (service pack 4)

Hard ware configuration: (256 MB Ram, 2.40 GHz, 40GB Hard disk)



Anxiously waiting for reply

Regards
Farhan Iqbal