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
 General SQL Server Forums
 New to SQL Server Administration
 High Memory Usage

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
Go to Top of Page
   

- Advertisement -