FTI - Full population

FTI - Full population

Post by mitra fato » Sat, 13 Sep 2003 06:17:55


Hi All,

Can a Full population be stopped in the middle of the
process and then later resume from where we had stopped
the process?

Thank you,
-Mitra
 
 
 

FTI - Full population

Post by Andrew Cen » Sat, 13 Sep 2003 06:46:28

The only way to do this would be to stop the MSSearch service (it will pick
up automatically when it is started again). Of course, this makes the
entire Full-Text functionality unavailable so that's probably not ideal.

Thanks,
--andrew

Andrew Cencini
Program Manger
Microsoft Corp. - SQL Server Engine

 
 
 

FTI - Full population

Post by mitra fato » Sat, 13 Sep 2003 07:32:39

Andrew,

Thank you for your prompt reply!

Is there any MSSerach service documentation online that
explains the implications of stopping the MSSerch service
in middle of a full population.

I really like to read a little bit more about it before
giving the okay to our client since they have a big
database that they need to implement the full population
and they want to make sure it is okay to stop in the
middle of the process and resume from where it was stopped.

Thanks,
-Mitra
service (it will pick
this makes the
probably not ideal.
confers no rights.
 
 
 

FTI - Full population

Post by Andrew Cen » Sat, 13 Sep 2003 08:20:40

Probably the closest things I could find would be :

http://www.yqcomputer.com/ %20paper.asp

and

http://www.yqcomputer.com/

Both could be of use in understanding Full-Text Search more -- though there
is not much specific on what is the risk of stopping the service.
Basically, I'd be careful in just stopping the service unless you really
need to -- since that can be quite disruptive; however, the gatherer does
know where it left off (this is SQL2000, right?) and picks up where it
stopped when the service comes back.

Thanks,
--andrew

Andrew Cencini
Program Manger
Microsoft Corp. - SQL Server Engine
 
 
 

FTI - Full population

Post by Hilary Cot » Sat, 13 Sep 2003 08:41:08

concur with Andrew on this.

However - I believe a net pause mssearch has the functionality you are
looking for.

The population is paused and querying (of the partially built catalog) can
be done.

You can also pause the population by using the searchadmin objects.

I don't recommend doing this though as the catalog is in an inconsistent
state and ranking will not be consistent.

I would recommend opening up a support incident with PSS for more
information on the implications of doing this.


"Andrew Cencini [MSFT]" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
http://support.microsoft.com/default.aspx?scid=/support/sql/content/2000pape
rs/fts_white%20paper.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/sql_fulltextsearch.asp
there
rights.


 
 
 

FTI - Full population

Post by John Kan » Sat, 13 Sep 2003 09:23:35

ilary & Andrew,
While I'm aware of the difficulty of stopping a large FT population in
progress, the documented method for stopping a FT Population is in the SQL
2000 BOL title "sp_fulltext_catalog"

D. Stop the population of a full-text catalog
This example stops the population of the Cat_Desc catalog.

USE Pubs
go
EXEC sp_fulltext_catalog 'Cat_Desc', 'stop'

Hilary, pausing the MSSearch service, while possible will also affect all
other FT Populations - assuming (of course) that you intend to stop only one
FT Catalog's population.

Regards,
John


"Hilary Cotter" < XXXX@XXXXX.COM > wrote in message
news:# XXXX@XXXXX.COM ...
http://support.microsoft.com/default.aspx?scid=/support/sql/content/2000pape
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
does


 
 
 

FTI - Full population

Post by Naser gera » Sat, 13 Sep 2003 13:07:16

Hi all.

I have an keywords table by 2000000 rows that contains an
int(4) key and a varchar(50)
Keyword(Unique index) in Sql Server 2000. I need very fast
searching this table and so I Used Full-text Service.

the problem is: After about 80 seconds of starting full
population, speed of adding new items (that is showed
in Enterprise manager/ctalogname/Properties), decreases
suddenly to (1/4) and more less.

Once and only in once Full population, i could Fix this
rate, but after it the speed decreases continusely. I have
no sufficent time to search and solve it.

My system hardware specification is:
CPU: 2200 MHz
RAM: 256 MB DDR Ram 333 MHZ
MB_FSB: 333 MHZ

please guide me to configure my hardware and solve this
problem.

Every thanks...
 
 
 

FTI - Full population

Post by Naser gera » Sat, 13 Sep 2003 13:10:17

Yes. by Start Incremental Population you can continue
previous population.
 
 
 

FTI - Full population

Post by Hilary Cot » Sat, 13 Sep 2003 20:46:02

lease ignore my advice about pausing a population using
the net pause command.

This command is NOT valid for the mssearch service.

population in
Population is in the SQL
also affect all
intend to stop only one
functionality you are
built catalog) can
searchadmin objects.
in an inconsistent
PSS for more
wrote in message
scid=/support/sql/content/2000pape
url=/library/en-us/dnsql2k/htm
Search more -- though
the service.
service unless you really
however, the gatherer
picks up where it
and confers no
message
that
service
before
population
stopped.
MSSearch
course,
that's
warranties, and
message
of the
stopped
 
 
 

FTI - Full population

Post by John Kan » Sat, 13 Sep 2003 23:22:47

Naser,
When possible, please post your questions to a separate thread as this
thread is about stopping a FT Population already in progress...

You could be seeing normal performance issue, depending upon your
configuration. For example, is your FT Catalog on the same disk drive as
your database files (*.mdf, *.ndf or *.ldf)? If so, then drop and re-create
the FT Catalog on a separate drive &/or disk controller as your slow down
may be due to I/O contention with both reading & writing to the same disk
drive at the same time. See SQL Server 2000 BOL title "Full-Text Search
Recommendations" for more info.

Regards,
John
 
 
 

FTI - Full population

Post by John Kan » Sat, 13 Sep 2003 23:25:14

Naser,
I don't believe this is true and while it may *seem* like that an
Incremental Population "continues a previous" Full Population, in reality a
*new* Incremental Population is actually started that has nothing to do with
the previous FT Population.

Regards,
John