May 12, 2011 at 12:53 am
What are the objects or counters added for identify the memory bottle neck?and how to find out?
May 12, 2011 at 2:30 am
There is no easy solution to it. you have to capture the perfmon data to get a clear picture of whether or not you have some memory bottleneck on your database server.
I would recommend you first read out this link.
http://technet.microsoft.com/en-us/library/cc749872.aspx
Sachin
May 12, 2011 at 2:32 am
i tend to use system monitor for analysis and for memory analysis i would use
Memory pages / sec
Memory Available bytes
buffer manager buffer cache hit ratio
physical disk - reads/sec
physical disk - writes/sec
May 12, 2011 at 2:47 am
physical disk - reads/sec
physical disk - writes/sec
would you pls elaborate that how could physical disk counters like reads/Sec and Writes/Secs as you mentioned could help you analyse memory issue.
To best of my knowledge these counters are Disk related counters and are used to montior your DiskIO performance.
Regards,
Sachin
May 12, 2011 at 3:03 am
i do agree with you, i wasnt sure either but i would just take those readings along with the memory counters to help understand the memory situation better- when i was doing this i was sitting with consultants and they were telling me that - you can identify memory bottlenecks via excessive paging, high consumption, a low buffer cache hit ratio and high volume of disk read and write io operations - and that a reading that grows over time may indicate a memory pressure somewhere.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply