how to identify Memory bottleneck

Question

how to identify Memory bottleneck

Coolroof

SSCrazy

Points: 2072
More actions
May 12, 2011 at 12:53 am

#142597

What are the objects or counters added for identify the memory bottle neck?and how to find out?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

sachnam SSCrazy Points: 2317 More actions · Answer 1

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

BLOB EATER SSChampion Points: 14604 More actions · Answer 2

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

sachnam SSCrazy Points: 2317 More actions · Answer 3

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

BLOB EATER SSChampion Points: 14604 More actions · Answer 4

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.