question

Mario-4616 avatar image
0 Votes"
Mario-4616 asked ·

SharePoint 2016 performance



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?

office-sharepoint-server-development
· 2
10 |1000 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.

Please provide the specification and estimated concurrent user count. Your farm is awfully small for such a large amount of content. A good place to start would be to add 2x DC+FE and another App+Search server; SQL sizing may need to be adjusted if you're running something with <16GB RAM, for example.

1 Vote 1 ·

Thanks for the reply. Yes, farm is rather small, and it gets worse. SQL server hosts 2 instances (I don't know why they did that, whoever they may be), one is SP db, and other is sth else. SP has 18 GB RAM out of 36 total (other instance gets other half). I know that this is serious f*, but this is how it is and I need to fix it :)

0 Votes 0 ·

1 Answer

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered ·

Hi @Mario-4616 ,

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

73655-2.jpg

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.



2.jpg (99.3 KiB)
· 1 ·
10 |1000 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.

Thanks for the answer.
Yes, I kon about that limitation, but there isn't anything about workflows that aren't currently executing, but are still running.

0 Votes 0 ·