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