Home Forums SQL Server 2005 Administering Memory Optimization RE: Memory Optimization
Neeraj Dwivedi
SSCertifiable
Points: 6768
More actions
May 7, 2013 at 7:51 am
#1612988
Have you given the ‘Lock pages in memory’ right to the account used by the SQL Server instance?
Also the task manager is not a right place to look for how much memory SQL server is using.
Run DBCC MEMORYSTATUS to see the actual values.