SQL Server Performance

How do you check for and determine OS or SQL trimming of a SQL Server working set?

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Mar 9, 2014.

  1. Trev256b Member

    1) How do you check for and determine OS trimming of a SQL Server working set? I want to determine when the OS trims the SQL Server working set and by how much. I want to also determine how much space is trimmed i.e. how many MB is cleared from physical memory so virtual memory is used instead?
    2) How can you also determine if SQL is swapping processes in and out of memory? I want to see if processes are queuing for memory or if the total RAM is being used by active SQL Server processes. Can we check to see if the 'total server memory' performance counter actually displays the 'active' SQL Server processes in memory?

Share This Page