The following script could be helpful in determining the current usage of the database for FIM 2010. It does gives provide a good indication whether the database needs to be shrinked.
After aggressively deleting the expired system objects like Request, Workflow Instance and Approval, it did leave a significant amount of space as free space. Shrinking the database will help free up that unused space.
Here is a script for your easy reference:
Use FIMService Go Select a.FILEID, CONVERT(decimal(12,2),ROUND(a.size/128.000,2)) as [FILE_SIZE_IN_MB], CONVERT(decimal(12,2),ROUND(fileproperty(a.name,'SpaceUsed')/128.000,2)) as [SPACE_USED_IN_MB], CONVERT(decimal(12,2),ROUND((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) as [FREE_SPACE_IN_MB], a.name AS [DATABASE_NAME], a.FILENAME as [FILE_NAME] FROM dbo.sysfiles a