Performance issue on SHarePoint server workflow settings option from SHarePoint site settings

sns 9,231 Reputation points
2023-05-31T16:57:39.1366667+00:00

Performance issue on SHarePoint server workflow settings option from SHarePoint site settings

When we click on site settings and site features and mostly when workflow settings, page is loading very slow ( 30 to 40 seconds) . Please clariyf following 3 questions:

1.

how do we know which application is consuming more memory and causing slowness issue?

2.

I am aware that I need to check worker processer, but what exactly need to check from worker processor and is there any command to list out which application is causing high memory? If yes kindly share.

3.

apart form from worker process what else we can check and get the data?

Thank you.

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,297 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Ling Zhou_MSFT 15,475 Reputation points Microsoft Vendor
    2023-06-01T08:54:24.0033333+00:00

    Hi @sns,

    Thank you for posting in the community.

    In your question, is the page slow to open or is the page slow to open when you activate a site feature? Do you have this problem with all sites?

    According to my knowledge, when you activate a site feature it is very slow, 30-40 seconds is normal, for example when you activate the publishing infrastructure feature.

    It's hard to be sure that the slow page opening is due to a certain application consuming a lot of memory, because for example your site has a lot of features activated which can also cause a slow page opening.

    For your first question, the memory consumed by the application is approximately equal to the size of its database. You can use this PowerShell command to see the size of all the application's databases.

    Get-SPDatabase | Sort-Object disksizerequired -desc | Format-Table Name, @{Label ="Size in MB"; Expression = {$_.disksizerequired/1024/1024}}
    

    For your second and third questions, I'm sorry that we can't see in the worker processes which application is causing high memory. Maybe you can find some three-party tools to view this information.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.