Database Deadlocking

Vote:
 

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    

#144787
Feb 18, 2016 17:55
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.