Article Details
Id:21739
Product:finPOWER Connect
Type:NEW
Version:4.01.02
Opened:31/07/2024
Closed:01/08/2024
Released:12/09/2024
Job: J034011

Help, Support Information; added extra Database schema information for MS SQL Azure

On the Help, Support, Support Information Report, additional information has been added for MS SQL Azure databases.

This includes:

  • Isolation Level
    • Either "Unspecified", "Read Uncommitted", "Read Committed", "Repeatable Read", "Serializable" or "Snapshot".
    • Note, for finPOWER Connect this should always be "Read Committed".
    • A warning is shown if the Database Isolation Level is not 'Read Committed'.
  • Read Committed Snapshot Isolation
    • This indicates whether the Read Committed Snapshot Isolation (RCSI) is enabled for the database.
    • Only included enabled.
  • Snapshot Isolation State
    • This describes the state of the Snapshot Isolation feature in the database.
    • Note, the MS Azure database default is ON, i.e. the default is Read Committed Snapshot Isolation (RCSI).
    • Only included if enabled.
  • Database Table Information
    • Statistics about number of rows, sizes etc