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.