Recommended settings when using a Microsoft SQL Server database

0 users found this article helpful

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.