SQL Server 2014

Shawn
Shawn used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vitor MontalvãoIT Engineer
Distinguished Expert 2017
Commented:
Which version, edition and architecture of SQL Server are you using?
What DBCC MEMORYSTATUS returns?
ShawnSr. Network Administrator
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 Developer

Commented:
What is your exact error?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

ShawnSr. Network Administrator

Author

Commented:
Message
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
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.

https://technet.microsoft.com/en-us/sysinternals/rammap.aspx

Might help to look into memory leaks.

Good luck.
Senior Developer
Commented:
This is not an error. Sounds like you need to configure Enable the Lock Pages in Memory Option (Windows).
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
I agree with ste5an.
Microsoft has a support article for this kind of behavior.
ShawnSr. Network Administrator
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 Administrator

Author

Commented:
xx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial