Memory Pinning

[SQLNovice0510]

Hi there,

Can someone explain to me how memory pinning works? and what is the optimized setting for performance? thank you.

[#2]

@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