RAM determination

[wbodger]

Our SysAdmin has recently left and he neglected to finish off one thing I had asked him about before he left, so... I need to upgrade the RAM on our SQL Server box, but all that I know is that it is ECC RAM. Is there any way within the OS to get more precise info as to exactly what it is that I need to get? Or a I just going to have to take the server down and inspect it physically?

WB

 

[ptheriault]

What version of SQL Server and OS do you have installed?
Also if you select start -> run -> type msinfo32 <enter>

This will give you the info your looking for.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[wbodger]

SQL Server 2000 SP4 Ent Ed, Windows Server 2003, Ent Ed.

 

[ptheriault]

How much memory do you currently have installed and how much do you want to have? Have you run perfmon? How do you memory counters look now?

Here is a link to help you set up perfmon if you haven't run anything yet.

http://www.databasejournal.com/features/mssql/article.php/3506526

I would run a perfmon trace at peak usage. Post your findings back here.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[wbodger]

I currently have 2 Gb, I would like to have 6-8, I think. I have looked at Perfmon and it appears to be maxed, but I am still learning more about reading those. I have a performance log, but I don't see any way to attach it here.

WB

 

[ptheriault]

What is your avg max page life expectancy and buffer cache hit ratio?

Max life should be about 300 and buffer cache should be above 90%. If your numbers are below those then you should add more memory. You may just want to go right to the 8 gb if it's in your price range.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

As far as what the physical sticks are you will need to either check the PO that the server was purchased under, call the vendor and ask them, or open the server and physically check the sticks and see what they are.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[wbodger]

Ahh yes... I had forgotten about the PO, working on that path right now so I can get the RAM ordered!