Backgound update of FTI

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
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'),'TableFullText BackgroundUpdateIndexOn')
where authors is the table you are interested in. A value of 1 will indicate
change tracking with update index in background.
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
"Murli" <Murli@.discussions.microsoft.com> wrote in message
news:0F65C42D-CDED-4D74-9442-3045D98BAC56@.microsoft.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
> 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
>