mssql server loads the cpu to 100%

computer 1C+mssql server 2005 (1C uses mssql as the database server). at a certain point in time 1c started to hang at start-up and process mssql server started to load the cpu to 100% immediately after booting the computer. apparently, some process is put on hold and locked one of the tables. a screenshot of the mssql management studio pregleda:

this circumstance does not make the database absolutely nothing: neither to merge the dump or to export. Google these symptoms are often called sleeping locks, but naguglennye solutions to problems do not help. did someone from abrusio with this problem in mssql and how solved? thanks in advance.
October 8th 19 at 02:41
2 answers
October 8th 19 at 02:43
1. Regular 1C 7.7 does not work with SQL Server 2005 and older, and judging by the "_1SUSERS" — you have seven — that may be related to the part of the problem.
2. View exactly what occurs within this session. I would advise to use sp_whoIsActive, but to impose will not.
October 8th 19 at 02:45
according to lock type, RID, have you processed the table has no clustered index, so all operations on it slow. Build the clustered index. What exactly is hard to say without seeing table structure and without knowing the queries.

Find more questions by tags 1CSQL Server