Enable remote workers to send and receive fax via email.   LEARN MORE

Sales: 978-367-3655
Support: 978-250-8355

SFT site performance slows when using Microsoft SQL Server

Biscom

Biscom

SFT Site Performance

After some usage on a site that is using Microsoft SQL Server as the database, performance can greatly degrade and the site can even become unavailable.

This is caused by the default Maximum Degree of Parallelism configured by default.

  1. Edit the %BDS_HOME%\config\fds.properties file and uncomment the following line:
    bql.sqlserver.query.hint = OPTION (MAXDOP 1)
  2. Stop and then start the Apache Tomcat service

The above line suppresses parallel plan generation, so operations are generated serially across CPUs.

recent posts

stay up to date

Stay in the know with our latest product updates

tags