Hi,
I am text indexing a table with 12Gb of text, 300K records.
I am running SQL 2K SP 4 on a Dell 2650 dual 3Ghz CPUs, 4Gb memory.
A full population takes about 3 hours, the question here is mssearch.exe is using 100Mb memory and only 3-4% CPU usage. The server has plenty of resources left available.
Is there a way to improve performance? I mean, make mssearch.exe to use more memory and CPU cycles to perform the task faster.
The target database is not being used by any user when doing this process.
Regards,
I am text indexing a table with 12Gb of text, 300K records.
I am running SQL 2K SP 4 on a Dell 2650 dual 3Ghz CPUs, 4Gb memory.
A full population takes about 3 hours, the question here is mssearch.exe is using 100Mb memory and only 3-4% CPU usage. The server has plenty of resources left available.
Is there a way to improve performance? I mean, make mssearch.exe to use more memory and CPU cycles to perform the task faster.
The target database is not being used by any user when doing this process.
Regards,