SharePoint 使用的資料庫含有過期的索引統計資料 (SharePoint Server)Databases used by SharePoint have outdated index statistics (SharePoint Server)

摘要:了解如何解決 SharePoint Server 2016 和 SharePoint 2013 的 SharePoint 狀況分析器規則「SharePoint 使用的資料庫含有過期的索引統計資料」的問題。Summary: Learn how to resolve the SharePoint Health Analyzer rule "Databases used by SharePoint have outdated index statistics" for SharePoint Server 2016 and SharePoint 2013.

規則名稱:SharePoint 使用的資料庫含有過期的索引統計資料。Rule Name: Databases used by SharePoint have outdated index statistics.

摘要:過期的索引統計資料會降低查詢效能,並造成 SharePoint Server 2016 和 SharePoint 2013 回應緩慢。Summary: Outdated index statistics can decrease query performance and cause SharePoint Server 2016 and SharePoint 2013 to respond slowly.

原因:SharePoint Server 資料庫中的索引統計資料已過期。Cause: Index statistics in SharePoint Server databases are out of date.

注意

[!附註] 依預設,這個 SharePoint 狀況分析器規則會每日啟用。This SharePoint Health Analyzer rule is enabled daily by default.

解決方案:編輯規則定義,以自動修復設定。Resolution: Edit the rule definition so that the configuration is automatically repaired.

  1. 確認執行此程序的使用者帳戶為伺服器陣列管理員群組的成員。Verify that the user account that is performing this procedure is a member of the Farm Administrators group.

  2. 在管理中心首頁] 頁面上,按一下 [監視]。On the Central Administration Home page, click Monitoring.

  3. 按一下 [監視] 頁面的 [狀況分析器] 區段的 [檢閱規則定義]。On the Monitoring page, in the Health Analyzer section, click Review rule definitions.

  4. 在 [狀況分析規則定義-所有規則] 都頁面中類別: 效能] 區段中,按一下規則的名稱。On the Health Analyzer Rule Definitions - All Rules page, in the Category: Performance section, click the name of the rule.

  5. 在 [狀況分析規則定義] 對話方塊中,按一下 [編輯項目In the Health Analyzer Rule Definitions dialog box, click Edit Item.

  6. 選取自動修復] 核取方塊,然後再按一下 [儲存Select the Repair Automatically check box, and then click Save.

另請參閱See also

其他資源Other Resources

索引統計資料Index Statistics