Symptoms
When the Microsoft SQL Server database is not correctly figured, you may encounter this error:
[FreeTDS][SQL Server]Transaction (Process ID xxx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Cause
The database is not correctly configured for Parallels Secure Workspace.
Resolution
It's highly recommended to adjust these database properties when using a Microsoft SQL database for the Parallels Secure Workspace nodes:
READ_COMMITTED_SNAPSHOT
ALLOW_SNAPSHOT_ISOLATION
Do so by running these SQL queries on your Microsoft SQL Server (replace 'workspacedb' with your own database name).
Important: this will kill active connections. However, the settings will be applied immediately so the impact should be minimal.
ALTER DATABASE workspacedb SET allow_snapshot_isolation ON;
ALTER DATABASE workspacedb SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE workspacedb SET read_committed_snapshot ON;
ALTER DATABASE workspacedb SET MULTI_USER;
Was this article helpful?
Tell us how we can improve it.