I have a windows server for host about 4500 data bases for same application. And this application have 34 fulltext catalogs on it, and the CHANGE_TRACKING for this fulltext index are AUTO.
And the point is, same times I need to shut down the server or move between clusters nodes, and when it’s starting up, all this 4500 databases was taking on line, and SQL server fulltext engine start the change tracking the fulltext index, all of the 153000 (34 catalogs x 4500 databases) at the same time. And this server takes a wile to bee online again. At the last time that was happen, I sow, after run SP_WHO2 on console, lots of FT_Gather command running, I know that this command is involved on fulltext crawl, but I’m not sure.
We are reviewing same aspects of this application, like: 1) We are taking off same of this fulltext indexes, 2) We are reducting the number of databases hosted on this server. 3) We are studing a change on CHANGE_TRACKING and force incremental reindex, with a Timestamp column.
But one doubt still alive, 1) Why the SQL SERVER take this lots of time to take online my fulltext catalogs?
Anyone can help us with this questions?