Database has large amounts of unused space (SharePoint Foundation 2010)
Published: November 15, 2011
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 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).
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 absolutely necessary — for example, when you have performed an operation that removes a very large quantity of data from a database, and the free space is not 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) (http://go.microsoft.com/fwlink/p/?LinkID=110852) and How to: Shrink a Database (SQL Server Management Studio) (http://go.microsoft.com/fwlink/p/?LinkID=224904).
The white paper Database Maintenance for Microsoft SharePoint 2010 Products (http://go.microsoft.com/fwlink/p/?LinkID=229104) provides very important guidelines for shrinking a database. We strongly recommend that you read this white paper before you shrink a database.