資料庫有大量的未使用空間 (SharePoint Server)Database has large amounts of unused space (SharePoint Server)

摘要: 了解如何為 SharePoint Server 2016 和 SharePoint 2013 解決 SharePoint Health Analyzer 規則「資料庫中有大量的空間未使用」。Summary: Learn how to resolve the SharePoint Health Analyzer rule "Database has large amounts of unused space" for SharePoint Server 2016 and SharePoint 2013.

規則名稱: 資料庫中有大量的空間未使用。Rule Name: Database has large amounts of unused space.

摘要: 資料庫的磁碟配置有大量未使用的空間。除非壓縮此資料庫的大小,否則資料庫會使用檔案系統上的大量空間。如果未使用的空間超過磁碟空間的 20% 並大於自動成長大小加上 50 MB,則會發生此事件。Summary: The database has large amounts of unused space allocated on the disk. This database uses a large amount of space on the file system unless it is shrunk down to a small size. This event occurs if the unused space is more than 20% of the disk space and the unused space is greater than the auto-growth size plus 50 megabytes (MB).

原因: 有許多活動會在資料庫中產生未使用的空間。這些活動包括執行 Windows PowerShell Move-SPSite 命令,以及刪除文件、文件庫、清單、清單項目及網站。Cause: Many activities can create unused space in the database. These activities include running the Windows PowerShell Move-SPSite command, and deleting documents, document libraries, lists, list items, and sites.

解決方案:忽略此事件,或在必要時壓縮資料庫。** Resolution: Ignore this event, or shrink the database if you have to.**

另請參閱See also

其他資源Other Resources

壓縮資料庫Shrinking a Database