Hello. When doing a shrink database - Under "Available free space" - What percentage % free would you say is in the danger zone? What are the ranges you think are acceptable and at what % will we start to see performance issues.
Only do a shrink when you know you don't need that extra space for a very long time. When I do shrink a database, I leave at least 10% of free space but typically 20%. I do not shrink just because I have more than 20%. I shrink only on rare occasions, such as when we do a massive delete and need that space for some other database.
% has nothing to do with performance except as djj55 mentions regarding having to expand the file.