• Server Configuration

    ----------------------

    Windows 2003 R2 Enterprise Edition 64 bit SP2

    RAM - 96 GB

    SQL version - SQL Server 2008 R2 SP2 Enterprise Edition 64 bit

    Memory allocated to SQL Server -- min = 0, Max = 86 GB

    Checked in logs found Locked pages are enabled.

    When I check in the Task Manager--PF Usage it is 92.3 GB (consistently) due to it the applications are running slow.

    Checked in Task Manager- Processes--sqlservr.exe is using 0.7 GB of memory & calculated all the processes it is not taking more than 15 GB of memory.

    I still cant figure out which application\program is using the rest of the memory.

    Please suggest.