Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How much RAM is required?

Author  Topic 

yalgaar
Starting Member

43 Posts

Posted - 2008-12-09 : 15:10:38
Just trying to understand basics on memory requirement for a SQL server.

If I have a servers with 64GB of RAM, how can I be sure that this is actually what is needed for this specific servers at this moment of time? I don't want to use 64GB of RAM if I could do with only 32GB or 16GB. Is there any specific performance counters I should be monitoring to find this out?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-09 : 15:50:44
How big is your database? How active is it? How many concurrent connections will there be? How many transactions per second? What are your performance expectations?

How many CPUs does it have? What's the IO look like?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

yalgaar
Starting Member

43 Posts

Posted - 2008-12-10 : 13:23:19
I am not a SQL guy. The server is UP and running already and it is in production. I want to find out of the exisiting physical memory is a botttle neck? If not have I over populated physical memory?
I want to find this out based on current use.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-10 : 13:44:42
You can check this by running various counters in Performance Monitor.

Page life expectancy
Buffer cache hit ratio
Page faults/sec
Total server memory
Target server memory

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -