Home Forums SQL Server 2005 Administering Memory Optimization RE: Memory Optimization

  • May 7, 2013 at 7:56 am

    #1612991

    Neeraj Dwivedi (5/7/2013)

    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.

    Yes I have

    Which memory status am I looking for under DBCC memorystatus?

    thanks