SQL Deadlock errors and HEAT

Version 1

    Details

    How to address SQL Deadlock errors/issues and HEAT


    Resolution

    Deadlocks are caused when running a utility for Microsoft SQL Server, SQL stored procedures/triggers are running, or when some other application is accessing a particular table that HEAT tries to access.  A deadlock occurs when two system servers process IDs (SPIDs) are waiting for a resource and neither process can advance because the other process is preventing it from getting the resource.

    This is an issue that should be resolved between the SQL database administrator and the HEAT Administrator. This is specifically a back end database issue, and not a HEAT specific product issue.  HEAT does not inherently set DB locks.  SQL is actually in charge of lock allocation.