Hi let me first say I know shrinking a Database is bad for fragmentation.
What I want to know is with a very large database, does it cause a performance issue to have a lot of unused space. I'm talking about a 1.8 TB database with 475 GB of unused space.
I ask this not because I want to shrink it, but because I want to avoid the manual file growth requirement (not set by me) to grow the data file when there is less than 20% free space.
I'd prefer to configure auto growth at 8GB and let it roll which got me thinking about, "how does the amount of free space within a data file relate to performance"?