Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-07 : 09:08:07
|
Julian writes "Hello!
I've tried implementing full-text index searching on my SQL Server 2000 on Win2K database server and, yes, it works, but as well as significant disk access to the disk where FTDATA resides the 2 processors in the server also take a hammering. I've tried using sp_fulltext_service to configure Microsoft Search to run in background, and I've also configured memory to ensure that
SQL Server leaves enough RAM for Microsoft Search to run as has been suggested from various articles. Unfortunately the disk is still under pressure and the processors are still hit hard. I'm introducing h/w RAID to this machine so disk I/O should be improved, and can also add memory, but I can't add processors at the moment. An option, if this is possible, would be to
somehow run Microsoft Search as a process on a second separate dedicated server. Does anyone know if this can be done, leaving the database table where full-text indexing needs to be enabled on the original server if possible? I guess it's really just the processing for Microsoft Search I want to offload to a secondary server, locating FTDATA there as well if necessary.
Weird quiestion I suppose, but nevertheless any ideas very gratefully considered!!!
Thanks in advance.
Julian Ball
Infrastructure Architect
Espotting Media
julian.ball@espotting.net
020 7539 0513" |
|
|
|
|
|
Dedicated full-text index server?