We have a problem with Webcon BPS (after upgrading from 2017_1_3.540 to 2017_1_3.665) runing on SharePoint 2013 Foundation web app. After saving processes in BPS Designer Studio we have a timeouts from content database where elements are writing.

  • Running on SQL Server 2016.
  • BPS_Content weighs 231GB and BPS_Content_Att weighs 740GB.
  • Server has 4vcores 2.30GHz and 16GB RAM, databases and logs are on a different disks.

We know that this is because the large database and low performance of SQL Server. But, is there any way to get better performance from a server configuration way? Or optionally increase timeouts for saving elements from Designer Studio to database?

We've read a lot of articles, but still SQL Server is weakest performance point of the infrastructure.

Browse other questions tagged or ask your own question.