Does CA_UIM database support RCSI (Read Committed Snapshot Isolation) setting?
search cancel

Does CA_UIM database support RCSI (Read Committed Snapshot Isolation) setting?

book

Article ID: 265727

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Our DBA recommended enabling RCSI (Read Committed Snapshot Isolation) setting on the CA_UIM database to avoid frequent blockings. Is this setting supported?

Environment

Release: 20.4

Resolution

Yes, UIM DBA confirmed RCSI may help the database performance but your DBA should read, review and consider all the advantages/disadvantages.

Read Committed Snapshot Isolation (RCSI)