Are Population Schedules required?

Hi All: I have an FT Cat with 3 tables in it that I created 6 months ago.
Each table in the FT Cat has "track changes" set to "automatic"
There's no defined population schedule.
Will this catalog be updated automatically when the data in the tables
changes, or does it require a population schedule to regularly refresh the
FT Catalog?
TIA
It will be updated within seconds - change tracking updates the index near
real time.
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
"geek-y-guy" <noone@.nowhere.org> wrote in message
news:%23rTq57VQHHA.3460@.TK2MSFTNGP03.phx.gbl...
> Hi All: I have an FT Cat with 3 tables in it that I created 6 months ago.
> Each table in the FT Cat has "track changes" set to "automatic"
> There's no defined population schedule.
> Will this catalog be updated automatically when the data in the tables
> changes, or does it require a population schedule to regularly refresh the
> FT Catalog?
> TIA
>
>
|||Thanks Hilary!
So, just for my edification, what are population schedules for? For very
large cats & datasets where you would NOT want it automatically updating,
but would want to schedule repopulation say once daily at 3 am?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OshsXadQHHA.4276@.TK2MSFTNGP02.phx.gbl...
> It will be updated within seconds - change tracking updates the index near
> real time.
> --
> 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
>
> "geek-y-guy" <noone@.nowhere.org> wrote in message
> news:%23rTq57VQHHA.3460@.TK2MSFTNGP03.phx.gbl...
>
|||Hello geek-y-guy,
Historically in SQL 2000, populations could impact querying (errors occurring)
so you may have wanted to do delay the population.
If you have lots of changes you may still want to delay population to avoid
the performance hit of population and querying
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> Thanks Hilary!
> So, just for my edification, what are population schedules for? For
> very large cats & datasets where you would NOT want it automatically
> updating, but would want to schedule repopulation say once daily at 3
> am?
>
|||In general you should always use change tracking as it offers best
performance and near real time indexing. If you select manual change
tracking you can update the index during quiet times or in batches to
minimize the impact of locking during indexing.
There are two other indexing options: full-populations and incremental
populations. If the bulk of your data changes in regular patterns you might
want to schedule a full-population. Incremental populations work best when a
smaller portion of your data changes at a time. In this case you could
schedule an incremental population.
As change tracking can lead to some fragmentation you might want to schedule
the reorganization of your catalog.
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
"geek-y-guy" <noone@.nowhere.org> wrote in message
news:%230E6UWkQHHA.4448@.TK2MSFTNGP04.phx.gbl...
> Thanks Hilary!
> So, just for my edification, what are population schedules for? For very
> large cats & datasets where you would NOT want it automatically updating,
> but would want to schedule repopulation say once daily at 3 am?
> --
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OshsXadQHHA.4276@.TK2MSFTNGP02.phx.gbl...
>