全文檢索搜尋升級選項Full-Text Search Upgrade Options

您可以使用 [SQL Server]SQL Server 安裝精靈的 [全文檢索搜尋升級選項] 頁面,針對此時升級的資料庫選取要使用的全文檢索搜尋升級選項。Use the Full-Text Search Upgrade Options page of the [SQL Server]SQL Server Installation Wizard to select the full-text search upgrade option to use for the databases that you are upgrading at this time.

SQL Server 2005SQL Server 2005 中,每個全文檢索索引都位於屬於檔案群組、具有實體路徑而且被視為資料庫檔案的全文檢索目錄中。In SQL Server 2005SQL Server 2005 each full-text index resides in a full-text catalog that belongs to a filegroup, has a physical path, and is treated as a database file. 現在,全文檢索目錄是邏輯概念的虛擬物件-,這是指一組全文檢索索引。Now, a full-text catalog is a logical concept-a virtual object-that refers to a group of full-text indexes. 因此,新的全文檢索目錄不會被視為具有實體路徑的資料庫檔案。Therefore, a new full-text catalog is not treated as a database file with a physical path. 不過,在升級含有資料檔案的任何全文檢索目錄期間,系統會在相同的磁碟上建立新的檔案群組。However, during upgrade of any full-text catalog that contains data files, a new filegroup is created on same disk. 這會在升級之後保留舊磁碟 I/O 行為。This maintains the old disk I/O behavior after upgrade. 如果根路徑存在,則任何來自該目錄的全文檢索索引都會放置於新的檔案群組中。Any full-text index from that catalog is placed in the new filegroup if the root path exists. 如果舊的全文檢索目錄路徑無效,升級作業就會將全文檢索索引保留在與基底資料表相同的檔案群組中,或是保留在分割區資料表的主要檔案群組中。If the old full-text catalog path is invalid, the upgrade keeps the full-text index in the same filegroup as base table or, for a partitioned table, in the primary filegroup.

選項。Options

當您升級為 SQL Server 2014SQL Server 2014時,請選擇下列其中一個全文檢索升級選項。When you upgrade to SQL Server 2014SQL Server 2014, choose one of the following full-text upgrade options.

匯入Import
匯入全文檢索目錄。Full-text catalogs are imported. 一般而言,匯入的速度明顯比重建的速度更快。Typically, import is significantly faster than rebuild. 例如,只有使用一個 CPU 時,匯入的執行速度大約比重建的速度快 10 倍。For example, when using only one CPU, import runs about 10 times faster than rebuild. 不過,從 SQL Server 2005SQL Server 2005 匯入的全文檢索目錄並不會使用新增的強化斷詞工具,所以您最後可能會想要重建全文檢索目錄。However, a full-text catalog imported from SQL Server 2005SQL Server 2005 does not use the new and enhanced word breakers, so you might want to rebuild your full-text catalogs eventually.

注意

重建可以在多執行緒模式中執行,而且如果有 10 個以上的 CPU 可用,當您允許重建使用所有 CPU 時,重建的執行速度可能會比匯入的速度更快。Rebuild can run in multi-threaded mode, and if more than 10 CPUs are available, rebuild might run faster than import if you allow rebuild to use all of the CPUs.

如果無法使用全文檢索目錄,將會重建關聯的全文檢索索引。If a full-text catalog is not available, the associated full-text indexes are rebuilt. 只有針對 SQL Server 2005SQL Server 2005 資料庫才可以使用此選項。This option is available for only SQL Server 2005SQL Server 2005 databases.

如需有關匯入全文檢索索引之影響的詳細資訊,請參閱本主題後面的「選擇全文檢索升級選項的考量」。For information about the impact of importing full-text index, see "Considerations for Choosing a Full-Text Upgrade Option," later in this topic.

RebuildRebuild
全文檢索目錄會使用新的增強斷詞工具重建。Full-text catalogs are rebuilt using the new and enhanced word breakers. 重建索引可能需要很長的時間,而且在升級之後可能需要相當多的 CPU 和記憶體。Rebuilding indexes can take a lot of time, and a significant amount of CPU and memory might be required after the upgrade.

重設Reset
重設全文檢索目錄。Full-text catalogs are reset. SQL Server 2005SQL Server 2005進行升級時,全文檢索目錄檔案會遭到移除,但是全文檢索目錄和全文檢索索引的中繼資料則會保留。When upgrading from SQL Server 2005SQL Server 2005, full-text catalog files are removed, but the metadata for full-text catalogs and full-text indexes is retained. 在升級之後,所有的全文檢索索引都會停用變更追蹤,而且不會自動啟動搜耙。After being upgraded, all full-text indexes are disabled for change tracking and crawls are not started automatically. 當您在升級完成之後手動發出完整母體擴展之前,此目錄將會維持空白狀態。The catalog will remain empty until you manually issue a full population, after the upgrade completes.

所有的這些升級選項都可確保升級的資料庫可完全獲益於全文檢索效能增強功能。All of these upgrade options ensure that upgraded databases benefit fully from full-text performance enhancements.

選擇全文檢索升級選項的考量Considerations for Choosing a Full-Text Upgrade Option

當您為升級作業選擇升級選項時,請考慮下列事項:When choosing the upgrade option for your upgrade, consider the following:

  • 您如何使用斷詞工具?How do you use word breakers?

    SQL Server 2014SQL Server 2014 中的全文檢索搜尋服務包括斷詞工具和字幹分析器。The full-text search service in SQL Server 2014SQL Server 2014 includes word breakers and stemmers. 這些項目可能會針對特定文字模式或狀況,變更從 SQL Server 2005SQL Server 2005 全文檢索查詢的結果。These might change the results of full-text queries from SQL Server 2005SQL Server 2005 for a specific text pattern or scenario. 因此,在選擇適當的升級選項時,您如何使用斷詞工具便很重要:Therefore, how you use word breakers is important when choosing a suitable upgrade option:

    • 如果您所使用之全文檢索語言的斷詞工具並未變更,或者重新叫用精確度對您不重要,則適合進行匯入。If the word breakers of the full-text language you use did not change, or if recall accuracy is not critical to you, importing is suitable. 之後,如果您遇到任何重新叫用的問題,只要透過重建全文檢索目錄,就可以升級為新的斷詞工具。Later, if you experience any recall issues, you can upgrade to the new word breakers simply by rebuilding your full-text catalogs.

    • 如果您很重視重新叫用精確度,並使用在 SQL Server 2005SQL Server 2005之後加入的其中一個斷詞工具,則適合進行重建。If you care about recall accuracy and you use one of the word breakers that were added after SQL Server 2005SQL Server 2005, rebuilding is suitable.

  • 是否有任何全文檢索索引建立在整數全文檢索索引鍵資料行上?Were any full-text indexes built on integer full-text key columns?

    重建會執行內部最佳化,以便在某些情況中改善已升級之全文檢索索引的查詢效能。Rebuilding performs internal optimizations that improve the query performance of the upgraded full-text index in some cases. 具體而言,如果您擁有包含全文檢索索引的全文檢索目錄,其中基底資料表的全文檢索索引鍵資料行是整數資料類型,則重建會在升級之後達到理想的全文檢索查詢效能。Specifically, if you have full-text catalogs that contain full-text indexes for which the full-text key column of the base table is an integer data type, rebuilding achieves ideal performance of full-text queries after upgrade. 在此情況中,我們強烈建議您使用 [重建] 選項。In this case, we highly recommend you to use the Rebuild option.

    注意

    若為 SQL Server 2014SQL Server 2014中的全文檢索索引,我們建議當做全文檢索索引鍵的資料行必須是整數資料類型。For full-text indexes in SQL Server 2014SQL Server 2014, we recommend that the column serving as the full-text key be an integer data type. 如需詳細資訊,請參閱 改善全文檢索索引的效能For more information, see Improve the Performance of Full-Text Indexes.

  • 將伺服器執行個體保持在線上狀態的優先權為何?What is the priority for getting your server instance online?

    在升級期間匯入或重建會耗用大量 CPU 資源,因而延遲將其餘伺服器執行個體升級並保持在線上狀態的時間。Importing or rebuilding during upgrade takes a lot of CPU resources, which delays getting the rest of the server instance upgraded and online. 如果盡可能將伺服器執行個體保持在線上狀態很重要,而且您願意在升級之後執行手動母體擴展,則適合使用 [重設]If getting the server instance online as soon as possible is important and if you are willing to run a manual population after the upgrade, Reset is suitable.

其他資源Additional Resources