用於 SQL 資料庫的磁碟機之可用空間即將用盡 (SharePoint Server)Drives used for SQL databases are running out of free space (SharePoint Server)

  • 參與者
    • SteveHord
    • olprod

摘要：了解如何解決 SharePoint Server 2016 和 SharePoint 2013 的 SharePoint 狀況分析器規則「用於 SQL 資料庫的磁碟機即將用盡可用空間」的問題。Summary: Learn how to resolve the SharePoint Health Analyzer rule "Drives used for SQL databases are running out of free space" in SharePoint Server 2016 and SharePoint 2013.

規則名稱：用於 SQL 資料庫的磁碟機即將用盡可用空間。Rule Name: Drives used for SQL databases are running out of free space.

摘要：資料庫具有一或多個超過可用磁碟空間的檔案。如果發生此情況，操作可能會失敗。磁碟的可用空間應該要足以能夠讓最大型資料庫檔案自動成長至兩倍的大小。Summary: The databases have one or more files that exceed the available free disk drive space. If this happens, operations will fail. A disk drive should have enough free space to allow the largest database file to automatically grow to twice its size.

原因：資料庫具有超過可用空間的大型檔案。Cause: The databases have large files that may exceed the available free space.

解決方法： 釋出資料庫伺服器電腦上的磁碟空間。Resolution: Free disk space on the database server computer.

  1. 確認執行下列步驟的使用者帳戶是本機資料庫伺服器電腦上系統管理員群組的成員。Verify that the user account that is performing the following step is a member of the Administrators group on the local database server computer.

  2. 在[伺服器管理員] 中 [工具] 及 [磁碟重組及最佳化磁碟機。In Server Manager, click Tools, and then click Defragment and Optimize Drives.

  3. 執行 [最佳化磁碟機] 工具釋出伺服器電腦的磁碟空間。Run the Optimize Drives tool to free disk space on the server computer.

  4. 如果事件持續發生，請將一些大型檔案移動至其他磁碟以釋出空間。If the event persists, move some large files to another disk drive to free up space.

解決方案： 減少記錄檔的儲存天數。Resolution: Decrease the number of days to store log files.

  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 Reporting section, click Configure diagnostic logging.

  4. 在 [診斷記錄] 頁面上 [追蹤記錄檔] 區段的 [儲存記錄檔的天數] 方塊中輸入較小的數字。On the Diagnostic Logging page, in the Trace Log section, in the Number of days to store log files box, type a smaller number.

  5. 按一下 [ OK ]。Click OK.