Full text slow startup on SQL 2005 x64, Win2003 x64

Hi there,
We have a problem with a slow startup of the SQL 2005 full text engine on a
new box. The first query (after a reboot or first query in the morning)
against the full text index is very slow, it takes around 30 seconds to
execute. The full text index is very small (~2 mb), so this should not be an
issue.
On another server with the same database we don't see this problem. The
first query is executed in less than a second.
The only difference between the servers is that the server with the slow
full text is running SQL 2005 Standard x64 and Windows 2003 Standard x64.
The other server is running SQL 2005 Standard and Windows 2003 Standard.
Any suggestions?
I was just about to do a post for the same thing. I'm seeing this same
problem on two machines; both are Win2k3 Enterprise (32 bit); one is SQL
Server 2005 Enterprise and one is using 2005 Developer; both machines have
2GB RAM. The first query using FTS that I run takes ~45 seconds and then
every one after that is very fast (< 1 second), for about 10 or 15 minutes.
Every 10 or 15 minutes (haven't timed it exactly), it does the 45 second
thing again. Both machines have the same database (one's a development copy),
and the table with the index is only about 60MB, with ~40K rows.
Any help would be much appreciated.
thanks,
michael
"Rasmus Waeherns" wrote:

> Hi there,
> We have a problem with a slow startup of the SQL 2005 full text engine on a
> new box. The first query (after a reboot or first query in the morning)
> against the full text index is very slow, it takes around 30 seconds to
> execute. The full text index is very small (~2 mb), so this should not be an
> issue.
> On another server with the same database we don't see this problem. The
> first query is executed in less than a second.
> The only difference between the servers is that the server with the slow
> full text is running SQL 2005 Standard x64 and Windows 2003 Standard x64.
> The other server is running SQL 2005 Standard and Windows 2003 Standard.
> Any suggestions?
>
>
|||Hi there,
We tried everything, from reinstalling SQL Server 2005, disabling services,
restoring new databases, rebuilding full text index - you name it, and
didn't find a solution for the problem.
We've now reinstalled Windows 2003 x64 and SQL 2005 x64 on the server and
now the problems are gone. Weird!
Best regards,
Rasmus Waehrens
"ackphht" <ackphht@.discussions.microsoft.com> wrote in message
news:1B500AE2-5EBD-461C-90FE-6B1594D0B9F8@.microsoft.com...[vbcol=seagreen]
>I was just about to do a post for the same thing. I'm seeing this same
> problem on two machines; both are Win2k3 Enterprise (32 bit); one is SQL
> Server 2005 Enterprise and one is using 2005 Developer; both machines have
> 2GB RAM. The first query using FTS that I run takes ~45 seconds and then
> every one after that is very fast (< 1 second), for about 10 or 15
> minutes.
> Every 10 or 15 minutes (haven't timed it exactly), it does the 45 second
> thing again. Both machines have the same database (one's a development
> copy),
> and the table with the index is only about 60MB, with ~40K rows.
> Any help would be much appreciated.
> thanks,
> michael
> "Rasmus Waeherns" wrote: