December 15, 2011 at 3:36 am
Hi All,
Which counters give the exact utilization of memory for SQL Servers ? I believe Total Server Memory(SQL Server consuming memory) and Total Target Memory(SQL Server willing to consume memory) are the counters which give the utilization of memory. Are there any others counters which help in analyzing memory utilization for SQL Server?
Thanks in advance.
December 15, 2011 at 4:47 am
Don't be surprised when those values constantly read almost exactly the same. Some counters that are going to change that will show you how things are behaving would include:
memory:pages/sec, page faults/sec
sqlserver:buffer manager:page life expectancy, checkpoint pages/sec, lay writes/sec
sqlserver:memory manager: memory grants pending
That set will tell you more about what's happening than the two you listed.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply