Database has large amounts of unused space (SharePoint Server)
APPLIES TO: 2013 2016 2019 Subscription Edition SharePoint in Microsoft 365
Important
This health analyzer rule only applies to SharePoint 2010 as this was removed in KB4011601 for SharePoint Server 2013 and KB4011576 for SharePoint Server 2016.
Rule Name: Database has large amounts of unused space.
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's 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 autogrowth size plus 50 megabytes (MB).
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.
Normally you can safely ignore this event. You shrink a database only if it proves necessary — for example, when you have performed an operation that removes a large quantity of data from a database, and the free space isn't expected to be used again. You can shrink the database by using the DBCC ShrinkDatabase command or SQL Server Management Studio. For more information, see DBCC SHRINKDATABASE (Transact-SQL) (https://go.microsoft.com/fwlink/p/?LinkID=110852) and Shrink a Database (https://go.microsoft.com/fwlink/p/?LinkID=224904).
The white paper Database maintenance for SharePoint provides important guidelines for shrinking a database. We strongly recommend that you read this white paper before you shrink a database.