Key Performance Counters Related to memory :
General Memory Counters :
Available Mbytes,
Pages Inputs / Sec,
Paging File
%Usage
Related to Memory Grants :
Granted Memory,
Maximum Memory,
Grants Outstanding,
Grants Pending
Related to SQL Server Buffer :
Lazy Writes / Sec,
PLE, Pages Reads & Writes,
ReadAhead,
Buffer Cache hit Ratio
If you decide to go little further and capture more in details on Memory Distribution
Procedure Cache Pages,
Stolen pages,
Total Server Mem,
Target Server Mem,
Data Pages,
Free Pages
Private Bytes,
Working Set are other key counters
You will be able to find all these in, Memory, Process, SQL Server memory manager & SQL Server Buffer manager
General Memory Counters :
Available Mbytes,
Pages Inputs / Sec,
Paging File
%Usage
Related to Memory Grants :
Granted Memory,
Maximum Memory,
Grants Outstanding,
Grants Pending
Related to SQL Server Buffer :
Lazy Writes / Sec,
PLE, Pages Reads & Writes,
ReadAhead,
Buffer Cache hit Ratio
If you decide to go little further and capture more in details on Memory Distribution
Procedure Cache Pages,
Stolen pages,
Total Server Mem,
Target Server Mem,
Data Pages,
Free Pages
Private Bytes,
Working Set are other key counters
You will be able to find all these in, Memory, Process, SQL Server memory manager & SQL Server Buffer manager
