Mark Minasi's Tech Forum
Register Calendar Latest Topics Chat
 
 
 


Reply
  Author   Comment  
cspanburgh

Avatar / Picture

Senior Member
Registered:
Posts: 202
Reply with quote  #1 
Windows detected your registry file is still in use by other applications or services. The file will be unloaded now. The applications or services that hold your registry file may not function properly afterwards.  
 
 DETAIL - 
 1 user registry handles leaked from \Registry\User\S-1-5-21-731332549-44719175-629696583-30362:
So a client had a portal crash and CRM crash 5 days ago. I just got the call today.  Authentication errors were every on the app server.

I am thinking Mem pool exhaustion on Sql SERVER.  I WILL CHECK MORE IN a.M.

wHAT DO YOU FOLKS THINK.


__________________
Curt Spanburgh
0
cspanburgh

Avatar / Picture

Senior Member
Registered:
Posts: 202
Reply with quote  #2 
So the leak is a service under Srvhost.exe.   So how would one go about looking for the offending service e that has leakers in Server2012?    Cloud is making me on premise forgetful.
__________________
Curt Spanburgh
0
wobble_wobble

Avatar / Picture

Associate Troublemaker Apprentice
Registered:
Posts: 780
Reply with quote  #3 
Process Monitor + Process Explorer.

Also performance monitor.

Curt only different now is you can't kick
a. The Server
b. The host
c. The Data Center remote hands
d. The owner of the kit


__________________
Have you tried turning it off and walking away? The next person can fix it!

New to the forum? Read this
0
cspanburgh

Avatar / Picture

Senior Member
Registered:
Posts: 202
Reply with quote  #4 
Well here is the "Revisited" reply.

So the User Profile Service event ID: 1530 is on my lag SQL server as well.


Much of the TechNet post has Microsoft saying that this s by design when the OS closes the program after the user disconnects.

I was able to ID the SIDS with the wmic command at the command prompt using:
wmic useraccount get name, sid

This statement will return the SID and the user name.

With this I could ID the user account were the error occurred.   Since this is a SQL server on VMware, I did some searching and did see that there are some people having issues with Memory leaks on SQL server VMWARE VIRTS and that there is an update for that.

Either way I did not see much with Process Explorer or performance monitor.   If it's a leak it's a very slow one compared to what I have seen in the past.    ADFS on the application server and email was failing authentication.     I still wish I could nail the cause since it is a production income producing site.

Any suggestions are appreciated.







__________________
Curt Spanburgh
0
wobble_wobble

Avatar / Picture

Associate Troublemaker Apprentice
Registered:
Posts: 780
Reply with quote  #5 
Curt

Is there a memory leak?
Can you see memory usage growing over time (days even)

Few things I'd start with
Disable TCP Chimney and NetDMA

Disable TCP Chimney Offload

1. netsh int tcp set global chimney=disabled

2. netsh int tcp set global rss=disabled

3. netsh int tcp set global netdma=disabled

4. Restart the server.

You may wish to disable NetDMA

To enable or disable NetDMA, follow these steps:

  1. Click Start, click Run, type regedit, and then click OK.

  2. Locate the following registry subkey, and then click it:

  3. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

  4. Double-click the EnableTCPA registry entry.

  5. Note If this registry entry does not exist, right-click Parameters, point to New, click DWORD Value, type EnableTCPA, and then press ENTER.

  6. To enable NetDMA, type 1 in the Value data box, and then click OK.

  7. To disable NetDMA, type 0 in the Value data box, and then click OK.

  8. If the EnableTCPA registry entry does not exist, enable the NetDMA functionality.

VMware guide advices enabling RSS
https://blogs.vmware.com/apps/2016/03/updated-architecting-microsoft-sql-server-on-vmware-vsphere-best-practices-guide.html

I think i may have posted other repairs I had on SQL on VMware on the old forum, can't find the document for the repairs 

__________________
Have you tried turning it off and walking away? The next person can fix it!

New to the forum? Read this
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation: