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.
| Author |
Topic |
|
bhatia333
Starting Member
1 Post |
 Posted - 2011-02-03 : 20:15:53
|
| I need help re a sql server question (and I may have to bug you more often if I cannot find answers on google).How to I find how much RAM SQL Server actually needs? I mean I have a Windows 2008 virtual server with 16 Gb RAM and and 2 Cores. I have a 60Gb SS 2008 R2 db on it and its using all the memory on the server. I know you can set the max memory parameter to restrict the amount of mem used by SS, but I first want to know how much memory does SS actually need (more is definitely better but we dont want to add more memory so that SS uses all of that too). The perfmon counters just display that its using all the memory available. My question is how to find how much memory is needed by sql server.Secondly what is the best method to scale SS? I mean adding more mem and CPU is one way...what else should we be looking into?Your help is highly appreciated. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-04 : 00:05:26
|
| Restrict SQL to about 13.5 GB -- leaving 2.5 for the OS.Then monitor:- Page Life Expectancy- Total Server Memory- Target Server Memory- Buffer Cache hit Ratio |
 |
|
|
|
|
|
High Memory Usage