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?