<div>
Regarding upgrading the memory, that is up to you to decide, but you can use the Server 2008 utility Performance Monitor to see how the server performs. As RAM is cheap, I would certainly consider putting more RAM in to the server if it can take more, and you are running Server 2008 64 bit (for more than 4GB total RAM).
</div>


Regarding upgrading the memory, that is up to you to decide, but you can use the Server 2008 utility Performance Monitor to see how the server performs. As RAM is cheap, I would certainly consider putting more RAM in to the server if it can take more, and you are running Server 2008 64 bit (for more than 4GB total RAM).

<div>
Hello AdoBeebo,<br />
<br />
we are using windows server 2008 64bit with 8GB RAM and it's database server so the only main application is MS. SQL server 2008. <br />
<br />
I open the Performance Monitor but still could not analyse and decide when we need to add more RAM or not.<br />
In Reliability and Performance on Memory tab there are header fields:<br />
Image, PID, Hard Faults/min, Commit, Working Set (KB), Shareable (KB), Private (KB)<br />
<br />
is it from above fields we should analyse?<br />
<br />
Kindly advise.<br />
<br />
Thank you.<br />
<br />
<br />
<br />
<br />
<br />

</div>


Hello AdoBeebo,

we are using windows server 2008 64bit with 8GB RAM and it's database server so the only main application is MS. SQL server 2008.

I open the Performance Monitor but still could not analyse and decide when we need to add more RAM or not.
In Reliability and Performance on Memory tab there are header fields:
Image, PID, Hard Faults/min, Commit, Working Set (KB), Shareable (KB), Private (KB)

is it from above fields we should analyse?

Kindly advise.

Thank you.







<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
There's some time our database server's memory reach the maximum available memory.<br />
Is is a common thing in MS. SQL Server 2008?<br />
<br />
Someone said that SQL server2008 &nbsp;just takes all the memory available and will release some back what's not needed when Windows OS asks for it. <br />
If so.. then how we know when we need to upgrade the server's memory?<br />
<br />
Kindly advise.<br />
<br />
Thank you.<br />
<br />

</div>
</div>


Dear Experts,

There's some time our database server's memory reach the maximum available memory.
Is is a common thing in MS. SQL Server 2008?

Someone said that SQL server2008  just takes all the memory available and will release some back what's not needed when Windows OS asks for it. 
If so.. then how we know when we need to upgrade the server's memory?

Kindly advise.

Thank you.



MS SQL Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.