May 3, 2018 at 9:13 am
We're experiencing intermittent excessive paging (more often than not) with one of our servers.This is SQL Server 2014 EE. Server has 26 GB memory. One important thing - we are about to modify max memory which is set to default. Spoke to the application vendor, they pretty much said leave it. Don't quite agree with that.
Ran perfmon for 5 minutes this morning (got excessive paging), first with the "system performance" template, then a second using SQL Server Buffer Manager + SQL Server Buffer Manager. Reviewed and found the following:
Total Server Memory - ~ 22 GB
Target Server Memory - ~ 23 GB
SQL Server Buffer Cache Hit Ratio - > 90%
Lazy Writes per second / sec - 0
PLE - over 700 minutes
Avg / Minimum / Max
page faults per sec 972 / 731/ 3174
pages per second - 3.614 / 0 / 444
Any thoughts on this? Modify the max memory and revisit? Comments / URLs are appreciated - thanks.
May 3, 2018 at 9:46 am
Don't keep the default, Set to 3 or 4 gb less than total memory on server. (Depends on Local server load and other applications run in back end)
Did this server configured to use page file? If yes, then How much the page file size?
Also, Check the task manager and look for the application uses more memory....
If the top one is SQL, then run the query in ssms and look for Query consuming more memory and you may need to fix the query.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply