sql server full text search: I'm running into an timeout issue in my production environment. I have
several ASP.net (2.0) sites running on the same web (IIS 6.0) server. They
all point to the same set of code but run in seperate application pools. They
all talk to there own sql server 2005 database running on a seperate server
(all databases on same server). I've implemented a full-text search within
the app. It seems that the first time a user in any site performs the full
text search (by first time I mean if there has been no activity on the web
server for a while and all the sessions go away, or I restart the web
service) the search times out. After that the performance is very good. Any
thoughts would be greatly appreciated..

Oh, another thing.. all other database connectivity other than the full-text
search works fine prior to (and after) the fts, so it's not some connection
intialization problem.

Thanks.
--

I have the same problem, and someone told me that is because mssearch
process tries
to validate the signature of the connecting server (this is the reason
that you always wait about 50 sec).
You can read the full discussion at:

http://groups.google.co.il/group/microsoft.public.sqlserver.fulltext/browse_thread/thread/da15555053231699/3e2a8172440473bd?lnk=st&q=sql+2005+first+time+fts+slow&rnum=1&hl=en#3e2a8172440473bd


But it didn't offer a real solution except running "keep alive"
process that will run a query every 20 minute.

I'll be happy to know if you found a real solution