July 28, 2011 at 11:22 am
Hi,
We are doing a application performance testing and noticed the below reading for the memory from Perfmon counters.
From beow reading, is there any issue with Memory? or it's good enough?
What is the lowest value that we can have for Availbale memory (in MB)?
Is the page file usage normal?
We have a total 2 GB RAM and it's a test environment
Memory\Available MBytesPaging File(\??\C:\pagefile.sys)\% UsagePaging File(\??\C:\pagefile.sys)\% Usage Peak
103 25.7245463775.68006171
111 25.7835410675.68006171
120 25.7799135575.68006171
121 25.7459295675.68006171
118 25.7457386475.68006171
120 25.7407746875.68006171
July 28, 2011 at 11:27 am
Can you format that a little better? Maybe upload as txt file so the formatting is not lost in html.
July 28, 2011 at 12:42 pm
Why are you looking at lowest memory? The less memory, the lower the performance because your memory pools shrink and you have to go to disk for more data.
you can get by, IIRC with about 200MB of RAM, but things will run slow. I think the minimum recommended for SQL 2005 is probably 512MB, but 1024 recommended. http://msdn.microsoft.com/en-US/library/ms143506%28v=SQL.90%29.aspx
July 28, 2011 at 1:20 pm
how big is the page file? If its 10GB and 25% used then i'd say you need more RAM. You want as much going through RAM and as little written to the page file as you can.
If this is a test system and you can cope with the overhead then leave it
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
July 28, 2011 at 5:48 pm
how big is the page file? If its 10GB and 25% used then i'd say you need more RAM. You want as much going through RAM and as little written to the page file as you can.
The page file size is default option i.e 2046 MB
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply