we have a vendor DB which always keeps around 3GB of free space.
It is sql 2005 SP3 and DB Data size is 6.5 GB.
I took used space from
select fileproperty(Name,'SpaceUsed')/128 from sysfiles
I took size from
Select size from SYS.MASTER_FILES where name = 'DBName'
then calculating free space for each DB
i tried shrinking the file/DB once but it increased again, i know it is not recommended.
as if now it is not space crunch but i want to know why a DB keeps huge free space compared to it's data size.