Hi, 

We are seeing an increasing number of dead locks against our EpiServer DB. The offending queries are below.

Does anyone have any ideas about what these queries are doing and is there someway we can identity the issue?

The big offender is an adhoc query:

EXEC sp_executesql @DynSql,

      N'@PageID INT, @LangBranchID NCHAR(17), @Boolean BIT, @Number INT, @PageType INT, @PageLink INT, @Date DATETIME',

      @PageID=@PageID,

      @LangBranchID=@LangBranchID,

      @Boolean=@Boolean,

      @Number=@Number,

      @PageType=@PageType,

      @PageLink=@PageLink,

      @Date=@Date   

The other side of the deadlock:

INSERT INTO

               tblProperty

               (fkPageID,

               fkPageDefinitionID,

               ScopeName,

               Number,

               Boolean,

               [Date],

               FloatNumber,

               PageType,

               String,

               LinkGuid,

               PageLink,

               LongString,

               fkLanguageBranchID)

            VALUES

               (@PageID,

               @PageDefinitionID,

               @ScopeName,

               @Number,

               @Boolean,

               @Date,

               @FloatNumber,

               @PageType,

               @String,

               @LinkGuid,

               @PageLink,

               @LongString,

               @LangBranchID   

And this is another example:

DELETE FROM

      tblContentProperty

   FROM

      tblContentProperty

   INNER JOIN

      tblPropertyDefinition ON fkPropertyDefinitionID=tblPropertyDefinition.pkID

   WHERE

      fkContentID=@ContentID AND

      fkContentTypeID IS NOT NULL AND

      fkLanguageBranchID=@LangBranchI