Skip to Content

CMS DB deadlocks - CMSLock7 table

BI4.1 SP3 patch 3

MS SQL Server 2012

My client is seeing a lot of deadlocks on the CMSLock7 table in the CMS database.  The indexes are good and there is no fragmentation.  Does anyone know why this is happening?

-Dell

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 08, 2015 at 11:07 PM

    Hi Christy,

    Well, I would first suspect Platform search service.

    You can stop APS containing Platform search service for some hours to test the same. Till then, the search functionality from BI Launchpad will not be available.

    If this possibility is ruled out, you can get more information from DBA like:

    What are the queries which cause deadlocks?

    What is the time when you see frequent deadlocks?

    Is this peak time?

    What is the number of connections to CMS database (you can check it from CMS> Metrics)?

    Which server (among the cluster, if any) is querying?

    Hope this information helps 😊

    Regards,

    Onkar

    Add comment
    10|10000 characters needed characters exceeded