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 ...
Thanks for replying. I'm new to SharePoint and this company and everything was already deployed. We have a single server with only about 15 users. In Central admin is says role is custom. I'm not sure where to check if there's an alias or where the SP services are pointing.
Custom role means you are not taking benefits of the MinRole feature and you can decide every SP service startup on your own (as we are talking of a single server it's fine).
For checking the alias click on the server start and type "cliconfg.exe", the SQL Server Client Network Utility should pop up and you have the Alias tab to check whether an alias is present or not
You can match later the alias information with the Farm Information that you can find in the Servers in Farm tab in the Central Admin (/_admin/FarmServers.aspx)
To check the DB endpoint configured for the SP services, one option is to use the CA, click on "Manage Service Applications", select the SP Service then click on Properties. Another option is to use PowerShell
I ran the cliconfg and there wasn't any aliases. I went to service applications and there's not an SP listed.
the list you provided shows all the SP services configured in your farm (and relative proxy)
You have to click on each SP service (eg. App Management Service) and then select Properties on the top bar navigation. Do it only for the service (1st line) and not for the proxy (2nd line)
A pop up should appear showing the configuration of the service itself
From there you should be able to see the name of the Database and the SQL Instance.
Check if there is any discrepancies based on what you mention about the SQL Instance clone.
Side Note: You can also check if any SP major issue by analyzing the ULS logs. There is a diagnostic tool provided by MSFT for that: View diagnostic logs in SharePoint Server - SharePoint Server | Microsoft Docs
- 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)