nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Table deadlocks

Eugene_Ochkurov

Hi.

We`ve started MS SQL profiler and discovered a lot of deadlocks of system tables LLCache and DFacetCahe. Is it normal situation?

Our conf: MS SQL 2008 R2, Content Server 2010 upd8

Find more posts tagged with

Comments

Kyle_Swidrovich

Hi Eugene,

Do you have read_committed_snapshot enabled?

Kyle

Eugene_Ochkurov

We have turned on ALLOW_SNAPSHOT_ISOLATION ON and TRANSACTION ISOLATION LEVEL SNAPSHOT and got significant
performance degradation of SQL queries to db.

David Templeton

Eugene

When CS creates a new database now (after CS10U8), the following is the only setting that is changed:

ALTER DATABASE DatabaseName SET READ_COMMITTED_SNAPSHOT ON

You do not need the transaction isolation setting, that is probably accounting for the performance drop. Turn off the “TRANSACTION ISOLATION LEVEL SNAPSHOT” and verify the performance

Regards

David Templeton

OpenText Corporation

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Tuesday, February 26, 2013 1:33 AM
To: eLink Recipient
Subject: Table deadlocks 2

Table deadlocks 2

Posted bye.ochkurov@sibcon-soft.ru (Ochkurov, Eugene) On 02-26-2013 01:27

We have turned on ALLOW_SNAPSHOT_ISOLATION ON and TRANSACTION ISOLATION LEVEL SNAPSHOT and got significant
performance degradation of SQL queries to db.

[To post a comment, use the normal reply function]
Topic:	Table deadlocks
Forum:	Content Server Development Forum
Content Server:	Knowledge Center