Catalog size up and down ???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gordowey - 30 Oct 2005 00:52 GMT

Is that normal??

I am populating my catalog, and i see the catalog size growing 45MB,
47MB, 52MB..1MB

and suddenly it goes to zero and starts again

Is that normal??

thanks

Alberto

Reply to this Message

Gordowey - 30 Oct 2005 00:55 GMT

The final size should be about 900MB , but is only 70MB...what is
happening:??

please help!!

Reply to this Message

John Kane - 30 Oct 2005 08:49 GMT

Gordowey,
Could you post the full output of -- SELECT @@version -- as this will be
helpful info in troubleshooting SQL FTS or FT Indexing issues. How many rows
in your FT-enabled table? Did you run a Full or Incremental population? If
the latter, does the FT-enabled table have timestamp column?

You should review your server's Application event log for "Microsoft Search"
or MssCi souse events. What I suspect that is happening is normal & expected
and caused by either a Shadow merge or Master Merge of FT Catalog files
usually in 50K increments being merged into a single compressed Master
catalog file. Note, the FT Catalog files are compressed so it will not be
the same size as the text in your FT-enabled column.

Thanks,
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> The final size should be about 900MB , but is only 70MB...what is
> happening:??
>
> please help!!

Reply to this Message

Gordowey - 30 Oct 2005 18:17 GMT

Hi John, thanks for your answer..I have sent you by email some info
about my problem..please take a look and help me..

thanks a lot

Alberto

Reply to this Message