If I have a SQL server process that has been running for some time, are there any methods to determining how much memory it really needs to run? I have a couple of low usage databases and I want to ...
How about “Dude, Where Is My Memory? Understanding Microsoft SQL Server Memory Usage and Management” by Maciej Pilecki. I thought SQL Server just grabbed all the memory it could and never gave it back ...