Forum Discussion
SQLNovice0510
Feb 21, 2024Copper Contributor
Memory Pinning
Hi there,
Can someone explain to me how memory pinning works? and what is the optimized setting for performance? thank you.
1 Reply
Sort By
- olafhelperBronze Contributor
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]PINTABLESQL Server manage memory usage completely on its own, see Memory Management Architecture Guide - SQL Server | Microsoft Learn