SharePoint 2016 performance

Mario 121 Reputation points

Current situation: We have a SP farm (2016) with only 2 servers (app and database). It has 30 site collections and each collection cca 25 document libraries. Total amount of data in these site collections (in a single content db) is around 700 GB. And we use SharePoint 2013 workflows.

Problem: Lately, users experience enormous degradation of performance when they start workflows or try to upload documents. And it doesn't happen every day, there are days when everything works fine.

I don't see any problems on application server, so my doubt is the database. We haven't found any limitations on allowed number of workflows on the SP server, currently, but we have 90000 sharepoint 2013 workflows that are still in "Started" state. Could that number of running workflows be the problem?

SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,596 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Elsie Lu_MSFT 9,791 Reputation points

    Hi @Mario ,

    In addition to trevorseward, you could check the requirements and boundaries according to the official documentations:
    Hardware and software requirements for SharePoint Server 2016

    And the official article also pointed out the restrictions on workflow:

    Software boundaries and limits for SharePoint Servers 2016 and 2019


    So I would suggest that you reduce your workflow load and check the specifications of your entire farm based on the above documents.

    If the 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.