Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How do you know how much RAM you need? Expand / Collapse
Author
Message
Posted Monday, August 26, 2013 11:21 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 6:18 AM
Points: 53, Visits: 220
Running the System Diagnostics Report (a Performance Monitor built in report) on a Windows Server 2008 R2 running SQL Server 2008 shows "The system is experiencing excessive paging" each monring for a few hours. This time frame is when we are doing a database 'load' from a different database (not MSSQL).

The server has 16 GB RAM and is capable of 64 GB. There are other servers that may be available that can have a lot more RAM (like 384 GB).

How do you know how much RAM is needed to avoid performance issues?






Post #1488469
Posted Tuesday, August 27, 2013 3:45 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:05 AM
Points: 1,528, Visits: 5,172
First question--what's your maximum server memory set to for SQL server?
Post #1488650
Posted Tuesday, August 27, 2013 6:05 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 6:18 AM
Points: 53, Visits: 220
Maximum server memory = 13500 MB.

Other memory options
Index creation memory = 0 (dynamic memory)
Maximum memory per query - 1024 KB
Post #1488702
Posted Tuesday, August 27, 2013 6:22 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:05 AM
Points: 1,528, Visits: 5,172
Hmmm. That sounds like a reasonable sort of setting provided you aren't running anything else but SQL on the machine--I was thinking SQL server might be trying to take too much memory and that was causing the paging. Might be worth lowering it a bit anyway and see if that helps.
Post #1488707
Posted Tuesday, August 27, 2013 12:41 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, February 04, 2014 9:35 AM
Points: 1,277, Visits: 1,612
Generally speaking you want to have a PLE (Page Life Expectancy) > 300 (5 minutes). In other words, you want your pages in memory to stay in memory a relatively long time, so they're not constantly being swapped in and out.


Post #1488907
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse