Re: Initial search taking a long time

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Just noticed something important..

The time between searches does not matter, it seems that every 20
minutes or so (regardless of whether there were searches during this
period), something "resets" and the first search occuring after that
time takes a really long time to execute..

So I think this might not be a memory issue.

bryon.chan wrote:
There is one gig of physical ram, although its running on a virtual
machine.

I need to talk with the "tech" guys about this setting, because they
are responsible for it not me. But doesn't this mean that theres more
than enough memory for the SQLFT.?

Do you know how else I could diagnose the situation? for example, any
tools I could use to monitor whats happening when one of the long
searches is executing?


Hilary Cotter wrote:
Holy moley, you have 2,147,483.647 Gigs of Ram! Is this your laptop? the
unit is in mgs. If this is SQL 2005 take the physical RAM on your machine
and subtract one gig from it. This should be the value you are using here.


--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"bryon.chan" <bryon.chan@xxxxxxxxx> wrote in message
news:1163019170.966059.179310@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
sp_configure 'max server memory (MB)'

max server memory (MB) 16 2147483647 2147483647 2147483647


.

Relevant Pages

  • Re: Backup failure due to full-text indexing
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Shift the backup log after backup database (it was starting at the same ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Invalid Descriptor Index
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.replication)
  • Re: Republishing Data - Merge Replication Filter Location?
    ... "Hilary Cotter" wrote: ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: sp_addarticle without re-creating entire new snapshot
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... "Hilary Cotter" wrote: ... Use Paul ...
    (microsoft.public.sqlserver.replication)
  • Re: Republishing Data - Merge Replication Filter Location?
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.replication)