SQL Server 2014

We have a server using SQL 2014.  It give a memory paged out error every minute.  We have 32 GB on the server.  SQL is limited to 23 GB.
At the current time, we only have on small database running on it.  (with plans to move some more).  Task manager is showing we are only using 7% of memory.  Yet we continue to get errors.  We have installed all of the service packs.  Tried different settings for SQL memory.  We have tried many suggestions, and nothing seems to work.  Any ideas?  Thinking of going back to 2012
ShawnSr. Network AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Which version, edition and architecture of SQL Server are you using?
ShawnSr. Network AdministratorAuthor Commented:
Sql Server 2014 64 Bit 32 GB Memory Windows Server 2012 R2 VMWare for the Virtual Platform

Process/System Counts      Value
Available Physical Memory      31560871936
Available Virtual Memory      140692024164352
Available Paging File      36430192640
Working Set      193744896
Percent of Committed Memory in WS      56
Page Faults      10260211
System physical memory high      1
System physical memory low      0
Process physical memory low      0
Process virtual memory low      0

Memory Manager      KB
VM Reserved      43997904
VM Committed      332680
Locked Pages Allocated      0
Large Pages Allocated      0
Emergency Memory      1024
Emergency Memory In Use      16
Target Committed      23552000
Current Committed      332680
Pages Allocated      150704
Pages Reserved      0
Pages Free      2632
Pages In Use      296872
Page Alloc Potential      22077528
NUMA Growth Phase      0
Last OOM Factor      0
Last OS Error      0
ste5anSenior DeveloperCommented:
What is your exact error?
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

ShawnSr. Network AdministratorAuthor Commented:
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 146084, committed (KB): 289384, memory utilization: 50%.

We get this every minute
Dan LuteyCommented:
RAMMAP is a good tool to release Memory until you find the cause. When you open RAMMAP select empty, then select empty standby list. This will clear out paged memory.


Might help to look into memory leaks.

Good luck.
ste5anSenior DeveloperCommented:
This is not an error. Sounds like you need to configure Enable the Lock Pages in Memory Option (Windows).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
I agree with ste5an.
Microsoft has a support article for this kind of behavior.
ShawnSr. Network AdministratorAuthor Commented:
Thank you for you help with this issue.  My Sys Admin has to go offsite for awhile and has been unable to try these suggestions.  I will close this for now and re-open if I have an additional problmes
ShawnSr. Network AdministratorAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.