Forum Discussion
Memory Pinning
Hi there, Can someone explain to me how memory pinning works? and what is the optimized setting for performance? thank you.
SQLNovice0510 Memory pinning?
Do you mean DBCC PINTABLE command? Out-of-support and has nowdays absolutely no effect, see SQL Server, Deprecated Features object - SQL Server | Microsoft Learn => DBCC [UN]PINTABLE
SQL Server manage memory usage completely on its own, see Memory Management Architecture Guide - SQL Server | Microsoft Learn