crcsupport
asked on
Memory Leak in Windows 2012, Non-Paged pool 8.5GB
Windows Server 2012 STD
32GB RAM
SQL 2008 STD Server running. (MAX ram reserved 18GB)
Hyper-V installed, runs 1 virtual guest (Windows 2012, MAX ram 4GB)
I think my server has memory Leak. Memory in Task Manager doesn't add up. So, I did some research and it shows that the non-paged pool reached limit. Microsoft says it starts with 3% of total physical memory which is around 1GB in my case. But it reached the non-paged pool 8.5GB.
I turned off SQL server and Hyper-V guests, then restarted the server, still it shows 8GB non-paged pool. So I guess it's not related to Hyper-V or SQL.
I tried to find a Poolman.exe file to pin-point where the leak comes from, but it's not available for Windows 2012.
If you have experienced this problem and troubleshooted before, please advise.
Thank you.
32GB RAM
SQL 2008 STD Server running. (MAX ram reserved 18GB)
Hyper-V installed, runs 1 virtual guest (Windows 2012, MAX ram 4GB)
I think my server has memory Leak. Memory in Task Manager doesn't add up. So, I did some research and it shows that the non-paged pool reached limit. Microsoft says it starts with 3% of total physical memory which is around 1GB in my case. But it reached the non-paged pool 8.5GB.
I turned off SQL server and Hyper-V guests, then restarted the server, still it shows 8GB non-paged pool. So I guess it's not related to Hyper-V or SQL.
I tried to find a Poolman.exe file to pin-point where the leak comes from, but it's not available for Windows 2012.
If you have experienced this problem and troubleshooted before, please advise.
Thank you.
ASKER
Do you have your server up to date with windows updates ? No, last time update was done is Sept,2015
Is your page file set to specific size or is it managed by OS ? Automatic. But page file size in C driver is 4.7GB. I don't think this is.
Is your page file set to specific size or is it managed by OS ? Automatic. But page file size in C driver is 4.7GB. I don't think this is.
ASKER
Actually it's NON paged memory.
I am trying to find what's causing, As I read, it's caused by driver problem since non paged pool is related to it.
For quick remedy, is there any way to limit the non-paged pool? and is there any bad consequence of doing it?
For the complete detection, poolman.exe is not downloadable and not available for windows 2012.
Instead, I downloaded Process Explorer and added a column 'Non paged', it shows only less than 1000K for each process.
I am trying to find what's causing, As I read, it's caused by driver problem since non paged pool is related to it.
For quick remedy, is there any way to limit the non-paged pool? and is there any bad consequence of doing it?
For the complete detection, poolman.exe is not downloadable and not available for windows 2012.
Instead, I downloaded Process Explorer and added a column 'Non paged', it shows only less than 1000K for each process.
What's your server vendor ?
try this cmd:
findstr /m /l MPP *.sys
and let me know name of sys files
try this cmd:
findstr /m /l MPP *.sys
and let me know name of sys files
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ok LSI drivers might be causing this issue, so update you LSI raid/host controller drivers
ASKER
The server has HP Smart Array P420i and when I tried to update driver through Comptuer Management, it says it's up to date
Do you mean like Computer - Device Manager ? Update Drivers
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i am trying to go to HP website to download, it seems they have problem today.
I'm updating windows server right now 200 updates.
I'm not sure it will also update the driver.
Do you think it's good idea limiting non paged pool like this until I can update drivers?
https://www.youtube.com/watch?v=ehediyLH8tI
I'm updating windows server right now 200 updates.
I'm not sure it will also update the driver.
Do you think it's good idea limiting non paged pool like this until I can update drivers?
https://www.youtube.com/watch?v=ehediyLH8tI
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I will check that on my server in a minute
ASKER
I found the fking problem.
I always didn't like it, it never defrag, but it claims it does. It's Diskeeper.
I was asked by another colleague to install it to defrag SQL file, it never does. I just left it, it shows all kinds of 'real-time' I/O elimination it claims. What it does is, it intercepts I/O between disk and Windows and sometime their own definition of intelligent file defragmentation prevention works, they claim.
I uninstalled it, it drops non-paged pool right away. Before that, it was sucking up memory from SQL server, dropped from 20GB to 7GB reserved for SQL.
What a disaster, this clumsy software, I was about to pay 400 dollars to get licensed.
I always didn't like it, it never defrag, but it claims it does. It's Diskeeper.
I was asked by another colleague to install it to defrag SQL file, it never does. I just left it, it shows all kinds of 'real-time' I/O elimination it claims. What it does is, it intercepts I/O between disk and Windows and sometime their own definition of intelligent file defragmentation prevention works, they claim.
I uninstalled it, it drops non-paged pool right away. Before that, it was sucking up memory from SQL server, dropped from 20GB to 7GB reserved for SQL.
What a disaster, this clumsy software, I was about to pay 400 dollars to get licensed.
Good news, I was about to give you links for registry
ASKER
Can you give me the links you found?
Windows 2012 doesn't have NDU key which was shown in the video.
I like to keep it as reference for future.
Windows 2012 doesn't have NDU key which was shown in the video.
I like to keep it as reference for future.
ASKER
By the way, it was actually disk related issue. I would have not been able to find the problem if you didn't mention it. Thanks.
ASKER
Now it dropped to 272MB lol. I can allocate 20GB to SQL again.
That's what I though ,when the command showed Raid controller drivers
In case you will need this for reference :
[HKEY_LOCAL_MACHINE\SYSTEM \CurrentCo ntrolSet\C ontrol\Ses sion Manager\Memory Management]
[HKEY_LOCAL_MACHINE\SYSTEM \ControlSe t001\Contr ol\Session Manager\Memory Management]
[HKEY_LOCAL_MACHINE\SYSTEM \ControlSe t002\Contr ol\Session Manager\Memory Management]
Non Paged Pool : Select Decimal and Change value to 192
[HKEY_LOCAL_MACHINE\SYSTEM \ControlSe t001\Servi ces\Null]
Controlset001- Services- Null- right side Start : change value to 4
In case you will need this for reference :
[HKEY_LOCAL_MACHINE\SYSTEM
[HKEY_LOCAL_MACHINE\SYSTEM
[HKEY_LOCAL_MACHINE\SYSTEM
Non Paged Pool : Select Decimal and Change value to 192
[HKEY_LOCAL_MACHINE\SYSTEM
Controlset001- Services- Null- right side Start : change value to 4
ASKER
Ah.. that's it. Null. I don't know what that's for, but I see the key in registry.
Well I'm glad it's working now for you
ASKER
Yes, it was actually driver issue by Diskeeper I guess.
I checked Paged pool, all processes, non.
Diskeeper uses so called 'intelligent I/O' which intercepts I/O and defrag between Windows Kernel and Disk. That's why it's using Non paged pool and doesn't shows in Paged pool I guess.
I checked Paged pool, all processes, non.
Diskeeper uses so called 'intelligent I/O' which intercepts I/O and defrag between Windows Kernel and Disk. That's why it's using Non paged pool and doesn't shows in Paged pool I guess.
Glad you found the culprit
ASKER
Thank you, David. YOu saved my life
David Fiala that is.. I joined really late to the game and didn't refresh until you had already solved the problem
Is your page file set to specific size or is it managed by OS ?