We are facing an urgent production issue in James Server 2.3.2 in Windows 2012R2. The spool table in MS SQL Server always get database DeadLock issue when the email volume is a bit high, peak hour can see several hundreds deadlocks. Monitoring shows the deadlock happened in the sql statement "(@P0 varbinary(8000), @P1 nvarchar(4000), @P2 nvarchar(4000) Update spool SET message_body=@P0 WHERE message_name=@P1 AND repository_name =@P2) Our spool definition: message_name varchar(200), repository_name varchar(255) We are using JDBC to connect. Version of MS SQL Server is 2014
Frank Tian