August 26, 2013 at 11:21 am
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?
August 27, 2013 at 3:45 am
First question--what's your maximum server memory set to for SQL server?
August 27, 2013 at 6:05 am
Maximum server memory = 13500 MB.
Other memory options
Index creation memory = 0 (dynamic memory)
Maximum memory per query - 1024 KB
August 27, 2013 at 6:22 am
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.
August 27, 2013 at 12:41 pm
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy