Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

v7.1.0 was released on TBD for in-house customers.

Configure Snapshot Isolation for SQL Server Databases

If you are using SQL Server as your external database, you must configure Snapshot Isolation to minimize deadlocks only for your frevvo database schema. This is recommended when you are setting up SQL Server for the first time or you are upfrading

Although MySQL and Oracle databases are set up to do this by default, SQL Server is not.

It is recommended that SQL Server customers should at the minimum:

  • Turn on the READ COMMITTED SNAPSHOT setting in the database to ensure that reads don’t block writes.

This can be done:

  1. Using DDL ( data Definition Language) - Run the commands listed below

    Code Block
    ALTER DATABASE <your frevvo database schema> - replace <your frevvo database schema> with the name of your frevvo database schema then execute the statement below:SET READ_COMMITTED_SNAPSHOT ON
  2. Using SQL Server Management Studio:
  • Turn on the “Is Read Committed Snapshot On” Option under database properties

 

New Submissions View

The New Submissions View provides the ability to search submissions by fields in your form/flow, metadata fields or logical expressions that you create. The UI makes it very easy to specify search criteria. The Legacy Submissions view is also available in this release but...

...

  You do not have to restart the Insight server every time you restart

Frevvoproduct
.


 

This is the SQL Server article on minimizing deadlocks. It is recommended that SQL Server users should at the minimum:

Turn on the READ COMMITTED SNAPSHOT setting in the database to ensure that reads don’t block writes.

 

This can be done using DDL:

ALTER DATABASE MyDatabase

SET READ_COMMITTED_SNAPSHOT ON

 

Or it can be done via the SQL Server Management Studio (“Is Read Committed Snapshot On” Option under database properties)