Spotfire Server: How to resolve SQL Server database error "Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim"

Summary:

When Spotfire Server uses SQL Server as its metadata database, it's possible to see occasional instances of this error in Spotfire Server's server.log file:

Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction

Resolution:

To reduce the likelihood of encountering these errors, apply SQL Server's Multi-Version Concurrency Control (MVCC)/Row versioning mode by using the setting READ_COMMITTED_SNAPSHOT, as mentioned in this document:

https://docs.tibco.com/pub/spotfire_server/latest/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/setting_up_the_spotfire_database_(sql_server).html