question

AhmedShadai-8427 avatar image
0 Votes"
AhmedShadai-8427 asked YiLu-MSFT commented

Sharepoint managed metadata service proxy is very slow

Hi,

I recently began to have performance issues with the managed metadata service in sharepoint 2013 enterprise, it is very slow:
- In termstoremanager.aspx site page - takes around 1 minute to show up and expanding a termset takes like 10-20 seconds to show up
- In a managed metadata column, it takes lot of time for the taxonomy terms to show up for values selection
- In site columns configuration, the term settings configuration takes like 1 minute to show up.

The same performance issue is reproduced when trying to access the above steps locally from the farm servers.

IISRESET or MMS reset didn't solved the issue.

Any advices ?

sharepoint-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YiLu-MSFT avatar image
0 Votes"
YiLu-MSFT answered AhmedShadai-8427 commented

Hi @AhmedShadai-8427
I want to confirm more information with you:

Has any recent changes caused this issue?

Do all users face the same experience, or only certain users?

Does this occur on all SharePoint servers? Please switch to other server to check the result.

Make sure you have enough CPU and Memory for the issued server and SQL server.

You can also use F12 developer tools to find any clues of the loading delay.


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @YiLu-MSFT: Any advices on this please ?

0 Votes 0 ·
AhmedShadai-8427 avatar image
0 Votes"
AhmedShadai-8427 answered YiLu-MSFT commented

Hi @YiLu-MSFT, thanks for the answer.

  • All users face the same issue.

  • It occurs on all servers.

  • As for the changes, except regular SP/OS patching's, not aware of other changes.

  • Developer tools - There is high timings in waiting response from the server.

Disk space/usage - Not checked for the moment

Also, I see recurrent certificate issues in event viewer "An operation failed because the following certificate has validation errors" CN=...,DC=....,DC=..., Thumbprint, SSL policy errors have been encountered. Error code 0x2'. However, the certificates are not expired and the web services pool certificate is valid..

EDIT: Disk space on filesystem seems ok

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AhmedShadai-8427

Per my research, the certificate has little to do with this performance issue.

Try to install Fiddler: Capture all HTTP(S) traffic between your computer and the Internet with Fiddler HTTP(S) proxy. Inspect traffic, set breakpoints, and fiddle with requests & responses.

To begin :WinConfig > exempt all

118573-image.png

By default, Fiddler Classic does not capture and decrypt secure HTTPS traffic. To capture data sent through HTTPS, enable HTTPS traffic decryption.

118546-image.png

Then use management metadata service as usual to check it> turn to Fiddler > Inspectors > Headers.

You could detect if there is any error or unusual respond will affect it:

118525-image.png

A server issues the status codes in response to a client's request in the form of a three-digit number. The first digit of the status code specifies one of five standard classes of responses.:

1xx informational response – the request was received, continuing process

2xx successful – the request was successfully received, understood, and accepted

3xx redirection – further action needs to be taken to complete the request

4xx client error – the request contains bad syntax or cannot be fulfilled

5xx server error – the server failed to fulfill a valid request

Here are some common response codes for reference:
HTTP/502: Bad Gateway

HTTP/503: Server Too Busy

HTTP/404: File Not Found

HTTP/429: Too Many requests

0 Votes 0 ·
image.png (82.8 KiB)
image.png (129.0 KiB)
image.png (121.5 KiB)

Hi @AhmedShadai-8427

Would you please provide some update of this issue? I am free to listen.

0 Votes 0 ·