Forum Discussion
Help VMware esxi vm High CPU running SharePoint server 2019
Environment: VMware esxi vm running SharePoint server 2019 on Server 2019. Issue: We had to reboot the server while working another issue. Since about that time the VM CPU usage has been way up. It ...
I wish I knew what I was looking at .. I've read somewhere to look at the Correlation ID but the script never finishes.
eg: Get-SPLogEvent | ?{$_.Correlation -eq "6922c76b-32f7-4e2e-af96-fbda88a77fa5"}
I did use PowerShell to view to 'critical' errors. Here's a few of the errors:
-w3wp.exe: All query processing components are in 'Failed' status.
-Unknown SQL Exception 18452 occurred. Additional error information from SQL Server is included below. Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
-UsageAnalyticsTimerJob-xxxxxxxxxxxxxxxxx : Failed to retrieve Analysis Engine Service.
-The Execute method of job definition Microsoft.Office.Server.UserProfiles.FeedCacheRepopulationJob (ID xxxxxxxxxxxxxxxxxx) threw an exception. More information is included below. There are no addresses available for this application.. (Correlation=xxxxxxxxxxxxxxxxxxx)
eg: Get-SPLogEvent | ?{$_.Correlation -eq "6922c76b-32f7-4e2e-af96-fbda88a77fa5"}
I did use PowerShell to view to 'critical' errors. Here's a few of the errors:
-w3wp.exe: All query processing components are in 'Failed' status.
-Unknown SQL Exception 18452 occurred. Additional error information from SQL Server is included below. Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
-UsageAnalyticsTimerJob-xxxxxxxxxxxxxxxxx : Failed to retrieve Analysis Engine Service.
-The Execute method of job definition Microsoft.Office.Server.UserProfiles.FeedCacheRepopulationJob (ID xxxxxxxxxxxxxxxxxx) threw an exception. More information is included below. There are no addresses available for this application.. (Correlation=xxxxxxxxxxxxxxxxxxx)
It seems you have multiple issues:
- The Search Service seems to be in error state (w3wp error message)
- You have login issues in SQL instance (you have to debug using SQL logs to see which is the exact account/s generating issues and where it is used in SharePoint)
- The UsageAnalyticsTimerJob is correlated with the Search Service error state
- The User Profile service error could be caused by the Distributed Cache Service. The log does not says much, you have to check deeper in the ULS logs
Log into the SharePoint server
Open the SharePoint PowerShell Management Console
Try to Resume the search via PowerShell
$ssa = Get-SPEnterpriseSearchServiceApplication Resume-SPEnterpriseSearchServiceApplication $ssa- Well.. I went to Reset Index and got an error. Then I noticed in CA an link to 'Resume/Pause' so I clicked resume and got error "There was no endpoint listening at net.tcp://ServerNameHere/2B8A34/AdminComponent1/Management/NodeController that could accept the message. This is often caused by an incorrect address or SOAP action"
Yes this fix the issue usually 90% of time.
Remember that when you perform the index reset, no search result will appear for some time, SP takes time to index again all contents.
Depending on the volume of documents you have, you may schedule it during the week-end / outside business hours
