Excessive Free Space in Database File
This warning indicates that there is excessive free space in the database file. If this isn't intentional, disk space could be recovered by shrinking the data file.
Suggested Action
š” Aireforge Advisor can automatically generate a script for this.
Consider reducing the free space to leave 10% free if it's unlikely to be used.
How to Recover Free Space From SQL Server Data Files
USE [master]
GO
DBCC SHRINKFILE(N'WhippetWorks', 128)
GO
Further Reading
DBCC SHRINKFILE (Transact-SQL) | Microsoft Docs