Monday, March 19, 2012

Got Memory?

Here are some perf counter stats from a box I am trying to better performance on:

buffer cache hit/avg 99.5

page reads/sec 5000

stolen pages 114000

page life expectancy 5!!!!!!!!!!!!!!!

the server is x86 sql 05' std. with the 2gb cap w/o awe enabled config. 2 Xeon 3.06 GHZs physical CPUs each dual core thus 4 logical CPUs with total system mem of approx 3.75 gb.

that page life metric is very concerning to me I am new to tuning sql memory but I would like to know right off the bat if his 2gb cap is not "gonna cut it" for his workload needs, I would hate to have to recommend 64 bit to him ahhhh, $$$. He actually has 3 identical boxes load balacned with a cisco device. (gets a ton of Inet traffic to the front-end Cold Fusion sites). His frontend app uses several DBs ranging in size from 4GB-42GB.

Thanks,

Derek

I changed the min/max memory options to both be aprox 2gb and now my page life exp jumped to 45 avg.

No comments:

Post a Comment