Backgound update of FTI

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Murli - 18 Jul 2005 18:03 GMT

I know that with background updates the FTI is updated incrementally as
inserts and updates which affect the indexed column occur. How can I tell if
an FTI on a column has been set for background updates?

Also, do you know if there is a performance downside to having background
updates enabled? Could you point me to any studies or papers where the pros
and cons of the different update strategies (background Vs Incremental Vs
Full) are explored?

If background updating is enabled, then from SQL Profiler how can I track
the queries being run for the updates and how long the updates are taking?

Thanks.
Murli

Reply to this Message

Hilary Cotter - 18 Jul 2005 19:07 GMT

Some people prefer to schedule the updating of the indexing process to a
time when there is less activity on their system.

To tell if you are using update index in background issue a

select
objectproperty(object_id('authors'),'TableFullTextBackgroundUpdateIndexOn')

where authors is the table you are interested in. A value of 1 will indicate
change tracking with update index in background.

Signature

Hilary Cotter
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

> I know that with background updates the FTI is updated incrementally as
> inserts and updates which affect the indexed column occur. How can I tell if
[quoted text clipped - 10 lines]
> Thanks.
> Murli

Reply to this Message