mssql server loads cpu to 100%

Question

1C

on the computer is 1c + mssql server 2005 (1c uses mssql as a database server). at a certain point in time, 1c began to freeze at startup and the mssql server process began to load cpu at 100% immediately after the computer was booted. apparently, some process hung and locked one of the tables. the screenshot from mssql management studio is attached:

this circumstance does not allow to do anything with the database: neither merge the dump, nor do the export. In Google, such symptoms are most often called sleeping locks, but the Googled ways to solve the problem do not help. did any of the habrausers encounter such a problem in mssql and how did they solve it? thanks in advance.

Answer 1

judging by the lock type RID, you do not have a clustered index on the table being processed, so all operations with it are slow. Build a clustered index. Which one, it's hard to say without seeing the structure of the table and not knowing the queries.