Database locks in the Notification Server database

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

We are experiencing deadlocks in the Notification Server database almost daily and generally in the morning hours.  These continue over time and do not end.

Environment

ITMS 8.x

Cause

In this case, an older version of SQL server was being used. After upgrading to a newer version, the database locks continued and these were traced to the SQL compatibility settings used.

Resolution

Changed the SQL compatibility mode to SQL Server 2019.