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.
- Edit the %BDS_HOME%\config\fds.properties file and uncomment the following line:
bql.sqlserver.query.hint = OPTION (MAXDOP 1)
- Stop and then start the Apache Tomcat service
The above line suppresses parallel plan generation, so operations are generated serially across CPUs.