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 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply