How to confirm your update item is going to do incremental crawl or not ?

 

Search problem for the sub sites… unable to get any error from iis, uls log.

 

so we need go to search database to see can get any information.

 

in this case is we want to see the specify sites after i add the item in , this item going to involved in incremental crawl or not.

 

normally we can see the item at MSSChangeLogCookies table before the incremental crawl start.

 

1. Run this query: select * from dbo.MSSChangeLogCookies order by UpdateTime desc > you will see all the item change going to crawl

This table keeps track of the last change that the crawler processed for each content database.  You'll want to look at the ChangeLogCookie_new column and you'll see several rows but the output of each will look something like this:

 

1;0;1b82082a-66eb-47bb-a053-26dde844f5ac;634242420353000000;7403

 

The GUID 1b82082a-66eb-47bb-a053-26dde844f5ac is the content database id

 

i already have the Database ID on the sites (go to your content DB , check the database information table will know) , so i will search the results and see my database id is available on the MSSChangeLogCookies.

 

if you want see how many crawl from the content DB you check, you can use below query on the targert content db:

select * from eventcache with (NOLOCK) where ID > '’7403'

 

so the total row is the item goign to crawl

 

yeah  !! found the item…so go to run the incremental crawl now…but after run also not working!!! ha ha ha…continue checking….DAY 5

 

here you go for more detail on the .MSSChangeLogCookies :

http://blogs.msdn.com/b/russmax/archive/2008/11/17/how-to-determine-the-number-of-changes-an-incremental-crawl-will-process-prior-to-initiating-the-crawl.aspx

http://www.cnblogs.com/awpatp/archive/2010/11/02/1866938.html > Chinese version